Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Persistent ORA-01034: ORACLE not available

OBYYSNov 30 2012 — edited Nov 30 2012
Hi,
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)
)
)

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2012
Added on Nov 30 2012
4 comments
446 views