Need help getting the 9i tutorial database running
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