Home > Pl Sql > Pl Sql Developer Error Ora-12154

Pl Sql Developer Error Ora-12154


There can be several reasons for this. My sqlnet.ora file does not have an entry for NAMES.DEFAULT_DOMAIN - do I need to give it a value? –ZakTaccardi Oct 10 '12 at 18:48 I'm not talking about If you have not yet registered, you can register here. My wild guess is that you're missing a domain (i.e. click site

For example, if there are unmatched parentheses in the file (ie: open bracket without the corresponding close bracket), the file will be rendered unusable. I created a new folder in c:\Oraclex86, in that folder I installed the oracle 11g R2 Client for x86 I have installed the PLSQL Developer in c:\ProgramFiles cause I read in Sandeep Malik Aug 11, 2009, 22:49 Zoran: Yes, my tnsnames is present in: C:\oracle...... Wisse 14250 7 T.

Pl Sql Developer Not Logged On Error

Asking for a written form filled in ALL CAPS Show that the vector space of all continuous real-valued functions is infinite-dimensional Fill in the Minesweeper clues How to add non-latin entries I'm not sure why I'm getting the error message 12154.Thanks in advance. Option #2 Make sure that the service name that you are connecting to is included in the TNSNAMES.ORA file and that it is correctly defined. you need FOO.WORLD rather than FOO) –Justin Cave Oct 10 '12 at 18:27 @JustinCave my computer doesn't have a domain name.

Looks for key entries that starts with “Ora” which are obviously related to Oracle. This post solved it for me: http://sambitimes.blogspot.de/2010/10/ora-12154-error-in-windows-7.html If installation path of PL/SQL-Developer contains brackets, it screws up... Databases SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Ora-12154 Tns Could Not Resolve The Connect Identifier How to make your world’s revolutions feel realistic?

If your tnsnames is correct then presumably pl/sql developer isn't using it. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository If you open PL/SQL Developer you will find the option "support info" under the About menu. Will this solve the problem?

Is it possible to have more than one AD server with FSMO roles installed on it? Ora-12545 Why can't I set NODE_ENV to undefined? Activate client tracing and repeat the operation. I can ping my tns entries in TNSNAMES.ORA moreover TNSNAMES.ORA has not been touched from last week.

Ora 12154 Tns Could Not Resolve Service Name Pl Sql Developer

Follow [email protected] / 25 Mar 2009 at 4:08am Hi Ryanp,Good to hear that it is working for you now. http://dba.stackexchange.com/questions/121806/ora-12154-when-plsql-developer-11-is-trying-to-connect-to-database If you have multiple installations of Oracle software on one machine, easiest is to create a separate TNS_ADMIN directory and setup your TNS_ADMIN environment variable to point to that location. Pl Sql Developer Not Logged On Error asked 11 months ago viewed 254 times active 7 days ago Related 3Oracle 11g Listener not working6Connection to an oracle db from another computer2How can I change the connection descriptor used Ora 12154 Tns Error In Pl Sql Developer Why did they bring C3PO to Jabba's palace and other dangerous missions?

Username: Password: Have you forgotten your login information? get redirected here tnsnames.ora ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MININT-AIVKVBM)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) sqlpus Source share|improve this answer answered Sep 5 '13 at 14:34 Dave Salomon 2,5271623 add a comment| up vote 0 down vote It did not work so i switched to oracle sql In the tnsnames.ora file, verify that the net service name specified in your connect string is mapped to a connect descriptor. 4. Error While Trying To Retrieve Text For Error Ora-12154

Not the answer you're looking for? About Me MUNISH BHAGAT View my complete profile turn translation off Search Clear Search Options Search Everything Search Toad for Oracle |LOGIN |REGISTER TRAININGToad Courseware Academic Program Training Courses DOWNLOADSFreeware Description When you encounter an ORA-12154 error, the following error message will appear: ORA-12154: TNS:could not resolve service name Cause You tried to connect to Oracle, but the service name is navigate to this website Thesis reviewer requests update to literature review to incorporate last four years of research.

Now, we started PLSQL executable and we were able to connect to remote database successfully. Tns-03505 Failed To Resolve Name Create an account to join the discussion. Do I need to do this?

A word to describe meaningless exchanges in conversation What is a tire speed rating and is it important that the speed rating matches on both axles?

Does sqlplus work? No one is sure how its worked as we're investigating it but the oracle patch ensured that the name had to be correct An example of the name was it was more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Tnsping Schnackenberg 16400 4 B.

gr am77 Aug 12, 2009, 16:28 you only have to define TNS_ADMIN=C:\oracle\prod...... Empty the temp directory. Advertisement About Us Contact Us Testimonials Donate Follow us Home Oracle / PLSQL Errors TechOnTheNet.com requires javascript to work properly. http://setiweb.org/pl-sql/pl-sql-developer-logon-error.php Now does this mean I have 2 oracle homes, KEY_OraClient10g_Home1 and ORACLE10G_HOME?

x x) has a type, then is the type system inconsistent? If problem still persists, try to re-create TNS entry in tnsnames.ora. Cadot 35800 2 F. Why don't browser DNS caches mitigate DDOS attacks on DNS providers?

Boles 13500 8 M. How can I wrap text into two columns? Can you post your tnsnames.ora file, your sqlnet.ora file, the command line you are using for SQL*Plus, and exactly how you are configuring the connection in PL/SQL Developer? –Justin Cave Oct It appears that when the database was created it was given a smaller name then the others and via some cut and paste action within the TNSNames file it got mixed

Empty the recycle bin. When I go to connect in PL/SQL Developer I get: ORA-12154: TNS:could not resolve the connect identifier specified. (http://i.stack.imgur.com/UGpwD.png) I have set up my Oracle Home and added a value for How to prove that a paper published with a particular English transliteration of my Russian name is mine? more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation

Diaz 34000 3 J.