Re: cannot connect as sys
Quote:
Originally posted by diwakar
When I do it through telnet, I get the same error:
SQL> connect dcbl/dcbl@dcbl
ERROR:
ORA-12154: TNS:could not resolve service name
Warning: You are no longer connected to ORACLE.
When you telnet to the box hosting the database, you need not give the connect string (provided you have only one service on the box).
Just give...
connect dcbl/dcbl
HTH.
Check your client connect string !
Diwakar,
Through telnet getting connected to an idle instance via SYS means, your DB is not started yet. Pls check if the connect string 'dbcl' in the client is pointing to the right database. If the instance has not been started, you can in no way get connected from a client as connect dcbl/dcbl@dcbl
- Nandu