Re: ORA-12571 and ORA-12560

Gerar wrote:

> I've installed Oracle 8i in XP platform. I've tried to connect to my
> database, but after login in, i receive errors ORA-12571 (writer packet
> failure) and ORA-12560 (Protocol adapter error).
>
> Most of people tell me that maybe I configure in bad the way the
> listener.ora and tnsnames.ora files. But I don't think so:
> I need help, please.
> Thanks in advance.
>
> TNSNAMES.ORA
>
> # TNSNAMES.ORA Network Configuration File:
> C:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
>
> # Generated by Oracle configuration tools.
>
> ORCL =
>
> (DESCRIPTION =
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = pfe-2kznt32b8ki)(PORT =
> 1521))
>
> )
>
> (CONNECT_DATA =
>
> (SERVICE_NAME = ORCL)
>
> )
>
> )
>
> LISTENER.ORA
>
> # LISTENER.ORA Network Configuration File:
> C:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
>
> # Generated by Oracle configuration tools.
>
> LISTENER =
>
> (DESCRIPTION_LIST =
>
> (DESCRIPTION =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = pfe-2kznt32b8ki)(PORT =
> 1521))
>
> )
>
> (DESCRIPTION =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = pfe-2kznt32b8ki)(PORT = 2481))
>
> )
>
> )
>
> SID_LIST_LISTENER =
>
> (SID_LIST =
>
> (SID_DESC =
>
> (GLOBAL_DBNAME = ORCL)
>
> (ORACLE_HOME = C:\Oracle\Ora81)
>
> (SID_NAME = ORCL)
>
> )
>
> )

I'll guarantee you that you configured something incorrectly. That part is a no-brainer.

To figure out what you configured incorrectly requires a bit of work.

Start with determining if the listener is running: At the DOS prompt type: LSNRCTL STATUS Then see if the database is running: At the DOS prompt type: SVRMGRL
then
CONNECT INTERNAL
then
SELECT COUNT(*) FROM tab$;

if it says the database is not up and running try: STARTUP
followed by the connect internal and SQL statement above.

Also see if the environment variables ORACLE_SID and ORACLE_HOME are set.

Daniel Morgan Received on Wed Jan 15 2003 - 17:15:28 CST