Re: TNS error

Posted by ErmanArslansOracleBlog on Mar 20, 2017; 11:07am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/TNS-error-tp2389p2392.html

Hi Roshan,

You need to have your Oracle services running.

Here is a service start script...
This is an example, you need to modify it according to your environment.
(note that you need to have your oracle services defined at least...)

set Path="F:\app\oracle\product\11.2.0\dbhome_1\bin;F:\app\oracle\client\bin;C:\Program"
set ORACLE_HOME="F:\app\oracle\product\11.2.0\dbhome_1"
set ORACLE_HOSTNAME=ERMANSERVER
set ORACLE_SID=DBERMAN
set ORACLE_UNQNAME=DBERMAN
net start OracleServiceDBERMAN
net start OracleOraDb11g_home1TNSListener