Re: ORA:12154 TNS : Oracle 9.2 on Solaris

Hi!

You do not need the sqlnet.ora to resolv tnsnames.ora locally (At least not to only get a connection, will use $ORACLE_HOME/network/admin/tnsnames.ora if not present in /var/opt/oracle). Move away sqlnet.ora if you have problems with sqlplus user/user_at_TYP2 (after you have started to instance)

check that you have ORACLE_SID=TYP2 in environment

$ORACLE_HOME/dbs/initTYP2.ora need to be present (or spfile)

Try

sqlplus "/ as sysdba"
 >startup
 >exit

dbstart needs /var/opt/oracle/oratab <- TYP2 set to Y (dbstart and dbstop has always been buggy, I do not use them. Make scripts instead. If using dbstop add immediate to the shutdown entry)

nth_prime wrote:
> 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!

-- 
Jan Bjelde
Senior consultant - Technical Manager / Sun professional services
Sun Microsystems as