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.

Featured post

Restircted session due to sync filed with ora-65177

Application is unable to connect the database due to restricted session. sql> show pdbs; SQL> show con_name CON_NAME -----------------...