Re: sqlplus

Sergio, The connect statement you listed should work to connect to Oracle from PL/SQL, your problem may be that your listner has stopped and the _at_ in the statement cause Oracle to go via the listner. I think that the ORACLE_SID parameter define your default database and bypasses the listner.

Darren Earl (darren_at_earld.demon.co.uk)

Sergio Tiezzi <sergio_at_datatrade.sm> wrote:

>Can I connect to a database in this way :
 

> sqlplus user/passwd_at_DB_NAME
 

>Is it important what I write in my ORACLE_SID ?
 

>When I try I get
 

>ORA -12154:TNS : could not resolve service name
 

>sergio_at_datatrade.sm
 

>thank you very much
Received on Mon Dec 02 1996 - 00:00:00 CET