Re: Problem with sqlplus/sqlnet

Is the database instance running on the same machine? If not then setting the ORACLE_SID variable won't work, try setting the TWO_TASK variable instead.

Cheers,
Geraint.

"Augustine" <augustine101_at_hotmail.com> wrote in message news:3B2CBBC3.918C0DE0_at_hotmail.com...
> I've to go back to office and check the oracle err. I'll post it tomorrow.
>
> But listener, tnsnames, oracle_home etc.. should be OK when the test
 "sqlplus
> userud/password_at_oracle_sid" is successful, right?
>
> The test using Net*8 config also is OK.
>
> Thanks for the help
> Augustine
>
> "Daniel A. Morgan" wrote:
>
> > Augustine wrote:
> >
> > > Hi,
> > >
> > > I'm trying to solve this problem.
> > >
> > > I've configured oracle client on Solaris using net8asst for oracle8i
> > > running on solaris.
> > > My test with netasst and tnsping shows that connection is okay. Even
> > > when tried to use sqlplus user/password_at_oracle_sid also is ok.
> > >
> > > But when I tried to use sqlplus without using the above syntax its
> > > failing. ie first i set the oracle_sid using ". oraenv". Then used
> > > sqlplus command which prompt me for the userid and password. But then
 it
> > > says "oracle not available". What could be the reason?
> > >
> > > Even after all other successful tests why this one is failing?
> > >
> > > Thanks
> > > Augustine Joseph
> >
> > With your next post include the ORA-##### in addition to the message
 "Oracle
> > not available".
> >
> > Possibilities ... is the instance up? Is the listener running? Is Oracle
> > Home configured? Did you follow the installation directions on the CD or
> > just run .runInstall? If you didn't follow the instruction explicitly
 ...
> > start over making sure you make the changes to /etc/system. Have you put
> > oracle_home, oracle_base, oracle_sid, etc. into the .profile file? Is
 your
> > tnsnames.ora file correct? Is there more than one of them not counting
 the
> > one in the sample directory. Does sqlnet.ora list your domain as .world?
 If
> > so try commenting it out.
> >
> > Daniel A. Morgan
>
Received on Sat Jul 21 2001 - 16:13:16 CDT