Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Listener is on but db istance is down

Re: Listener is on but db istance is down

From: Alen Cappelletti <alen.cappelletti_at_gmail.com>
Date: Tue, 19 Jun 2007 12:23:45 -0000
Message-ID: <1182255825.871866.55080@u2g2000hsc.googlegroups.com>


On Jun 19, 2:00 pm, sybrandb <sybra..._at_gmail.com> wrote:
> On Jun 19, 9:56 am, Alen Cappelletti <alen.cappelle..._at_gmail.com>
> wrote:
>
>
>
>
>
> > My test PC have a hostname like ITVAW2k3DEV02 with a IP
> > 162.162.162.2.
> > Into my host file in windows I have overwrite the default settings
> > 127.0.0.1 with
>
> > 162.162.162.2 ITVAW2k3DEV02
>
> > tnsping orcl return successful but when I try a test like
>
> > >sqlplus connect system_at_orcl
> > > insert password
>
> > I got an error ora-12505...I see on web browser admin listner is ON
> > but db is down.
> > I try to rebuild listerner and tnsnames files...many times and one
> > time this operation restart my connection and I worked for 5 minutes.
> > After this time I restart for security test my PC and all stop
> > another
> > time. I thik there is sono connection problems...
>
> > I'm on oracle 10 g
>
> > ------- my listener --------
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = PLSExtProc)
> > (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
> > (PROGRAM = extproc)
> > )
> > )
>
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = ITVAW2K3DEV02)(PORT = 1521))
> > )
> > )
>
> > ------- tnsnames ----------
> > ORCL =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = 162.162.162.2)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = ORCL)
> > )
> > )
>
> > EXTPROC_CONNECTION_DATA =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > )
> > (CONNECT_DATA =
> > (SID = PLSExtProc)
> > (PRESENTATION = RO)
> > )
>
> > ------- sqlnet.ora ---------
>
> > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> > NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> > )
>
> > I hope someone can help me
>
> > Alen Italy
>
> I'm not sure why you can't be bothered to look up ora-12505.
> The error is quite explicit:
> you are connecting using a connect with SID=... and you didn't
> configure the SID in listener.ora.
>
> Consequently the tnsnames.ora in your post is NOT the tnsnames.ora you
> are using to connect.
>
> Your assertion 'db is down' is probably incorrect too as you clearly
> didn't verify the state of the OracleService<SID>.
> So what should anyone do? Take their crystal ball?
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

Thaks nut I'm not an expert of connection... always work when all goes fine...

Now sorry for the stupid question but in my Post there is some error in one of the 3 scripts?
Alen, Italy Received on Tue Jun 19 2007 - 07:23:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US