반응형
Oracle ASM Log 위치
[oracle@onerac DATASYNCXML]$ env | grep SID
ORACLE_SID=+ASM
[oracle@onerac DATASYNCXML]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 22 16:09:29 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
SQL> create pfile='/home/oracle/DATASYNCXML/initASM.ora_org' from spfile;
File created.
SQL>
SQL> show parameter diagnostic_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /u01/app/oracle
SQL>
SQL>
SQL> show parameter audit_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/19.0.0/grid/rdbms/audit
SQL>
SQL>
SQL> alter system set diagnostic_dest='/logs/crs/' scope=spfile sid='*';
System altered.
SQL>
SQL> alter system set audit_file_dest='/logs/crs/rdbms/audit' scope=spfile sid='*';
System altered.
SQL>
SQL> host mkdir -p /logs/crs/rdbms/audit
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$ srvctl stop database -d TST
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'onerac'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'onerac'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'onerac'
CRS-2677: Stop of 'ora.DATA.dg' on 'onerac' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'onerac'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'onerac' succeeded
CRS-2677: Stop of 'ora.asm' on 'onerac' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'onerac'
CRS-2677: Stop of 'ora.evmd' on 'onerac' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'onerac'
CRS-2677: Stop of 'ora.cssd' on 'onerac' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'onerac' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[oracle@onerac DATASYNCXML]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 22 16:40:36 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
SQL> show parameter diagnostic_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /logs/crs/
SQL>
SQL> show parameter audit_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /logs/crs/rdbms/audit
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[oracle@onerac DATASYNCXML]$Oracle Database
[oracle@onerac DATASYNCXML]$ env | grep SID
ORACLE_SID=TST
[oracle@onerac DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@onerac DATASYNCXML]$ sqlplus "/as sysdba"
SQL> create pfile='/home/oracle/DATASYNCXML/initTST.ora_org' from spfile;
File created.
SQL>
SQL> show parameter diagnostic_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /u01/app/oracle
SQL>
SQL> show parameter audit_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/oracle/admin/TST/adump
SQL>
SQL>
SQL> alter system set diagnostic_dest='/logs/db/' scope=spfile sid='*';
System altered.
SQL> alter system set audit_file_dest='/logs/db/admin/TST/adump' scope=spfile sid='*';
System altered.
SQL> host mkdir -p /logs/db/admin/TST/adump
SQL> !ls -al /logs/db/admin/TST/adump
total 0
drwxr-xr-x. 2 oracle dba 6 Aug 22 16:04 .
drwxr-xr-x. 3 oracle dba 19 Aug 22 16:04 ..
SQL> exit
[oracle@onerac DATASYNCXML]$ srvctl stop database -d TST
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$ ps -ef | grep pmon
oracle 4855 1 0 15:49 ? 00:00:00 asm_pmon_+ASM
oracle 7276 6662 0 16:05 pts/0 00:00:00 grep --color=auto pmon
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$ srvctl start database -d TST
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$ ps -ef | grep pmon
oracle 4855 1 0 15:49 ? 00:00:00 asm_pmon_+ASM
oracle 7351 1 0 16:06 ? 00:00:00 ora_pmon_TST
oracle 7819 6662 0 16:06 pts/0 00:00:00 grep --color=auto pmon
[oracle@onerac DATASYNCXML]$
[oracle@onerac DATASYNCXML]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 22 16:08:01 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
SQL> show parameter diagnostic_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /logs/db/
SQL>
SQL> show parameter audit_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /logs/db/admin/TST/adump
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[oracle@onerac DATASYNCXML]$Oracle Listener
Oracle CRS
반응형