Re: Listener is on but db istance is down

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