Here is a little know fact -
If you create $HOME/.tnsnames.ora file (NOTE preceeding period [hidden file] before the "t"), SQL*Net will use it before any other file.
HTH & YMMV!
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
==============================================================================