Need help getting the 9i tutorial database running

From: Peter Harris <peter.harris_at_arnasys.com>
Date: Tue, 12 Mar 2002 17:28:32 +1100
Message-ID: <3c8da07a$0$11563$afc38c87_at_news.optusnet.com.au>


hello everybody,

I have an Oracle 9i tutorial warehouse database on Suse Linux 7.3 configured by dbca. I ran netca to build the tnsnames.ora and listener.ora files.

I run:

$ tnslsnr &
$ tnsping whouse

TNS Ping Utility for Linux: Version 9.0.1.0.0 - Production on 12-MAR-2002 16:58:44

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/opt/oracle/network/admin/sqlnet.ora
/opt/oracle/network/admin/tnsnames.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dumpy.nsw.optushome.com.au)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = whouse.arnasys)))
OK (10 msec)

$ dbstart

SQL*Plus: Release 9.0.1.0.0 - Production on Tue Mar 12 17:00:02 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> ERROR:
ORA-24314: service handle not initialized

SQL> ORA-12162: TNS:service name is incorrectly specified SQL>
Database "" warm started.

$ oerr ora 24314
24314, 00000, "service handle not initialized" // *Cause: The server context does not done exist. // *Action: Establish the server context in the service context.

What do I need to do to breathe life into this? //peter harris

Configuration files look like the following:

# TNSNAMES.ORA Network Configuration File:
/opt/oracle//network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

WHOUSE.NSW.OPTUSHOME.COM.AU =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dumpy.nsw.optushome.com.au)(PORT = 1521))

    )
    (CONNECT_DATA =
      (SERVICE_NAME = whouse.arnasys)
    )
  )

# LISTENER.ORA Network Configuration File:
/opt/oracle//network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = dumpy.nsw.optushome.com.au)(PORT
= 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/)
      (PROGRAM = extproc)

    )
  )

# SQLNET.ORA Network Configuration File:
/opt/oracle//network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = nsw.optushome.com.au

NAMES.DIRECTORY_PATH= (TNSNAMES) Received on Tue Mar 12 2002 - 07:28:32 CET

Original text of this message