Re: Desperate Newbie:

Hi Sybrand,
I tried doing a "lsnrctl start" but I get this error: TNS-12560: TNS:protocol adapter error

Do you know what might be causing this to happen? I am thoroughly confused. Thanks for all the help.

--zahid

Sybrand Bakker wrote:

> You need to have
> 1 a valid sqlnet.ora, tnsnames.ora and listener.ora on the server
> 2 a valid sqlnet.ora, tnsnames.ora on any client
> Previous experiences with easy config tell
> - you can use flat domains only (ie all domains ending in world)
> - it doesn't modfify/create a listener.ora for you.
> I can't tell you whether that holds for your situation also, as I never used
> 8i. I have a feeling though it does.
> The files are located in %ORACLE_HOME%\net80 (or net81)\admin.
> You shouldn't need to include the full domain always. You should have that
> in your default_domain and default_zone setting in sqlnet.ora.
> If you are in doubt post or e-mail the configuration files, and the group
> will correct them.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> zman <zahid_at_cc.gatech.edu> wrote in message
> news:3794B26B.B05E5A75_at_cc.gatech.edu...
> > Hi. This is my first time using Oracle and I am starting off using
> > Oracle 8i Enterprise Edition for NT.
> > I've bought two books on the subject and went through the Client and
> > Server install process exactly like it says in the books. However, I
> > cannot connect to the server from the remote client no matter what I do.
> > I would REALLY appreciate it if someone could answer some questions for
> > me:
> > 1.] Once the server installation is complete, do I need to run NetEasy
> > Config or anything else so that the Listeners are running?
> > 2.] Once the Client installation is complete, do I need to run any other
> > configuration utility so that it can recognize the server database?
> >
> > I get these errors when I try to run SqlPlus 8.0 from the client and try
> > to connect to the server database:
> >
> > ERROR:
> > ORA-12154: TNS:could not resolve service name
> >
> > In the dialog box that pops up initially for SqlPlus, do i need the
> > whole hostname.domain for the Host string? (eg: caldera.chem.uga.edu)
> >
> > Any other help would be greatly appreciated. Thanks in advance.
> > --zahid
> >
> >
> > --
> > Zahid A. Khan
> > CS Junior | ChemE Computer Assistant
> > ICQ UIN: 4103995 | Phone:(404) 892 4886
> >
> >
Received on Tue Jul 20 1999 - 14:58:57 CDT