Re: Can not connect sql *plus

From: Ross <roshanpatel24_at_yahoo.com>
Date: Tue, 8 Jan 2002 17:32:36 +1100
Message-ID: <Bkw_7.3289$lt4.155084@ozemail.com.au>

Hi,
I tried the command at dos prompt and it gave me below mentioned result. I think listner is ok. I have two homes. One is for Oracle 8i (8.1.7) and another is for Forms 6i.

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 08-JAN-2002 17:21:
23

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 -

Produc
tion

Start Date                08-JAN-2002 15:15:34
Uptime                    0 days 2 hr. 5 min. 49 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   C:\oracle\ora81\network\admin\listener.ora
Listener Log File         C:\oracle\ora81\network\log\listener.log
Services Summary...
  Ora81         has 1 service handler(s)
  Ora81         has 2 service handler(s)
  PLSExtProc            has 1 service handler(s)
  ora8idat              has 2 service handler(s)

The command completed successfully

C:\>

"WaltX" <xranix_at_libero.it> wrote in message news:f2087052.0201070730.5a98ae8e_at_posting.google.com...
> Is the oracle listener running ? Try (on a dos prompt) "lsnrctl status".
> In the installation of Developer, the forms sqlnet doesn't know where is
> your database.
>
> Documentation -> sqlnet, local database, net8
>
> Other tips: take a look in the registry under HKLM/software/oracle the
> voice ORACLE_SID and LOCAL (I think you have more than 1 oracle_home, so
> look in that of Forms and in the main tree (software/oracle)
>
> bye
>
>
> "Ross" <roshanpatel24_at_yahoo.com> wrote in message
news:<cp4_7.2529$lt4.120941_at_ozemail.com.au>...
> > I can connect to database by sql Plus which came with the 8i CD. But I
can't
> > login with sql *plus which came with Forms 6i.
> >
> >
> > "Ross" <roshanpatel24_at_yahoo.com> wrote in message
> > news:IyOY7.676$lt4.37402_at_ozemail.com.au...
> > > Hi,
> > >
> > > I have installed Oracle 8i Enterprise edition on Windows 2000 OS. Also
I
> > > have installed Forms/Reports 6i.
> > > when I start sql *plus and insert username/password then I get
following
> > > error. I can not connect to the database. I checked in the "Task
Manager",
> > > that the oracle.exe is running.
>
> > >
> > > ERROR:
> > > ORA-12203: TNS: Unable to connect to destination.
> > >
> > > I tried various username/Password but same error. It logs me out after
> > three
> > > attempt.
> > >
> > > Any advise,
> > >
> > > Ross
> > >
> > >
Received on Tue Jan 08 2002 - 00:32:36 CST