Persistent ORA-01034: ORACLE not available
OBYYSNov 30 2012 — edited Dec 2 2012Hi,
I'm using Oracle 11g database Version 11.2.0.1.0 and this problem im having seems not to get solved on my system...
Im working directly with the computer Oracle is installed and i have tried all solutions i could find on the OTN forum for the ORA-01034 error, but none seemed to work for me please anyone have anymore ideas?
EXPLANATION: first i had this ORA-12505, so i applied a solution from OTN forum by editing the listener.ora file and added one more SID_DESC and it seemed to solve the ORA-12505 error, after which i reboot my system and tried connecting, instead a new error appeared ORA-01034.
This is what my listener.ora file looks lik after i edited it:
# listener.ora Network Configuration File: C:\app\OBI\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\OBI\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\OBI\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = obyys)
(ORACLE_HOME = C:\app\OBI\product\11.2.0\dbhome_1)
(SID_NAME = obyys)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\OBI
This is my tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\app\OBI\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
OBYYS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = obyys)
)
)
cmd>tnsping OBYYS
Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Windows\system32>tnsping OBYYS
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-NOV-2
012 09:52:01
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\OBI\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = obyys)))
OK (0 msec)
LISTENER STATUS
cmd>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-NOV-2012 09:57
:12
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
________________________________________
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 30-NOV-2012 06:52:32
Uptime 0 days 3 hr. 4 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\OBI\product\11.2.0\dbhome_1\network\admin\liste
ner.ora
Listener Log File c:\app\obi\diag\tnslsnr\OBI-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OBI-PC)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
Service "obyys" has 1 instance(s).
Instance "obyys", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
These are the solutions i tried out for the 0RA-01034 BUT NONE WORKED
1) do you find in your sqlnet.ora an entry like SQLNET.AUTHENTICATION_SERVICES=(NTS)? If so, change it on trial to SQLNET.AUTHENTICATION_SERVICES=(NONE) .
2) set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
shutdown abort
startup
3) changing the service name to CAPS
Please anyone have any other better ideas.. would appreciate. Thanks