- Using sqlplus prompt check the location diagnostic file location.
set lines 200
col NAME for a50
col VALUE for a50
SELECT name, value FROM v$diag_info;
oracle@sgdcplm02:~> adrci
oracle@sgdcplm01:~> adrci -help
adrci> show incident
ADR Home = /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
57201 ORA 4031 2018-03-22 15:27:57.652000 +01:00
57202 ORA 4031 2018-03-22 15:28:01.143000 +01:00
57185 ORA 4031 2018-03-22 15:28:33.741000 +01:00
57186 ORA 4031 2018-03-22 15:28:35.431000 +01:00
57065 ORA 4031 2018-03-22 15:32:11.646000 +01:00
56998 ORA 4031 2018-04-19 21:35:53.990000 +02:00
56999 ORA 4031 2018-04-19 21:35:57.807000 +02:00
57000 ORA 4031 2018-04-19 21:35:59.521000 +02:00
59207 ORA 4031 2018-04-19 21:36:01.251000 +02:00
59208 ORA 4031 2018-04-19 21:36:02.932000 +02:00
56841 ORA 4031 2018-04-30 13:44:40.166000 +02:00
56842 ORA 4031 2018-04-30 13:44:44.128000 +02:00
56945 ORA 4031 2018-05-01 13:29:45.663000 +02:00
56946 ORA 4031 2018-05-01 13:29:49.617000 +02:00
56969 ORA 4031 2018-05-02 08:56:38.026000 +02:00
56970 ORA 4031 2018-05-02 08:56:50.693000 +02:00
56971 ORA 4031 2018-05-02 08:56:52.178000 +02:00
56972 ORA 4031 2018-05-02 08:56:55.567000 +02:00
56973 ORA 4031 2018-05-02 08:56:57.119000 +02:00
56889 ORA 4031 2018-05-02 14:25:25.394000 +02:00
57097 ORA 4031 2018-05-02 16:35:22.001000 +02:00
57098 ORA 4031 2018-05-02 16:35:26.076000 +02:00
57169 ORA 4031 2018-05-02 16:38:08.116000 +02:00
57209 ORA 4031 2018-05-02 18:09:05.799000 +02:00
57210 ORA 4031 2018-05-02 18:09:09.130000 +02:00
56985 ORA 4031 2018-05-04 11:12:07.000000 +02:00
56986 ORA 4031 2018-05-04 11:12:11.576000 +02:00
56905 ORA 4031 2018-05-04 11:57:12.841000 +02:00
56906 ORA 4031 2018-05-04 11:57:14.210000 +02:00
56907 ORA 4031 2018-05-04 11:57:16.004000 +02:00
55609 ORA 4031 2018-05-04 12:13:50.193000 +02:00
55610 ORA 4031 2018-05-04 12:13:54.372000 +02:00
55611 ORA 4031 2018-05-04 12:13:55.907000 +02:00
55612 ORA 4031 2018-05-04 12:13:57.455000 +02:00
55613 ORA 4031 2018-05-04 12:14:39.442000 +02:00
56865 ORA 4031 2018-05-04 13:18:53.301000 +02:00
56866 ORA 4031 2018-05-04 13:18:54.845000 +02:00
56867 ORA 4031 2018-05-04 13:18:55.972000 +02:00
56937 ORA 4031 2018-05-04 13:33:44.904000 +02:00
56938 ORA 4031 2018-05-04 13:33:46.180000 +02:00
56962 ORA 4031 2018-05-05 11:12:41.345000 +02:00
56963 ORA 4031 2018-05-05 11:12:43.702000 +02:00
56964 ORA 4031 2018-05-05 11:12:45.192000 +02:00
56965 ORA 4031 2018-05-05 11:12:47.690000 +02:00
56966 ORA 4031 2018-05-05 11:12:49.226000 +02:00
55615 ORA 4031 2018-05-05 13:06:14.143000 +02:00
55616 ORA 4031 2018-05-05 13:06:21.174000 +02:00
59254 ORA 4031 2018-05-05 13:06:22.670000 +02:00
59255 ORA 4031 2018-05-05 13:06:26.469000 +02:00
59256 ORA 4031 2018-05-05 13:06:29.736000 +02:00
ADR Home = /u02/app/oracle/diag/clients/user_oracle/host_1505528871_82:
*************************************************************************
0 rows fetched
ADR Home = /u02/app/oracle/diag/tnslsnr/sgdcplm02/smrpro_listener:
*************************************************************************
0 rows fetched
ADR Home = /u02/app/oracle/diag/tnslsnr/sgdcplm02/listener:
*************************************************************************
First 0 rows fetched (*** more available ***)
adrci> show problem
adrci> show control
DIA-48448: This command does not support multiple ADR homes
adrci> show incident -mode detail -p "incident_id=59256"
ADR Home = /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 59256
STATUS ready
CREATE_TIME 2018-05-05 13:06:29.736000 +02:00
PROBLEM_ID 1
CLOSE_TIME <NULL>
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 4031
ERROR_ARG1 52520
ERROR_ARG2 shared pool
ERROR_ARG3 SELECT /*+ LEADING( tt ) DYN...
ERROR_ARG4 KGLH0^46c0ec77
ERROR_ARG5 kkslcr:unsafepos
ERROR_ARG6 <NULL>
ERROR_ARG7 <NULL>
ERROR_ARG8 <NULL>
ERROR_ARG9 <NULL>
ERROR_ARG10 <NULL>
ERROR_ARG11 <NULL>
ERROR_ARG12 <NULL>
SIGNALLING_COMPONENT KGH
SIGNALLING_SUBCOMPONENT <NULL>
SUSPECT_COMPONENT <NULL>
SUSPECT_SUBCOMPONENT <NULL>
ECID <NULL>
IMPACTS 0
PROBLEM_KEY ORA 4031
FIRST_INCIDENT 57201
FIRSTINC_TIME 2018-03-22 15:27:57.652000 +01:00
LAST_INCIDENT 74413
LASTINC_TIME 2018-09-15 08:40:23.636000 +02:00
IMPACT1 34668547
IMPACT2 34668546
IMPACT3 0
IMPACT4 0
KEY_NAME SID
KEY_VALUE 481.39600
KEY_NAME ProcId
KEY_VALUE 51.103
KEY_NAME PQ
KEY_VALUE (0, 1525518389)
KEY_NAME Service
KEY_VALUE SMRPRODB
KEY_NAME Module
KEY_VALUE tcserver@sgdcpl03 (TNS V1-V3)
KEY_NAME Client ProcId
KEY_VALUE oracle@sgdcplm02 (TNS V1-V3).76855_140555836445280
OWNER_ID 1
INCIDENT_FILE /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB/incident/incdir_59256/SMRPRODB_ora_76855_i59256.trc
OWNER_ID 1
INCIDENT_FILE /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB/trace/SMRPRODB_ora_76855.trc
ADR Home = /u02/app/oracle/diag/clients/user_oracle/host_1505528871_82:
*************************************************************************
0 rows fetched
</ADR_HOME>
<ADR_HOME name="/u02/app/oracle/diag/clients/user_oracle/host_1505528871_82">
ADR Home = /u02/app/oracle/diag/tnslsnr/sgdcplm02/smrpro_listener:
*************************************************************************
0 rows fetched
</ADR_HOME>
<ADR_HOME name="/u02/app/oracle/diag/tnslsnr/sgdcplm02/smrpro_listener">
ADR Home = /u02/app/oracle/diag/tnslsnr/sgdcplm02/listener:
*************************************************************************
0 rows fetched
adrci> show trace /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB/trace/SMRPRODB_ora_76855.trc
DIA-48908: No trace files are found
adrci> show trace /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB/incident/incdir_59256/SMRPRODB_ora_76855_i59256.trc
Output the results to file: /tmp/utsout_101863_1397_4.ado
adrci>
£££££££££££££££££££££££££££££££££££££££££££££
- ADCRI Example
[oracle@srv6 ~]$ adrci
ADRCI: Release 12.1.0.2.0 - Production on Wed Sep 15 16:41:10 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show problem;
DIA-48318: ADR Relation [PROBLEM] of version=3 cannot be supported
ADR Home = /u01/app/oracle/diag/rdbms/test19c/TEST19C:
*************************************************************************
0 rows fetched
ADR Home = /u01/app/oracle/diag/rdbms/orcl12c/orcl12c:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
3 ORA 600 [kewrose_1] 73025 2021-09-15 16:20:05.145000 +05:30
4 ORA 603 78481 2021-09-15 16:30:05.901000 +05:30
6 ORA 600 [ORA-00600: internal error code, arguments: [4193], 78643 2021-09-15 16:31:37.232000 +05:30
2 ORA 600 [600] 78818 2021-09-15 16:35:07.316000 +05:30
1 ORA 600 [4193] 78644 2021-09-15 16:36:00.519000 +05:30
5 ORA 600 [ORA-00600: internal error code, arguments: [4193], 78645 2021-09-15 16:36:09.369000 +05:30
ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_82:
*************************************************************************
0 rows fetched
ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_110:
*************************************************************************
0 rows fetched
ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener:
*************************************************************************
0 rows fetched
ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener12c:
*************************************************************************
0 rows fetched
adrci> show incident
DIA-48458: "show incident" failed due to the following errors
DIA-48318: ADR Relation [INCIDENT] of version=5 cannot be supported
ADR Home = /u01/app/oracle/diag/rdbms/test19c/TEST19C:
*************************************************************************
0 rows fetched
ADR Home = /u01/app/oracle/diag/rdbms/orcl12c/orcl12c:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
61785 ORA 600 [4193] 2021-09-15 12:08:23.344000 +05:30
61753 ORA 600 [4193] 2021-09-15 12:08:34.605000 +05:30
61754 ORA 600 [kewrose_1] 2021-09-15 12:08:42.202000 +05:30
61873 ORA 600 [4193] 2021-09-15 12:08:49.612000 +05:30
61874 ORA 600 [600] 2021-09-15 12:08:57.767000 +05:30
61977 ORA 600 [4193] 2021-09-15 12:09:04.404000 +05:30
61985 ORA 600 [4193] 2021-09-15 12:09:12.321000 +05:30
61994 ORA 600 [ORA-00600: internal error code, arguments: [4193], 2021-09-15 12:09:29.156000 +05:30
67204 ORA 603 2021-09-15 12:09:34.996000 +05:30
67268 ORA 600 [4193] 2021-09-15 13:21:49.255000 +05:30
67364 ORA 600 [4193] 2021-09-15 13:21:56.384000 +05:30
67365 ORA 600 [kewrose_1] 2021-09-15 13:22:02.472000 +05:30
67636 ORA 600 [4193] 2021-09-15 13:22:07.732000 +05:30
67637 ORA 600 [600] 2021-09-15 13:22:17.857000 +05:30
67684 ORA 600 [4193] 2021-09-15 13:22:19.020000 +05:30
67685 ORA 600 [600] 2021-09-15 13:22:32.617000 +05:30
67620 ORA 600 [4193] 2021-09-15 13:25:03.933000 +05:30
67621 ORA 600 [600] 2021-09-15 13:25:09.363000 +05:30
67541 ORA 600 [600] 2021-09-15 13:30:04.647000 +05:30
67542 ORA 603 2021-09-15 13:30:10.228000 +05:30
67544 ORA 600 [kewrose_1] 2021-09-15 13:32:52.639000 +05:30
67558 ORA 600 [600] 2021-09-15 13:45:01.578000 +05:30
67573 ORA 600 [kewrose_1] 2021-09-15 13:51:49.295000 +05:30
67575 ORA 600 [kewrose_1] 2021-09-15 13:51:53.110000 +05:30
67577 ORA 600 [kewrose_1] 2021-09-15 13:51:55.935000 +05:30
72826 ORA 600 [4193] 2021-09-15 14:24:39.977000 +05:30
72827 ORA 600 [600] 2021-09-15 14:24:45.460000 +05:30
67579 ORA 600 [4193] 2021-09-15 14:30:02.207000 +05:30
72828 ORA 600 [600] 2021-09-15 14:30:08.348000 +05:30
67596 ORA 600 [4193] 2021-09-15 14:30:16.874000 +05:30
67597 ORA 600 [kewrose_1] 2021-09-15 14:30:24.285000 +05:30
72834 ORA 600 [4193] 2021-09-15 14:35:02.161000 +05:30
72835 ORA 600 [600] 2021-09-15 14:35:07.577000 +05:30
72829 ORA 600 [4193] 2021-09-15 14:36:49.925000 +05:30
67645 ORA 600 [600] 2021-09-15 15:39:56.800000 +05:30
67653 ORA 600 [600] 2021-09-15 15:40:00.270000 +05:30
67647 ORA 600 [kewrose_1] 2021-09-15 15:40:34.146000 +05:30
72864 ORA 603 2021-09-15 16:15:05.119000 +05:30
72920 ORA 600 [4193] 2021-09-15 16:19:50.912000 +05:30
73024 ORA 600 [4193] 2021-09-15 16:19:58.426000 +05:30
73025 ORA 600 [kewrose_1] 2021-09-15 16:20:05.145000 +05:30
73320 ORA 600 [4193] 2021-09-15 16:20:13.965000 +05:30
73321 ORA 600 [ORA-00600: internal error code, arguments: [4193], 2021-09-15 16:20:24.693000 +05:30
72921 ORA 600 [4193] 2021-09-15 16:20:31.496000 +05:30
72922 ORA 600 [ORA-00600: internal error code, arguments: [4193], 2021-09-15 16:20:40.305000 +05:30
72923 ORA 600 [4193] 2021-09-15 16:20:56.744000 +05:30
72924 ORA 600 [ORA-00600: internal error code, arguments: [4193], 2021-09-15 16:21:04.091000 +05:30
73217 ORA 600 [600] 2021-09-15 16:24:40.940000 +05:30
78481 ORA 603 2021-09-15 16:30:05.901000 +05:30
78537 ORA 600 [4193] 2021-09-15 16:31:16.588000 +05:30
ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_82:
*************************************************************************
0 rows fetched
ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_110:
*************************************************************************
0 rows fetched
ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener:
*************************************************************************
0 rows fetched
ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener12c:
*************************************************************************
First 0 rows fetched (*** more available ***)
adrci> show incident -mode detail -p "incident_id= 78537"
DIA-48458: "show incident" failed due to the following errors
DIA-48318: ADR Relation [INCIDENT] of version=5 cannot be supported
ADR Home = /u01/app/oracle/diag/rdbms/test19c/TEST19C:
*************************************************************************
0 rows fetched
<INCIDENT_INFO mode="detail">
<ADR_HOME name="/u01/app/oracle/diag/rdbms/test19c/TEST19C">
ADR Home = /u01/app/oracle/diag/rdbms/orcl12c/orcl12c:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 78537
STATUS ready
CREATE_TIME 2021-09-15 16:31:16.588000 +05:30
PROBLEM_ID 1
CLOSE_TIME <NULL>
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 600
ERROR_ARG1 4193
ERROR_ARG2 376
ERROR_ARG3 380
ERROR_ARG4 <NULL>
ERROR_ARG5 <NULL>
ERROR_ARG6 <NULL>
ERROR_ARG7 <NULL>
ERROR_ARG8 <NULL>
ERROR_ARG9 <NULL>
ERROR_ARG10 <NULL>
ERROR_ARG11 <NULL>
ERROR_ARG12 <NULL>
SIGNALLING_COMPONENT <NULL>
SIGNALLING_SUBCOMPONENT <NULL>
SUSPECT_COMPONENT <NULL>
SUSPECT_SUBCOMPONENT <NULL>
ECID <NULL>
IMPACTS 0
PROBLEM_KEY ORA 600 [4193]
FIRST_INCIDENT 61785
FIRSTINC_TIME 2021-09-15 12:08:23.344000 +05:30
LAST_INCIDENT 78646
LASTINC_TIME 2021-09-15 16:41:59.817000 +05:30
IMPACT1 34668555
IMPACT2 34668546
IMPACT3 0
IMPACT4 0
KEY_NAME Service
KEY_VALUE SYS$USERS
KEY_NAME PdbName
KEY_VALUE CDB$ROOT
KEY_NAME Client ProcId
KEY_VALUE oracle@srv6.example.com (TNS V1-V3).15950_140061077414528
KEY_NAME Module
KEY_VALUE sqlplus@srv6.example.com (TNS V1-V3)
KEY_NAME ProcId
KEY_VALUE 6.3
KEY_NAME PQ
KEY_VALUE (16777217, 1631703675)
KEY_NAME SID
KEY_VALUE 1.39345
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle/diag/rdbms/orcl12c/orcl12c/incident/incdir_78537/orcl12c_ora_15950_i78537.trc
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle/diag/rdbms/orcl12c/orcl12c/trace/orcl12c_ora_15950.trc
ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_82:
*************************************************************************
0 rows fetched
</ADR_HOME>
<ADR_HOME name="/u01/app/oracle/diag/clients/user_oracle/host_1213252236_82">
ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_110:
*************************************************************************
0 rows fetched
</ADR_HOME>
<ADR_HOME name="/u01/app/oracle/diag/clients/user_oracle/host_1213252236_110">
ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener:
*************************************************************************
0 rows fetched
</ADR_HOME>
<ADR_HOME name="/u01/app/oracle/diag/tnslsnr/srv6/listener">
ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener12c:
*************************************************************************
0 rows fetched
adrci> exit
[oracle@srv6 ~]$
Purge example
oracle@PLM01:~> adrci
ADRCI: Release 12.1.0.2.0 - Production on Mon Oct 11 07:38:30 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/smrprodb_dr/SMRPRODB_DR
diag/rdbms/smrtestenv/SMRTESTENV
diag/rdbms/smrpatch7/SMRPATCH7
diag/rdbms/smrminddev/SMRMINDDEV
diag/rdbms/smrrac/smrrac2
diag/rdbms/smrprod/SMRPROD2
diag/clients/user_oracle/host_1450352090_82
diag/clients/user_grid/host_1450352090_82
diag/clients/user_root/host_1450352090_82
diag/tnslsnr/PLM01/listener
diag/tnslsnr/PLM01/listener_standalone
adrci> set homes diag/rdbms/smrprod/SMRPROD2
minutes =7200 = 5 days
adrci> purge -age 7200 -type TRACE
adrci> purge -age 7200 -type ALERT
###########################
oracle@srv1:~> adrci
ADRCI: Release 12.1.0.2.0 - Production on Fri Oct 8 13:13:08 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/rac/rac1
diag/clients/user_oracle/host_775046424_82
adrci> set homes diag/rdbms/rac/rac1
adrci> purge -age 30240 -type TRACE
adrci> purge -age 7200 -type TRACE
adrci> purge -age 3600 -type TRACE
adrci> show incident
ADR Home = /u01/app/oracle/diag/rdbms/rac/rac1:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
29297 ORA 7445 [kghfre] 2021-07-23 19:38:24.079000 +05:30
67698 ORA 7445 [kghfre] 2021-09-06 12:29:34.844000 +05:30
67699 ORA 7445 [kspgip] 2021-09-06 12:29:35.390000 +05:30
129604 ORA 603 2021-10-07 16:38:05.466000 +05:30
129605 ORA 603 2021-10-07 16:38:16.733000 +05:30
129606 ORA 603 2021-10-07 16:38:27.237000 +05:30
6 rows fetched
adrci> purge -i 29297
adrci> purge -i 67698
adrci> show alert -p "message_text like '%ORA-%'"
ADR Home = /u01/app/oracle/diag/rdbms/rac/rac1:
*************************************************************************
Output the results to file: /tmp/alert_19058_1400_rac1_1.ado
Additional information: 256
Additional information: 2
adrci>
Alert log in linux
adrci> show alert -p "message_text like '%ORA-%'"
ADR Home = /u01/app/oracle/diag/rdbms/rac/rac1:
*************************************************************************
Output the results to file: /tmp/alert_19058_1400_rac1_1.ado
2021-09-27 18:21:41.381000 +05:30
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_4298.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_ora_4415.trc:
ORA-00443: background process "CJQ0" did not start
ORA-450 signalled during: ALTER DATABASE OPEN /* db agent *//* {1:59059:2} */...
2021-10-07 16:35:58.207000 +05:30
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_4856.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
2021-10-07 16:35:59.208000 +05:30
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_ora_5067.trc:
ORA-00443: background process "GTX0" did not start
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_ora_5067.trc:
ORA-00450: background process 'GTX0' did not start
ORA-00443: background process "GTX0" did not start
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_ora_5067.trc:
ORA-00450: background process 'GTX0' did not start
ORA-00443: background process "GTX0" did not start
2021-10-07 16:36:00.424000 +05:30
ORA-1092 signalled during: ALTER DATABASE OPEN /* db agent *//* {1:63819:2} */...
opiodr aborting process unknown ospid (5067) as a result of ORA-1092
ORA-1092 : opitsk aborting process
2021-10-07 16:36:22.942000 +05:30
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_5952.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn3
2021-10-07 16:36:27.142000 +05:30
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_5952.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_5952.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_5952.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
"/tmp/alert_19058_1400_rac1_1.ado" 97L, 5774C
window ADRCI Alert :
ADR base = "C:\app\varunyadav"
adrci>
>
adrci>
adrci> show alert
Choose the home from which to view the alert log:
1: diag\rdbms\orcl\orcl
2: diag\tnslsnr\2762VARUNY0000L\listener
Q: to quit
Please select option: 1
Output the results to file: C:\Users\VARUNY~1\AppData\Local\Temp\alert_16440_20588_orcl_1.ado
Please select option: 2
Output the results to file: C:\Users\VARUNY~1\AppData\Local\Temp\alert_16440_20588_listener_2.ado
Please select option: q
adrci>
No comments:
Post a Comment