Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA:12154 TNS : Oracle 9.2 on Solaris
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
I try dbstart and I get
Listner File looks like
(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
Any help would be greatly appreciated
Thank you! Received on Thu Feb 20 2003 - 10:26:34 CST