Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Desperate Newbie:
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:23:20 CDT