.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
ORA-12154
ORA-12154:TNS:could not resolve the connect identifier specified
Cause:A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. 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 could not be located or reached.
Action:

- If you are using local naming (TNSNAMES.ORA file):

- Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)

- Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.

- Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.

- Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.

- If you are using directory naming:

- Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).

- Verify that the LDAP directory server is up and that it is accessible.

- Verify that the net service name or database name used as the connect identifier is configured in the directory.

- Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier

- If you are using easy connect naming:

- Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).

- Make sure the host, port and service name specified are correct.

- Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming.

Posts about ORA-12154

Dbstart problem

Hi all I have been dealing with a problem of starting oracle. Whenever I issue dbstart or rman I get the following error message bash-2.05$ ./sqlplus /nolog SQL*Plus Release 10.1.0.2.0 - Pro

ODP.NET - Weird Behaviour

Hi List We have a VB .NET application which is using Oracle ODP.NET 9.2 version for the connectivity to the database. If the application is placed under the any folder name ends with ') ' it crash

TNS Resolution

I have a strange (to me anyway) problem with TNS. Connecting with SQL*Plus SQL*Navigator TOAD I get "ORA-12154 TNS could not resolve service name " But tnsping returns in 100-130 msecs. ?!?!?!

tnsnames.ora file missing

Hello I`ve installed Oracle 10g 10.2.0 Enterprise Edition on SUSE Enterprise Server 9. After this I installed Compiere2. I tried to run program that will import data to database but I encountered f

OID and AD

Thanks a lot it helps - Oracle ldapsearch works. But while installing Acive Directory plug-in it asks database connect string - what base does it mean? I tryied sysman/sysman_pass@(protected) OID h

Resolving dblinks

One of our databases was started with TNS_ADMIN set to a directory where there was no TNSNAMES.ORA file. Now when a remote user starts an Sqlplus session and attempts to use a synonym using a dblink

Connecting to Oracle 10RAC from Orace 9 client

Hi All We are doing some pelminary testing on some new hardware/software and we are hoping to be able to connect to an Oracle 10RAC from our standard Oracle 9 Libraries. We have a large num

SV: [suse-oracle] Oracle install: Database Config Assistant for 10g
on Prof

Yes. I have specified it in /etc/profile.d/oracle.sh and "env | grep ORA " tells me the same. -----Oprindelig meddelelse----- Fra Daniel Ducey [mailto wo6m@(protected)] Sendt 20. januar 2005 1

Oracle install: Database Config Assistant for 10g on Professional

Hi I am trying to install Oracle 10gR1 on SuSE Prof. 9.2 for x86. I choose Standard Edition and did not change any of the installed products. Everything seems to be fine and the only warning I get

TNS_ADMIN - SOLVED !!!

There was an tnsnames.ora in /etc !!!!!!! THANK YOU ALL !!!!!! -----Original Message----- From Mercadante Thomas F [mailto thomas.mercadante@(protected)] Sent Thursday November 0

TNS_ADMIN

Group HOST MACHINE HP-UX B.11.11 U 9000/800 ORACLE Oracle9i Enterprise Edition Rel. 9.2.0.5.0 - 64 bit LISTENER Version 10.1.0.2.0 TNSNAMES.ORA ls -lai $ORACLE_HOME/network/admin/tnsnam

DBlink

Hi friends I am having the following problem while selecting data trhu the dblink My oracle version is 9.0.2 and I am creating dblink to the database version 8.1.7 ie KPIT. CREATE PUBLIC DAT

Urgent help: strange DB_LINK problem...

Change global_names to false Igor Neyman OCP DBA ineyman@(protected) -----Original Message----- From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)] On Behalf Of

Report question

I am new using Oracle and I have just installed the 10g database and the 10g developer suite. I am trying to run reports to teach myself. I run the reports wizard and I get a window to connect to

Oracle/PHP Issue

All We 're having a situation with Oracle and PHP that I am hoping someone may have encountered and can provide some guidance on. We have an Oracle 8.1.6 database instance running on a RedHat 7.

New Name for an old friend

Mistyping a tnsentry in 10g gives ORA-12154 TNS could not resolve the connect identifier specified Hugely improved error message I think. I hope there was at least a 3 hour internal meeting

9i client tnsping error

Hi I have just installed oracle client 9.2.0.1.0 on one unix box (called curly) and I am trying to connect to an oracle 8173 server (on another unix box called rex). During the installastion
User Posts


No registration required.
Post Topic:
Oracle Database Server Error Codes
ORA-00020   ORA-00054   ORA-00119   ORA-00279   ORA-00381   ORA-00439   ORA-00600   ORA-00604   ORA-00904   ORA-00907   ORA-00911   ORA-00922   ORA-00923   ORA-00936   ORA-00942   ORA-01000   ORA-01017   ORA-01031   ORA-01033   ORA-01034   ORA-01078   ORA-01092   ORA-01113   ORA-01122   ORA-01161   ORA-01422   ORA-01501   ORA-01555   ORA-01562   ORA-01578   ORA-01650   ORA-01652   ORA-01658   ORA-01722   ORA-01756   ORA-01843   ORA-01925   ORA-01940   ORA-02019   ORA-02097   ORA-02143   ORA-03113   ORA-04030   ORA-04031   ORA-04068   ORA-06502   ORA-06512   ORA-06531   ORA-06550   ORA-07445   ORA-12154   ORA-12203   ORA-12500   ORA-12535   ORA-12540   ORA-12545   ORA-12560   ORA-12599   ORA-12638   ORA-12709   ORA-12838   ORA-12913   ORA-16038   ORA-20000   ORA-24324   ORA-27125   ORA-28575   ORA-28576   ORA-29283   ORA-29540   ORA-32004