This forum is currently locked. You can't register or post questions at this time. (read more)

connection

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Mdjahangirpasha
Member
Posts: 22
Joined: Sun Dec 15, 2013 8:31 am

connection

Postby Mdjahangirpasha » Sat Jan 04, 2014 6:05 am

Hi
Tim,
and everyone
I have installed oracle database 11g on my pc and recently installed oracle developer suite 10g
I am unable to connect to my database using oracle developer suite It's giving an error that

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

How to solve this problem or can't we connect to database using older version of suite
Kindly answer me this question as soon as possible


Thanks for your valuable help

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: connection

Postby Tim... » Sat Jan 04, 2014 9:14 am

Hi.

Under the developer suite installation you will find a "network\admin" directory. In there you will need to create (or amend if it already exists) a tnsnames.ora file with an entry for the database you are trying to connect to. For example,

Code: Select all

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )


Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

apurv.life99
Member
Posts: 1
Joined: Thu Jan 16, 2014 6:53 am

Re: connection

Postby apurv.life99 » Thu Jan 16, 2014 7:01 am

Hi
Tim,
and everyone
I have installed oracle database 11gR2 on my pc and recently installed oracle developer suite 11.1.2.2.0_64
I am unable to connect to my database using oracle developer suite It's giving an error that

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

How to solve this problem,
Kindly answer me this question as soon as possible


Thanks for your valuable help

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: connection

Postby Tim... » Thu Jan 16, 2014 12:41 pm

Hi.

Looks like you are missing the network configuration settings in you ORACLE_HOME/network/admin directory. This gives and overview of them.

http://www.oracle-base.com/articles/mis ... ration.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 0 guests

cron