Solution : https://service.sap.com/sap/support/notes/602843 (SAP Service marketplace login required)
Summary :
This SAP Note clarifies the configuration of UNIX environment variables within an SAP R/3 Oracle context, necessary for ideal system operation. It details variables like `dbms_type`, `dbs_ora_schema`, `dbs_ora_tnsname`, and `DIR_LIBRARY`, which are critical for `sid`adm instances, providing connectivity and directory path configurations to Oracle databases. Changes to these settings must be centrally managed through `.dbenv` and `.sapenv` scripts referenced in user profiles to maintain stability and consistency. Further references include SAP Notes 830578 and 562403, enhancing variable management and adjustment related to specific Oracle versions and system requirements.
Key words :
ssxff amnls_timestamp_tz_format = dd-mon-rr hh, /usr/sap/<sid>/sys/exe/run, /usr/sap/<sapsid>/sys/profile/oracle, database-dependent sap library dboraslib, muss $oracle_home/bin enthalten sein, ora<sid> sapsystemname system id, $oracle_home/ocommon/nls/admin/data, /oracle/<sid>/<release>_<bits>, <sid>adm tns_admin points, ora<sid> oracle 11g
Related Notes :
| 1521371 | Oracle 11.2.0: Setting of ORACLE_BASE in SAP environments |
| 830578 | Oracle database 10g: Unix environment variable |
| 658322 | Composite SAP Note: Incorrect resulting set with Oracle |
| 655240 | Composite SAP note: ORA-01033 |
| 654717 | Composite SAP Note: ORA-12538 |
| 653690 | Composite SAP note: ORA-24365 |
| 653247 | Composite note: ORA-01078 |
| 634134 | Error due to incorrect or missing message files |
| 632483 | Composite SAP Note ORA-06401 |
| 606359 | FAQ: Oracle National Language Support (NLS) |
| 592657 | ORA-12701/ORA-12705/ORA-12709 |
| 588739 | R/3 start fails due to dw_xml, dw_stl and dw_xtc |
| 562403 | FAQ: Oracle Net |
| 521230 | FAQ: Client software 9i or lower on UNIX |
| 480266 | Problems with the SYSDBA/SYSOPER/INTERNAL connect |
| 420842 | Relink error: file /opt: unknown type |
| 202227 | Recommended login shells |
| 180430 | Installing the ORACLE client software for UNIX |