• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 966
  • Last Modified:

ORA-12154: TNS:could not resolve the connect identifier specified

Hi,

I am new to databases i.e. oracle .

Can anyone know how can I resolve this problem since I was configuring a engineering tool with an instance of oracle already running.

Thanks
Ammar.
0
Osloiite
Asked:
Osloiite
  • 4
  • 4
  • 2
1 Solution
 
Chakravarthi AyyalaDatabase AdministratorCommented:
May I ask you to post the tns entry that you are using?
Sometimes this can be caused by unindentation in the tnsnames.ora file.
Are you sure you are using the correct hostname, port and service_name or SID?
0
 
OsloiiteAuthor Commented:
Okay

Since I am very new to database, can u please define a possible workflow for me to solve this problem.

Thanks

Ammar
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
What is your client operating system?
For example, on Windows 7, look for tnsnames.ora under
   \app\<windows user id>\product\11.2.0\dbhome_1\NETWORK\ADMIN

Again this is just an example.
Basically, you should for this file under your ORACLE_HOME\network\admin directory on the Oracle client machine.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
OsloiiteAuthor Commented:
I would post my tnsnames.ora file tomorrow morning when I am at the office.


Looking forward for your help again

Ammar.
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
Sure.
0
 
OsloiiteAuthor Commented:
This is the file content ReliableDBA

SMARTPLA =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = osl-ppmv-vm)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = smartplant)
    )
  )

INGR =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = osl-ppmv-vm)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ingr)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
0
 
Javier MoralesOracle DBACommented:
what's the output of

tnsping <service_name>

Open in new window


you're trying to connect

such as:


E:\Documents and Settings\jmorales>tnsping sd90

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 20-OCT-2011 09:31:02

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Archivos de parßmetros utilizados:


Adaptador TNSNAMES utilizado para resolver el alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.128.99)(PORT = 1521))) (C
ONNECT_DATA = (SID = orcl) (SERVER = DEDICATED)))
Realizado correctamente (140 mseg)

Open in new window


what's the ORACLE_HOME directory being used to conect to database? (tnsping would show you that tnsnames.ora is using in versions 10g and above).

The issue is that oracle can't find the connection description you're using in the tnsnames.ora (in the ORACLE_HOME used).
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
From the machine where you are trying this, can you "ping osl-ppmv-vm" ?
0
 
OsloiiteAuthor Commented:
I resolved the problem.

Actually in the listerner.ora file there was this old Service and not the new one which I created.so I added that.

Now its working.

Btw wana ask which tool to use to create a table space. I want to import a database backup and therefore have to meet the requirements of the imported database.
0
 
Javier MoralesOracle DBACommented:
sqlplus is a good tool.

Log in and just launch:

CREATE TABLESPACE <name> DATAFILE
  'rute_of_the_datafile' SIZE 500M;

Open in new window


... but... it's another question unrelated to the main one, isn't it ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now