Oracle12c R2 RAC-ADRCI(including oracle&grid user)
(2017-05-09 11:21:53)分类: Oracle DBA |
------------------------------------------------oracle user
[root@paycore01 ~]# su - oracle
[oracle@paycore01 ~]$ ls
[oracle@paycore01 ~]$ adrci
ADRCI: Release 12.2.0.1.0 - Production on Tue May 9 11:06:37 2017
Copyright
(c) 1982, 2017, Oracle and/or its affiliates.
ADR base = "/oracle/app/oracle"
adrci>
help
adrci> show incdir
ADR Home = /oracle/app/oracle/diag/tnslsnr/paycore01/listener_new:
*************************************************************************
ADR Home = /oracle/app/oracle/diag/clients/user_oracle/host_424338668_107:
*************************************************************************
ADR Home = /oracle/app/oracle/diag/rdbms/nxxpay/nxxpay1:
*************************************************************************
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84496/nxxpay1_dbrm_24079_i84496.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84495/nxxpay1_dbrm_24079_i84495.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84490/nxxpay1_dbrm_24079_i84490.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_76922/nxxpay1_dbrm_24079_i76922.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84494/nxxpay1_dbrm_24079_i84494.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84492/nxxpay1_dbrm_24079_i84492.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_76926/nxxpay1_dbrm_24079_i76926.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_76924/nxxpay1_dbrm_24079_i76924.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_76921/nxxpay1_dbrm_24079_i76921.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84484/nxxpay1_dbrm_24079_i84484.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84489/nxxpay1_dbrm_24079_i84489.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_76925/nxxpay1_dbrm_24079_i76925.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84491/nxxpay1_dbrm_24079_i84491.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84488/nxxpay1_dbrm_24079_i84488.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84493/nxxpay1_dbrm_24079_i84493.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_69242/nxxpay1_dbrm_10642_i69242.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_76927/nxxpay1_dbrm_24079_i76927.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_76928/nxxpay1_dbrm_24079_i76928.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84482/nxxpay1_dbrm_24079_i84482.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84487/nxxpay1_dbrm_24079_i84487.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84481/nxxpay1_dbrm_24079_i84481.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_69241/nxxpay1_dbrm_10642_i69241.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_76923/nxxpay1_dbrm_24079_i76923.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84483/nxxpay1_dbrm_24079_i84483.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84485/nxxpay1_dbrm_24079_i84485.trc
diag/rdbms/nxxpay/nxxpay1/incident/incdir_84486/nxxpay1_dbrm_24079_i84486.trc
ADR Home = /oracle/app/oracle/diag/rdbms/axxtrip/axxtrip_1:
*************************************************************************
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30731/axxtrip_1_dbrm_2902_i30731.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30728/axxtrip_1_dbrm_2902_i30728.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_23164/axxtrip_1_dbrm_2902_i23164.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_23162/axxtrip_1_dbrm_2902_i23162.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30732/axxtrip_1_dbrm_2902_i30732.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_23163/axxtrip_1_dbrm_2902_i23163.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30722/axxtrip_1_dbrm_2902_i30722.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30723/axxtrip_1_dbrm_2902_i30723.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30725/axxtrip_1_dbrm_2902_i30725.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30730/axxtrip_1_dbrm_2902_i30730.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30724/axxtrip_1_dbrm_2902_i30724.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_23166/axxtrip_1_dbrm_2902_i23166.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30727/axxtrip_1_dbrm_2902_i30727.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30729/axxtrip_1_dbrm_2902_i30729.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_23167/axxtrip_1_dbrm_2902_i23167.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_23161/axxtrip_1_dbrm_2902_i23161.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_23165/axxtrip_1_dbrm_2902_i23165.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_23168/axxtrip_1_dbrm_2902_i23168.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30721/axxtrip_1_dbrm_2902_i30721.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30726/axxtrip_1_dbrm_2902_i30726.trc
diag/rdbms/axxtrip/axxtrip_1/incident/incdir_30733/axxtrip_1_dbrm_2902_i30733.trc
ADR Home = /oracle/app/oracle/diag/rdbms/pxxdit/pxxdit1:
*************************************************************************
diag/rdbms/pxxdit/pxxdit1/incident/incdir_38521/pxxdit1_dbrm_24111_i38521.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46092/pxxdit1_dbrm_24111_i46092.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_38525/pxxdit1_dbrm_24111_i38525.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_38526/pxxdit1_dbrm_24111_i38526.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46082/pxxdit1_dbrm_24111_i46082.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_38528/pxxdit1_dbrm_24111_i38528.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46081/pxxdit1_dbrm_24111_i46081.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46087/pxxdit1_dbrm_24111_i46087.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_38524/pxxdit1_dbrm_24111_i38524.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46084/pxxdit1_dbrm_24111_i46084.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46090/pxxdit1_dbrm_24111_i46090.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46091/pxxdit1_dbrm_24111_i46091.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46085/pxxdit1_dbrm_24111_i46085.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_38527/pxxdit1_dbrm_24111_i38527.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_38523/pxxdit1_dbrm_24111_i38523.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46083/pxxdit1_dbrm_24111_i46083.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_30841/pxxdit1_dbrm_11749_i30841.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_38522/pxxdit1_dbrm_24111_i38522.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46089/pxxdit1_dbrm_24111_i46089.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46086/pxxdit1_dbrm_24111_i46086.trc
diag/rdbms/pxxdit/pxxdit1/incident/incdir_46088/pxxdit1_dbrm_24111_i46088.trc
adrci>
adrci>
adrci>
show
homes
ADR Homes:
diag/tnslsnr/paycore01/listener_new
diag/clients/user_oracle/host_424338668_107
diag/rdbms/nxxpay/nxxpay1
diag/rdbms/axxtrip/axxtrip_1
diag/rdbms/pxxdit/pxxdit1
adrci>
adrci>
adrci> show alert
Choose the home from which to view the alert log:
1: diag/tnslsnr/paycore01/listener_new
2: diag/clients/user_oracle/host_424338668_107
3: diag/rdbms/nxxpay/nxxpay1
4: diag/rdbms/axxtrip/axxtrip_1
5: diag/rdbms/pxxdit/pxxdit1
Q: to quit
Please select option: 3
Output the results to file: /tmp/alert_12089_1406_nxxpay1_1.ado
2017-04-28 14:35:32.232000 +08:00
Starting ORACLE instance (normal) (OS id: 17282)
CLI notifier numLatches:19 maxDescs:1610
**********************************************************************
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
RECOMMENDATION:
**********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 12
Number of processor cores in the system is 12
Number of processor sockets in the system is 4
Shared memory segment for instance monitoring created
Exafusion(Msgq-Auto) enabled
Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/app/oracle/11.2.0/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =161
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
2017-04-28 14:35:33.764000 +08:00
NOTE: Cluster configuration type = CLUSTER [4]
NUMA system with 4 nodes detected
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.
ORACLE_HOME:
System
name:
Node
name:
Release:
Version:
Machine:
"/tmp/alert_12089_1406_nxxpay1_1.ado" 8900L, 464700C
Please select option: q
adrci> help
adrci>
adrci> exit
[oracle@paycore01 ~]$ cd /oracle/app/oracle/diag/rdbms/pxxdit/pxxdit1
[oracle@paycore01 pxxdit1]$ ls
alert
[oracle@paycore01 pxxdit1]$ cd alert
[oracle@paycore01 alert]$ ls
log.xml
[oracle@paycore01 alert]$ cd ..
[oracle@paycore01 pxxdit1]$ ls
alert
[oracle@paycore01 pxxdit1]$ cd trace
[oracle@paycore01 trace]$ ls
alert_pxxdit1.log
cdmp_20170502142354
cdmp_20170502155551
------------------------------------------------grid user
[root@paycore01 ~]# su - grid
[grid@paycore02 ~]$ adrci
ADRCI: Release 12.2.0.1.0 - Production on Tue May 9 10:38:01 2017
Copyright
(c) 1982, 2017, Oracle and/or its affiliates.
ADR base = "/oracle/app/grid"
adrci> help
adrci>
show base
ADR base is "/oracle/app/grid"
adrci> show homes
ADR Homes:
diag/tnslsnr/paycore02/listener_scan2
diag/tnslsnr/paycore02/listener
diag/tnslsnr/paycore02/mgmtlsnr
diag/tnslsnr/paycore02/asmnet1lsnr_asm
diag/tnslsnr/paycore02/listener_scan3
diag/tnslsnr/paycore02/listener_scan1
diag/rdbms/_mgmtdb/-MGMTDB
diag/asm/user_grid/host_579982181_107
diag/asm/+asm/+ASM2
diag/asm/user_root/host_579982181_107
diag/crs/paycore02/crs
diag/asmtool/user_grid/host_579982181_107
diag/asmtool/user_root/host_579982181_107
diag/apx/+apx/+APX2
diag/clients/user_grid/host_579982181_107
diag/clients/user_oracle/host_579982181_107
diag/clients/user_root/host_579982181_107
diag/afdboot/user_root/host_579982181_107
adrci>
adrci> show alert
Choose the home from which to view the alert log:
1: diag/tnslsnr/paycore02/listener_scan2
2: diag/tnslsnr/paycore02/listener
3: diag/tnslsnr/paycore02/mgmtlsnr
4: diag/tnslsnr/paycore02/asmnet1lsnr_asm
5: diag/tnslsnr/paycore02/listener_scan3
6: diag/tnslsnr/paycore02/listener_scan1
7: diag/rdbms/_mgmtdb/-MGMTDB
8: diag/asm/user_grid/host_579982181_107
9: diag/asm/+asm/+ASM2
10: diag/asm/user_root/host_579982181_107
11: diag/crs/paycore02/crs
12: diag/asmtool/user_grid/host_579982181_107
13: diag/asmtool/user_root/host_579982181_107
14: diag/apx/+apx/+APX2
15: diag/clients/user_grid/host_579982181_107
16: diag/clients/user_oracle/host_579982181_107
17: diag/clients/user_root/host_579982181_107
18: diag/afdboot/user_root/host_579982181_107
Q: to quit
Please select option: 7
Output the results to file: /tmp/alert_29036_1404_-MGMTDB_1.ado
2017-04-28 15:26:56.394000 +08:00
Starting ORACLE instance (normal) (OS id: 9454)
CLI notifier numLatches:3 maxDescs:849
**********************************************************************
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
RECOMMENDATION:
**********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 2
Number of processor cores in the system is 12
Number of processor sockets in the system is 4
Shared memory segment for instance monitoring created
Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/app/11.2.0/grid/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =84
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
2017-04-28 15:26:57.660000 +08:00
NOTE: Cluster configuration type = CLUSTER [4]
NUMA system with 4 nodes detected
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.
ORACLE_HOME:
System
name:
Node
name:
Release:
Version:
Machine:
Using parameter settings in server-side spfile +MGMT/_MGMTDB/PARAMETERFILE/spfile.269.942495797
System parameters with non-default values:
ILAT =84
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
2017-04-28 15:26:57.660000 +08:00
NOTE: Cluster configuration type = CLUSTER [4]
NUMA system with 4 nodes detected
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.
ORACLE_HOME:
System
name:
Node
name:
Release:
Version:
Machine:
Using parameter settings in server-side spfile +MGMT/_MGMTDB/PARAMETERFILE/spfile.269.942495797
System parameters with non-default values:
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 4.0
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2017-04-28 15:27:02.899000 +08:00
……
adrci> show log
Choose the home from which to view diagnostic logs:
1: diag/tnslsnr/paycore02/listener_scan2
2: diag/tnslsnr/paycore02/listener
3: diag/tnslsnr/paycore02/mgmtlsnr
4: diag/tnslsnr/paycore02/asmnet1lsnr_asm
5: diag/tnslsnr/paycore02/listener_scan3
6: diag/tnslsnr/paycore02/listener_scan1
7: diag/rdbms/_mgmtdb/-MGMTDB
8: diag/asm/user_grid/host_579982181_107
9: diag/asm/+asm/+ASM2
10: diag/asm/user_root/host_579982181_107
11: diag/crs/paycore02/crs
12: diag/asmtool/user_grid/host_579982181_107
13: diag/asmtool/user_root/host_579982181_107
14: diag/apx/+apx/+APX2
15: diag/clients/user_grid/host_579982181_107
16: diag/clients/user_oracle/host_579982181_107
17: diag/clients/user_root/host_579982181_107
18: diag/afdboot/user_root/host_579982181_107
Q: to quit