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

Postgres commads

 [oracle@Tesdb ~]$ systemctl status postgresql-15 ● postgresql-15.service - PostgreSQL 15 database server    Loaded: loaded (/usr/lib/system...