Solution : https://service.sap.com/sap/support/notes/562403 (SAP Service marketplace login required)
Summary :
This SAP Note discusses key aspects of Oracle Net (also known as Net8/SQL*Net V2), which facilitates communication between an Oracle client and server, essential for data exchange and connection management in an R/3 environment. It covers the complete architecture, including vital configuration files such as tnsnames.ora, listener.ora, sqlnet.ora, and protocol.ora (applicable till Oracle 8i). The note provides guidance on locating these files and tuning network performance between SAP and Oracle systems. Additionally, it discusses Oracle Net's role in a RAC environment, troubleshooting connections, checking trace options, and related security guidelines ensuring secure implementation of Oracle Net services in an SAP landscape.
Key words :
startup_wait_time_listener = 0inbound_connect_timeout_listener = 120trace_level_listener = offadr_base_listener = <sapdata_home>/saptrace, sql net trace files doc id, accessing oracle net configuration files note 437362, guide net services reference guide, oracle 9i/10g online documentation, $oracle_home/network/trace/svr_<pid>, /3 profile parameter dbs/ora/tnsname, individual cases /var/opt/oracle, oracle net configuration files exist, oracle net configuration files receive
Related Notes :
| 1256322 | Establishing a remote database connection in DBACOCKPIT |
| 1100926 | FAQ: Network performance |
| 1055400 | Oracle 10.2.0.2: Work processes terminate on Windows 2003 |
| 825653 | Oracle: Common misconceptions |
| 805934 | FAQ: Database time |
| 723641 | Composite SAP Note: ORA-12545 |
| 722966 | Composite SAP Note: ORA-12546 |
| 655240 | Composite SAP note: ORA-01033 |
| 654717 | Composite SAP Note: ORA-12538 |
| 619188 | FAQ: Oracle wait events |
| 618868 | FAQ: Oracle performance |
| 602843 | Environment settings for R/3/Oracle on UNIX |
| 581320 | FAQ: Oracle Real Application Cluster (RAC) |
| 563574 | Composite SAP note ORA-12514 |
| 555881 | NT/W2K: Net8 Configuration Assistant does not start |
| 534036 | SAP LT: System settings for conversions |
| 445769 | Net8 configuration with the Net8 configuration assistant |
| 400241 | Problems with ops$ or sapr3 connect to Oracle |
| 198752 | TCP delay problem under Oracle 8.1.x |
| 186119 | Restricting DB access to specific hosts |
| 153835 | Starting Multiple tnslsnr on same server |
| 98252 | Installing two Oracle databases on a host |