Re: connecting to PO 8.1.7??

I think you need a domain suffix on your service name in the Tnsnames file. Edit your Tnsnames.ora file and make it 'PO8.World' instead of just PO8. Then try sqlplus using PO8.world. If typing .world bugs you, you can set a default domain name in the sqlnet.ora file (same location as the tnsnames.ora). Set it to 'world' (omit the quotes) and you connect via sqlplus by just specifying PO8 for the service name.

Good luck,

Dave

"Chris Dorr" <cdorr01_at_home.com> wrote in message news:<mhK28.2464$gW4.1813225_at_news1.rdc1.mi.home.com>...
> I've successfully installed PO on my win98 machine however whenever I try
> and connect to the DB (through SQL*Plus) (Oracle starts up just fine) I keep
> getting this error:
>
> ORA-12154 Could Not Resolve Service Name
>
> This is for a class and they've directed me to put the information below
> into the tnsnames.ora file. I have a feeling there's something wrong with
> the information this class has provided me, but after 4 hours of looking I'm
> not finding it!! (Looked on the OTN network but it's not very clear as to
> what their saying!)
>
> Can Someone help me out? Here's what my tnsnames.ora file looks like?
>
>
> PO8 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL=BEQ)
> (PROGRAM = oracle80)
> (ARGV0 = oracle80ORCL)
> (ARGS = '(DESCRIPTION = (LOCAL = YES)
> (ADDRESS = (PROTOCOL = beq)))'))
> (CONNECT_DATA = (SID=ORCL))
> )
>
> Thanks,
Received on Tue Jan 22 2002 - 03:10:50 CET