1.VirtualBox down & install
2. download vm
3. import vm & start
4. main
sqlplus hr
pw : oracle
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));
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
8. Checking the tnsnames.ora
9. DB Client Connect Tool
( Navicat or Toad )
( Navicat or Toad )
Service Name
PORT
USER ID
ex) scott / tiger
hr / oracle
sys / oracle
system / oracle
10. success
댓글 없음:
댓글 쓰기