Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA:12154 TNS : Oracle 9.2 on Solaris

ORA:12154 TNS : Oracle 9.2 on Solaris

From: nth_prime <jrojas_at_hsc.utah.edu>
Date: 20 Feb 2003 08:26:34 -0800
Message-ID: <72435b0f.0302200826.3e2e799b@posting.google.com>


Hi all,

Basically I have Oracle 9.2 installed. I am having problems configuring listner.ora and tnsnames.ora and sqlnet.ora

Do i need to have sqlnet.ora configured?

When i start my listner i get



Services Summary...
Service "TYP2" has 1 instance(s).
  Instance "TYP2", status UNKNOWN, has 3 handler(s) for this service... The command completed successfully

I try dbstart and I get



Can't find init file for Database "TYP2". Database "TYP2" NOT started.

Listner File looks like



TYP2=
  (ADDRESS_LIST=

(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
) SID_LIST_TYP2= (SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=TYP2) (SID_NAME=TYP2) (ORACLE_HOME=/usr/oracle/9.2) (PRESPAWN_MAX=20) (PRESPAWN_LIST= (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1)) ) )

    )

TNSNAMEs.ora LOOKS LIKE



TYP2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT=1521))     )
    (CONNECT_DATA =
      (SID = TYP2) (SERVICE_NAME = TYP2)     )
  )

Any help would be greatly appreciated

Thank you! Received on Thu Feb 20 2003 - 10:26:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US