i have upgrade 10gr2 to 11gr2 successfully. but i mess with listener file., i don't understand how to TNS_ADMIN variable set wrong path.
can someone advice me how to go about it.,
new oracle home created, i also unzip appsutil.zip file under $ORACLE_HOME
can you please advice
TNS_ADMIN is set in the database context file (under $ORACLE_HOME directory) -- <TNS_ADMIN oa_var="s_db_tnsadmin">directory name</TNS_ADMIN>
Hi you mean .xml file, if yes then i have deleted that file. becuase of this TNS_ADMIN env variable confusion., now i m trying to recreate but getting error while trying to run
The log file for this adbldxml session is located at:
AC-20010: Error: File - listener.ora could not be found at the location:
indicated by TNS_ADMIN. Context file can not be generated.
Why would you delete the context file? You could simply edit/remove the context file rather than deleting the whole file
Anyway, please see my reply in your other discussion -- https://forums.oracle.com/thread/2559754