Home » SQL & PL/SQL » SQL & PL/SQL » Database link
Database link [message #257088] Tue, 07 August 2007 10:13 Go to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

I created database link from stg_amn/stg_amn@GSPARCP1 to scott/welcome@RRWP0. I Been having trouble getting this
to work in fact having trouble even connecting from TOAD to RRWP0 (sqlplus from unix works though). GAPARCP1 is on 9.2.0.8 and RRWP0 is on 9.2.0.4.

Thanks in advance
Re: Database link [message #257093 is a reply to message #257088] Tue, 07 August 2007 10:19 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Do you get an error message when you try to use it ?
Re: Database link [message #257096 is a reply to message #257093] Tue, 07 August 2007 10:22 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Yes, i get an error.
Re: Database link [message #257098 is a reply to message #257088] Tue, 07 August 2007 10:26 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Sorry, I should have made my question clearer.

Do you get an error message when you try to use it ? And, if so, can you tell us what error message you are getting ?
Re: Database link [message #257103 is a reply to message #257098] Tue, 07 August 2007 10:31 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

The link created but, when i am go for test. it pops up an intiallization errors that could not intialize the link.
Re: Database link [message #257107 is a reply to message #257088] Tue, 07 August 2007 10:36 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
How about cutting and pasting your error.

If you want a solution provide details
Re: Database link [message #257135 is a reply to message #257107] Tue, 07 August 2007 11:21 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
We are not MIND readers..
Re: Database link [message #257505 is a reply to message #257135] Wed, 08 August 2007 08:52 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Here is sql execution,
select * from source_data_y2004M08@RRWP0
                                   *
ERROR at line 1:
ORA-02068: following severe error from RRWP0
ORA-01033: ORACLE initialization or shutdown in progress

Re: Database link [message #257529 is a reply to message #257505] Wed, 08 August 2007 10:03 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wait for the remote database restarts.

Regards
Michel
Previous Topic: Send mail from Gmail (merged by LF)
Next Topic: How to clean entire Oracle db/attain empty db
Goto Forum:
  


Current Time: Thu Dec 08 00:41:21 CST 2016

Total time taken to generate the page: 0.05046 seconds