DB & ASM 접속

▣ DB 접속

[oracle@edrsr4p1 ~]$ echo $ORACLE_SID

orcl

[oracle@edrsr4p1 ~]$ sqlplus / as sysdba

   

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 19 14:36:15 2009

   

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

   

   

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

   

SQL> show parameter unique

   

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_unique_name string orcl

SQL>

SQL> show parameter instance_type

   

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

instance_type string RDBMS

   

▣ ASM 접속

[oracle@edrsr4p1 ~]$ ORACLE_SID=+ASM;sqlplus / as sysdba

   

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 19 14:37:26 2009

   

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

   

   

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

   

SQL> show parameter unique

   

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_unique_name string +ASM

SQL> show parameter instance_type

   

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

instance_type string asm

   

   

▣ ASM

SQL> select status from v$instance;

   

STATUS

------------

STARTED => ASM에서는 mount 모드에서도 STARTED 임, ASM은 OPEN이 없음

   

SQL> desc dba_views => mount 모드이기 때문에 dictionary view 볼 수 없음

ERROR: => 검색 및 실행은 asm을 사용하는 db 인스턴스에서 할 것

ORA-04043: object dba_views does not exist

   

   

SQL> select path from v$asm_disk;

   

PATH

---------------------------------------------------------------------------------------------------------------------

/dev/raw/raw5

/dev/raw/raw6

/dev/raw/raw1

/dev/raw/raw2

/dev/raw/raw3

/dev/raw/raw4

   

6 rows selected.

   

SQL> select name from v$asm_diskgroup;

no rows selected      =>      Disk1 group 생성 전에는 검색 안됨

   

SQL> select name from v$asm_diskgroup;

   

NAME

------------------------------

DISK1