Tuesday, 13 August 2019

oracle clinet installation and troubleshooting on 12c

client installation
_______________






Troubleshooting.

how to connect from client to oracle db/

1) go to oracle home client and add tns names .ora file will valid tns entries.

2) go to computer, properties add the values as below.

advance setting

environment varible.

under user variable add line as oracle_home= <clinet oracle_home path>

under system variable add %ORACLE_HOME%\bin;


3) sqlplus /as sysdba

protocal error


sqlplus  om/om1@ofd

connected.

No comments:

Post a Comment

Featured post

duplicate db from standy to other server

 Duplicate Testuat   $ export ORACLE_SID=Testuat3 $ sqlplus '/as sysdba' Testuat3 SQL> alter system set cluster_database=FALSE sc...