TNS error

[Roshan]

Hello,

after installing Oracle client and setting environment variables, I am getting

TNSerror.png

In services.msc, the OracleService cannot be found.

Regards,
Roshan

[ErmanArslansOracleBlog]

what env variables did you set?Send me the output of cmd "set" command.

Is your windows oracle db service running? ( check it from msc.services)

20 Mar 2017 09:55 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hello,

after installing Oracle client and setting environment variables, I am getting

TNSerror.png

In services.msc, the OracleService cannot be found.

Regards,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/TNS-error-tp2389.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

set ORACLE_HOME=E:\app\client\product\12.1.0\dbhome_1\BIN
set ORACLE_SID=LBT
set PATH=%ORACLE_HOME%\bin:%PATH%

Oracle Service is not present
Capture.PNG

[ErmanArslansOracleBlog]

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

[Roshan]

Hi Erman,

I think the issue is on the PATH variable
Capture.PNG

set PATH=E:\app\client\product\12.1.0\dbhome_2\BIN
set ORACLE_HOME=E:\app\client\product\12.1.0\dbhome_2
set ORACLE_HOSTNAME=RH-DLP-ES01.mtg.local
set ORACLE_SID=DLP
set ORACLE_UNQNAME=DLP
net start OracleServiceDLP

[Roshan]

which service name should I include?
servicename.PNG

[Roshan]

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\app\chris\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\chris\product\12.1.0\dbhome_1\bin\oraclr12.dll")
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\app\chris\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\chris\product\12.1.0\dbhome_1\bin\oraclr12.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = RH-DLP-ES01.mtg.local)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

[ErmanArslansOracleBlog]

You don't have the Windows service.
What is the environment? Are you trying clone a database on windows environment or what?

Follow this document:
IF: Troubleshooting ORA-12560 Errors Reported during Bequeath Connection on Windows Platform. (Doc ID 2016580.1)

[Roshan]

I am only installed the Oracle client. I will continue with the dbca.

Thanks,
Roshan

[ErmanArslansOracleBlog]

You can't have a database if you have only Oracle Client installed.
You need to install Oracle RDBMS and then create a database using dbca.

[Roshan]

Thanks Erman :)
It is ok now