• Home
• All Oracle Error Codes
• 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

RE: SOS - URGENT********DB LINK

Baumgartel, Paul

2006-09-11

Replies:
After the SA corrects the file, test the link with
 
SELECT * from dual@PRUEBAS.US.ORACLE.COM;
 
As long as no error is returned, the link is correct.
 

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: crcbedoy@proteccion.com.co [mailto:crcbedoy@proteccion.com.co]
Sent: Monday, September 11, 2006 6:32 PM
To: Baumgartel, Paul
Cc: oracle-l@freelists.org; Smith, Steven K - MSHA
Subject: RE: SOS - URGENT********DB LINK


I checked the tnsnames.ora and the IP address is incorrect, but I can't change it now because I don't have the permissions on the machine (Solaris), I am now waiting for the Server Administrator. After changing the IP address, it should work, isn't it??

Isabel Bedoya Gómez
Centro de Gestión y Control
Tel. 2307500 ext:


"Baumgartel, Paul" <paul.baumgartel@credit-suisse.com>

11/09/2006 17:20

Para
"'crcbedoy@proteccion.com.co'" <crcbedoy@proteccion.com.co>, "Smith, Steven K - MSHA" <Smith.Steven@DOL.GOV>
cc
oracle-l@freelists.org
Asunto
RE: SOS - URGENT********DB LINK





That means that the database instance to which the link refers is not running.
 

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of crcbedoy@proteccion.com.co
Sent: Monday, September 11, 2006 6:13 PM
To: Smith, Steven K - MSHA
Cc: oracle-l@freelists.org
Subject: RE: SOS - URGENT********DB LINK


I changed, and still getting errors, now I get this error:


ERROR at line 2:
ORA-02068: following severe error from DESAROLLO9
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

Isabel Bedoya Gómez
Centro de Gestión y Control
Tel. 2307500 ext:

"Smith, Steven K - MSHA" <Smith.Steven@DOL.GOV>

11/09/2006 17:02


Para
<crcbedoy@proteccion.com.co>, <oracle-l@freelists.org>
cc
Asunto
RE: SOS - URGENT********DB LINK







That error is because you defined the database link as PRUEBAS.US.ORACLE.COM and you reference it in the statement as PRUEBAS.
 
Be consistent.
 
Steve Smith

Envision Technology Partners / MSHA MSIS Team

Desk: 303-231-5499

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of crcbedoy@proteccion.com.co
Sent: Monday, September 11, 2006 3:46 PM
To: oracle-l@freelists.org
Subject: SOS - URGENT********DB LINK


Could you please help me??


I am tryieng to create a DB link such as:

CREATE DATABASE LINK PRUEBAS.US.ORACLE.COM
CONNECT TO userid IDENTIFIED BY password
USING 'PRUEBAS.US.ORACLE.COM';


And then, when I try to do:

insert into SRHCXN1.empleado
select * from userid.empleado@PRUEBAS where emp_fecha_ingreso>=to_date('20060901','yyyymmdd')
/

I get the following error:

select * from srhcxn2.empleado@PRUEBAS where emp_fecha_ingreso>=to_date('20060901','yyyymmdd')
                             *
ERROR at line 2:
ORA-12154: TNS:could not resolve service name


I checkl the TNSNAMES.ORA and everything is alright, could anybody please help me??.. I am in a rush:(.. I have the privileges as a DBA, my username is XXX, creating running a script to insert values to the schema SRHCXN1, getting the data from the userid.

HELPPP!!!:(:(

Isabel Bedoya Gómez
Centro de Gestión y Control
Tel. 2307500 ext:

==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
 

==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================