Re: Problem with sqlplus/sqlnet

Thanks!!

You are correct. It solved the problem. Mine was client.

Thanks again.
Augustine Joseph

Geraint Williams wrote:

> 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 - 23:14:03 CEST