Re: Desperate Newbie:

I haven't started playing too many games yet with 8i, but:

1-Check $ORACLE_HOME/network/admin and make sure you have a valid TNSNAMES.ORA file. Whether you use the Network Config utility, EASYConfig or whatever, your error message says it is not finding the remote server in the tnsnames file.

2-Since you are on NT, at the command line try 'lsnrctl status' or 'lsnrctl80 status' (I am not sure which is the right one for your release.) You will be able to tell if the listener is up. If not, you can either check the services utility in the Control Panel or try 'lsnrctl start'.

3-also from the command line, if you are using TCP/IP, first ping the server from the client (ping <server address or dns name) then/or tnsping the server (tnsping <tnsnames file entry name).

In article <3794B2F7.1FD8391_at_cc.gatech.edu>,   zman <zahid_at_cc.gatech.edu> wrote:
>
> 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
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 20 1999 - 13:51:38 CDT