SAP Note 491174 - Composite SAP note for ORA-01034

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/491174 (SAP Service marketplace login required)

Summary :
SAP Note addresses the occurrence of ORA-01034 errors indicating Oracle Database unavailability. Typical symptoms include access failure to Oracle, issuing ORA-27101 as a follow-on error, and specific errors noted in work process traces or files like R3trans or saplicense. These issues often arise from a non-running database due to various reasons such as failure to start the database, misconfigured Net8/SQLNet V2, or incorrect STRDBS.CMD files on NT systems. Solutions include verifying database start status, proper configuration file settings (listener.ora, tnsnames.ora, sqlnet.ora), ensuring correct scripts in STRDBS.CMD, and fixing environment variable settings. Additional checks involve verifying Oracle executable permissions and manual database starts via SQLPLUS if needed.

Key words :
\usr\sap\<sid>\sys\exe\run, ld_library_path/shlib_path/libpath point correctly, rc = 1034c   error => connect failed, error => oci-call 'olog' failed, system accesses incorrect configuration files, incorrect oracle-executable authorizations solution 1, echo connect internal > v8start, sql  echo startup >> v8start, oracle_home/assistants/dbma directory, sql  @svrmgrl command=@v8start

Related Notes :

583861UNIX: Errors due to Oracle executable
445038Problems when accessing Net8 configuration files
395514ora-1034 d. R/3 System start or d. start w/ R3trans