Re: ORA:12154 TNS : Oracle 9.2 on Solaris

Thanks for you help...

lsnrctl start TYP2
I get the following message

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

If i want to connect to my server from another machine do I need sqlnet.ora?

Thanks!

Jorge

Jan Bjelde - Sun Norway - Senior Consultant <jan.bjelde_at_norway.sun.com> wrote in message news:<3E55E9CD.1040603_at_norway.sun.com>...
> 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!
Received on Fri Feb 21 2003 - 10:40:16 CST