Re: rookie question re: TNS/LISTENER

ORACLE_HOME/network/admin/tnsnames.ora
is not setup correctly.

add something like this to your tnsnames.ora file

oralin.world =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= <your IP address>)(Port= 1521))     (CONNECT_DATA = (SID = oralin))
  )

if its a stand-alone PC you do not need to go through the Oralce Listener. Any time you use "@<sid>" you are going to use SQL Net and the Listener. for you
sqlplus system/manager
will work just fine provided your env is setup correctly (ie, ORACLE_HOME, ORACLE_SID, and Path has $ORACLE_HOME/bin in it)

Andrew Lenz

"ConnorsJohnny" <connorsjohnny_at_aol.com> wrote in message news:20010115153503.15714.00000355_at_ng-bk1.aol.com...
> I have Oracle 8i on Linux on a stand-alone PC.
> On this pc I have a starter database called "oralin".
> Having got the databse up and running, I enter a command from the shell:
> "sqlplus system/manager_at_oralin" but get an error ORA-12154 TNS could not
> resolve service name.
> The details from the initialization file, initoralin.ora are:
>
> db_name = "oralin"
> db_domain = localhost.com
>
> instance_name = oralin
> service_names=oralin.localhost.com
>
> I don't know why this command does not work but I have my L-plates on.
> Thanks in advance.
>
Received on Tue Jan 16 2001 - 00:57:55 CST