Problem:
After configuring TNS names on the client, tried to connect to new 11.5.10.2 instance but failed.
Solution:
Managed SQL Access enabled. To disable, follow these steps:
Step 1: Login to E-Business Suite with the ‘System Administrator’ Responsibility.
Step 2: Go to : Profile –> System
Step 3: Query the Profile “SQLNet Access’ at Site Level.
Step 4: Set the Profile with the Value : ALLOW_ALL
Step 5: Save and Exit Oracle Applications
Step 6: Run Autoconfig on the 9i ORACLE_HOME
cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME
adautocfg.sh
Step 7: Bounce the 9i SQLNet Listener :
cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME
addlnctl.sh stop <SID>
addlnctl.sh start <SID>
Metalink Reference:
Subject: 11.5.10 New Features : Managed SQL*Net Access from Hosts
Doc ID: Note:291897.1
0 Comments.