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@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

Alen Cappelletti 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@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

Why did you make any change to the file?
Are you using a fixed IP address as indicated in the docs?
What is the text with the error message. We are not going to look it up.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Jun 19, 5:14 pm, DA Morgan <damor...@psoug.org> wrote:
> Alen Cappelletti 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@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
>
> Why did you make any change to the file?
> Are you using a fixed IP address as indicated in the docs?
> What is the text with the error message. We are not going to look it up.
> --
> Daniel A. Morgan
> University of Washington
> damor...@x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

No, when connection goes, Iìve restarted my machine and my istance is
down.
There are some errors into files?
Thanks

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Don't cross and multipost.
Answered in cdo.server

- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGeB+ELw8L4IAs830RAhfAAJwOWw/OrEU8c++qZouindoUjt1DKwCfYhIK
IZdXkmiZGyzf1i4VE3tiC9c=
=rx8X
-----END PGP SIGNATURE-----