Re: ORA-27101 hell!!!

From: Chris Clarke <c.clarke_at_talis.com>
Date: 10 Oct 2003 05:58:17 -0700
Message-ID: <10304d3b.0310100458.342eb65e@posting.google.com>

Hi,

Once I've started the database and the listener, I do ps -ef | grep oracle and can see that the O817DB instance is indeed started (see following)

oracle    3615     1  0 13:42 ?        00:00:00 ora_pmon_0817DB
oracle    3617     1  0 13:42 ?        00:00:00 ora_dbw0_0817DB
oracle    3619     1  0 13:42 ?        00:00:00 ora_lgwr_0817DB
oracle    3621     1  0 13:42 ?        00:00:00 ora_ckpt_0817DB
oracle    3623     1  0 13:42 ?        00:00:00 ora_smon_0817DB
oracle    3625     1  0 13:42 ?        00:00:00 ora_reco_0817DB
oracle    3627     1  0 13:42 ?        00:00:00 ora_snp0_0817DB
oracle    3629     1  0 13:42 ?        00:00:00 ora_snp1_0817DB
oracle    3631     1  0 13:42 ?        00:00:00 ora_snp2_0817DB
oracle    3633     1  0 13:42 ?        00:00:00 ora_snp3_0817DB
oracle    3635     1  0 13:42 ?        00:00:00 ora_s000_0817DB
oracle    3637     1  0 13:42 ?        00:00:00 ora_d000_0817DB
oracle    3639     1  0 13:42 ?        00:00:00 ora_d001_0817DB
oracle    3650     1  0 13:44 ?        00:00:00
/u01/app/oracle/product/8.1.7/bi
oracle    3669  1861  0 13:47 ?        00:00:03 kdeinit: konqueror
--silent
oracle    3689  1861  4 13:50 ?        00:00:22 xpdf

/home/oracle/oracleonlinux.
oracle 3700 3525 0 13:58 pts/1 00:00:00 ps -ef oracle 3701 3525 0 13:58 pts/1 00:00:00 grep oracle

So I would think there is a TNS problem... I've checked the resolution of "bbserver" by doing ping bbserver - this indeed resolves it to 127.0.0.1.

I can't see a problem with my existing tnsnames.ora and listener.ora configurations. Please find below my listener.ora (and below that the tnsnames.ora listed again)

# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 2481))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = oracle.localhost)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_NAME = O817DB)

    )
    (SID_DESC =
(GLOBAL_DBNAME = bbdata.localhost)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_NAME = bbdata)

    )
  )

TRACE_LEVEL_LISTENER = SUPPORT tnsnames.ora follows:

# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

O817DB =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = O817DB)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
    )
  )

BBDATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = bbdata.localhost)

    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = bbdata.localhost)
(PRESENTATION = http://admin)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

ORACLE =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bbserver)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = oracle.localhost)

    )
  )

Thanks,
Chris

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<3f852f6b$0$29372$afc38c87_at_news.optusnet.com.au>...

> And your listener.ora is... where??
> Regards
> HJR

Received on Fri Oct 10 2003 - 07:58:17 CDT