RE: SOS - URGENT********DB LINK
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'crcbedoy@xxxxxxxxxxxxxxxxx'" <crcbedoy@xxxxxxxxxxxxxxxxx>
- Date: Mon, 11 Sep 2006 23:27:26 +0100
After the SA corrects the file, test the link with
SELECT * from dual@xxxxxxxxxxxxxxxxxxxxx;
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: crcbedoy@xxxxxxxxxxxxxxxxx [mailto:crcbedoy@xxxxxxxxxxxxxxxxx]
Sent: Monday, September 11, 2006 6:32 PM
To: Baumgartel, Paul
Cc: oracle-l@xxxxxxxxxxxxx; 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@xxxxxxxxxxxxxxxxx>
11/09/2006 17:20
Para
"'crcbedoy@xxxxxxxxxxxxxxxxx'" <crcbedoy@xxxxxxxxxxxxxxxxx>, "Smith, Steven K -
MSHA" <Smith.Steven@xxxxxxx>
cc
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx
Sent: Monday, September 11, 2006 6:13 PM
To: Smith, Steven K - MSHA
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx>
11/09/2006 17:02
Para
<crcbedoy@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx
Sent: Monday, September 11, 2006 3:46 PM
To: oracle-l@xxxxxxxxxxxxx
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
==============================================================================
Other related posts:
