Re: Problem with automatic startup

From: <dbmejl_at_gmail.com>
Date: Tue, 13 Nov 2007 02:40:19 -0800
Message-ID: <1194950419.871772.76560@22g2000hsm.googlegroups.com>

On 12 stu, 23:41, joel garry <joel-ga..._at_home.com> wrote:
> On Nov 12, 11:02 am, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:
>
> > dbm..._at_gmail.com wrote:
>
> > > Once again, I would like to thank this bloghttp://www.dizwell.com/prod/node/50?page=0%2C4
> > > for helping me create dbora script. :))
>
> > > Please help !! :))
>
> > Why don't you ask the question there?
>
> Because Sybrand is nicer than hjr? :-D
>
> dbmejl:
>
> You perhaps have something wrong in your listener.ora, maybe an
> incorrect oracle_home. Post it by pasting the entire thing and we can
> see. Also post the ORACLE_HOME_LISTNER line in your dbora, maybe you
> got that wrong. Also see metalink Note:336299.1.
>
> jg
> --
> @home.com is bogus.
> Sorry guys, couldn't resist!

Here are the files:

Listener.ora

# listener.ora Network Configuration File: /oracle/10g/network/admin/ listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_2)
      (PROGRAM = extproc)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.66.24)(PORT = 1521))

    )
  )

Sqlnet.ora

# sqlnet.ora Network Configuration File: /oracle/10g/network/admin/ sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) # tnsnames.ora Network Configuration File: /home/oracle/oracle/product/ 10.2.0/db_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INFA =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.66.24)(PORT = 1521))     (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = infa)

    )
  )

HTDWH =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.66.24)(PORT = 1521))     (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = HTDWH)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

I apologize to hjr.pyth..._at_gmail.com for not posting this to his site. It wont happen again. :( Received on Tue Nov 13 2007 - 04:40:19 CST