ORACLE Applications SQL*Plus Connect

 

- Info:

- This tutorial shows different ways of using sqlplus to connect to ORACLE DB.

 

- Procedure 1:

- Start MSDOS

sqlplus myUser/myPassword@XE

 

- Procedure 2:

- Start MSDOS

- sqlplus

- Enter user-name: myUser

- Enter password: myPassword

 

- Setup:

- Edit C:\oracle\ora92\network\ADMIN\TNSNAMES.ORA

- Start Run E:\oracle\ora90\bin\sqlplusw.exe

 

TNSNAMES.ORA

XE =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = vori)(PORT = 1522))

)

(CONNECT_DATA =

(SERVICE_NAME = XE)

)

)