user10876301 wrote:Please source the database env file under %ORACLE_HOME% directory (search for the env file under c:\ora\VIS\db\tech_st\11.1.0 directory) instead of setting the above manually and run the same command/script then.
I have successfully installed the EBS R12.1.1 Visio DB on Platform: Windows 2003 Server EE.
and when I tried to apply the "Oracle Applications DBA 12.1.3 Product Release Update Pack" to upgrade to 12.1.3.
following below steps. I am getting "ORA-12557: TNS:protocol adapter not loadable" error
C:\> set ORACLE_HOME=c:\ora\VIS\db\tech_st\11.1.0
C:\> set ORACLE_SID=VIS
C:\> sqlplus /nolog
SQL> @%ORACLE_HOME%\appsutil\admin\adgrants_nt.sql APPS
ORA-12557: TNS:protocol adapter not loadable
I have following keys exist in the Registry:
Please suggest where I am going wrong? am i setting the right ORACLE_HOME?. I have seen other posts on Tns: protocal adapter not loadable error. Most of the places they are suggesting to delete the multiple Oracle_homes in the registry. But As i am running Oracle EBS App server and database server on same server dont know if i will currupt the registry if i delete the other oracle_homes. And not even sure which key i have to delete.?