[실습1] ASM 환경 이미지 파일인 11gWS2.ova 를 여유공간이 있는 곳에 저장합니다.
[실습2] ASM 이미지 파일을 oracle vm 에서 불러옵니다.
[실습3] putty 로 192.168.56.104로 접속합니다.
[실습4] 오라클에 접속이 잘되는지 확인하시오
[orcl:~]$ ps -ef |grep pmon
oracle 5369 1 0 11:14 ? 00:00:00 asm_pmon_+ASM
oracle 5562 1 0 11:14 ? 00:00:00 ora_pmon_orcl
oracle 5806 5761 0 11:19 pts/2 00:00:00 grep pmon
[orcl:~]$
[orcl:~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 17 11:19:26 2025
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
orcl
[orcl:~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 17 11:22:35 2025
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> alter user scott account unlock;
User altered.
SQL> alter user scott identified by tiger;
User altered.
SQL> alter user hr account unlock;
User altered.
SQL> alter user sh account unlock;
User altered.
SQL> alter user hr identified by hr;
User altered.
SQL> alter user sh identified by sh;
User altered.
[orcl:~]$ sqlplus sh/sh@edydr1p0.us.oracle.com:1521/orcl.us.oracle.com
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 17 11:25:33 2025
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL>
[orcl:~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 17 11:26:19 2025
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> select file_name from dba_data_files;
FILE_NAME
+DATA/orcl/datafile/users.259.796857625
+DATA/orcl/datafile/undotbs1.258.796857625
+DATA/orcl/datafile/sysaux.257.796857623
+DATA/orcl/datafile/system.256.796857621
+DATA/orcl/datafile/example.265.796857803
