| Oracle not available [message #127067] |
Fri, 08 July 2005 07:40  |
mullerw5
Messages: 1
Registered: July 2005
|
Junior Member |
|
|
Dear ones,
I am trying to run my Oracle9i on WinXP Pro but is unable to make it work with scott/tiger : ORA-01034: ORACLE not available.
I have done :
-checked env. variables (ORACLE_HOME, PATH, ORACLE_SID)
-sqlnet.ora
**********************************************************
SQLNET.AUTHENTICATION_SERVICES = (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
**********************************************************
-listener.ora
**********************************************************
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ORA92PCS)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = LOCAL)
(ORACLE_HOME = C:\oracle\ORA92PCS)
(SID_NAME = LOCAL)
)
)
**********************************************************
-tnsnames.ora
**********************************************************
LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LOCAL)
(SID_NAME = LOCAL)
)
)
**********************************************************
Is this due to multiple installations/un-installations (9i, 10g, 9i) ?
Many thanks for any advices,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
