Connection using sql*plus [message #256447] |
Sat, 04 August 2007 16:02 |
surenhr
Messages: 45 Registered: August 2007 Location: gurgoan
|
Member |
|
|
Hi guyz,
I am able to connect to my databse using
SQL> conn suren/suren@sct
Connected.
But i heard somewhere that we can connect using username and password only;
for that i have set ORACLE_SID=c:\oracle\oradata\sct;.;
but still its not working,it shows the following error.
SQL> connect suren/suren
ERROR:
ORA-12560: TNS:protocol adapter error
all services are active for oracle.
|
|
|
|
|
|
|
|
|
|
|
|
|