Re: Problem with listener and oracle instance

If you're using SQL*Net 2.3 (Oracle7), the proper syntax is user/passwd_at_2:orcl when you're trying to connect from the host's console (Oracle8 does not support the "2:" bit though).

Otherwise, you need to install a SQL*Net client on the host and create a "database alias", then
try user/passwd_at_alias.

Sylvain Leclerc, DBA
sleclerc_at_magrit.com

> -----Original Message-----
> From: Pat Minnis [SMTP:pminnis_at_indianaonline.net]
> Posted At: Wednesday, December 15, 1999 12:31 AM
> Posted To: server
> Conversation: Problem with listener and oracle instance
> Subject: Re: Problem with listener and oracle instance
>
> Leave database name blank as in user/passwd@
>
> I have run into the same problem.
> I got around it in a crunch as above.
> If anyone knows the answer, I am interested in hearing it also.
>
> Eric Ross wrote in message <3856758B.8A16074_at_www.disc.ucn.cl>...
> >Hi..
> >
> >I just installed Oracle, but i have some problems. First, i start the
> >oracle instance and i can connect with 'sqlplus user/passwd'. It
> works
> >ok.. i can create users and tables and so on. The problem is that
> when i
> >start the listener, when trying to connect with 'sqlplus
> >user/passwd_at_orcl' (orcl is the db name), sqlplus says 'oracle not
> >available'. Is there some way to test if my setup is right ? I dont
> have
> >the listener.ora and tns..ora files here, but i can post them if
> >needed..
> >
> >Thanks in advance
> >
> >
> >--
> >god:~# create world
> >Segmentation fault (core dumped)
>
Received on Wed Dec 15 1999 - 07:22:50 CST