ADR Utility

 SQL*Plus: Release 11.1.0.7.0 - Production on Fri Aug 31 12:09:09 2012

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Enter user-name: apps
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[testora@finprod10 ~]$
[testora@finprod10 ~]$
[testora@finprod10 ~]$
[testora@finprod10 ~]$ . /test/TEST/testdb/tech_st/11.1.0/TEST_finprod10.env
[testora@finprod10 ~]$ %]adrci
-bash: fg: %]adrci: no such job
[testora@finprod10 ~]$ adrci

ADRCI: Release 11.1.0.7.0 - Production on Fri Aug 31 12:10:54 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ADR base = "/test/TEST/testdb/tech_st/11.1.0/admin/TEST_finprod10"
adrci> show home
ADR Homes:
diag/rdbms/test/TEST
adrci> set homepath diag/rdbms/test/TEST
adrci> show problem

ADR Home = /test/TEST/testdb/tech_st/11.1.0/admin/TEST_finprod10/diag/rdbms/test/TEST:
*************************************************************************
PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
3                    ORA 7445 [kgldpo0()+1424]                                   93290                2011-11-30 15:01:10.642448 +05:30
2                    ORA 7445 [dbgrmqmqpk_query_pick_key()+2171]                 77194                2011-04-21 16:45:29.875489 +05:30
1                    ORA 7445 [ptkin()+350]                                      43472                2010-07-10 11:05:05.646824 +05:30
3 rows fetched

adrci> ips pack probelm in /tmp
DIA-48415: Syntax error found in string [ips pack probelm] at column [16]

adrci> ips pack problem in /tmp
DIA-48415: Syntax error found in string [ips pack problem in] at column [19]
DIA-48438: [in] is not a valid number

adrci> ips pack problem in /tmp
DIA-48415: Syntax error found in string [ips pack problem in] at column [19]
DIA-48438: [in] is not a valid number

adrci> IPS PACK PROBLEM IN /tmp
DIA-48415: Syntax error found in string [IPS PACK PROBLEM IN] at column [19]
DIA-48438: [IN] is not a valid number

adrci> IPS PACK PROBLEM 3 IN /tmp
Generated package 1 in file /tmp/IPSPKG_20120831121647_COM_1.zip, mode complete
adrci>