Updating tnsnames

Rated 3.98/5 based on 669 customer reviews

I am creating an SMS package to deploy a TPT upgrade.

This upgrade will require an amendment to the file (can be edited via notepad etc) in the way of added lines of text.

These settings will be saved in $oracle_home On the client, Start the OEM Console, the default OEM administrator is "sysman" with a password of "oem_temp".

Set the environment variable in the Advanced tab of the System Properties control panel. Check it is set: echo %TNS_ADMIN% Then run tnsping to check if your connect string can be resolved: tnsping If TNS_ADMIN is not set then sqlplus will look for in the default location: %ORACLE_HOME%\newtork\admin For details on ORACLE_HOME: . On most windows computers this is something like c:\oracle\ora Db10_home1\network\admin.

Tns Update can support Oracle 7.3.4 thru Oracle 8.1.6.

It is an executable runs based on a script that the user executes off a file share that update the users file. Instructions: Click the link below to download the code. Once downloaded, open the file from your local drive using Win Zip or a comparable program to view the contents.

If you do nothing (i.e., don't define TNS_ADMIN anywhere) then Oracle will look in the default location %ORACLE_HOME%\network\admin.

$HOME for hidden files only (i.e., .and .tnsnames.ora) 2. Environment variable TNS_ADMIN defined for the system 4. %ORACLE_HOME%\network\admin Now, from what I've read of the posts you are using Windows.

Leave a Reply