글목록

2014. 11. 11.

VirtualBox + OracleVM installation



1.VirtualBox down & install 





2. download vm 








3. import vm & start




 4. main
  
sqlplus hr
pw : oracle

SQL> conn sys as sysdba

pw : oracle

if "bash: sqlplus: command not found..."

-> cd /home/oracle



-> $. .bash_profile


SQL> create user ID identified by PASSWORD;

SQL> grant connect, resource, dba to ID

SQL> create table test(
2 name varchar2(15),
3 pwd varchar2(15));





 5. network setting


 6. Checking the Connection

telnet 127.0.0.1 1521





 7. Checking the listener.ora


 vim /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora




 8. Checking the tnsnames.ora


 vim /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora


 9. DB Client Connect Tool
( Navicat or Toad )

 Service Name 

PORT

USER ID

ex) scott / tiger
hr / oracle
 sys / oracle
system / oracle






 10. success






댓글 없음:

댓글 쓰기