NT: database A (local) Version: 8.1.7
UNIX: database B (remote) Version: 7.3.4
I went svrmgrl in NT to create a database link to database B. Then, I create
a table in order to insert data from v$license in remote database. When I run
the script to insert the data, it gives me an error message.
FROM v$database@B.world, v$license@B.world
ERROR at line 3:
ORA-02019: connection description for remote database not found
I don't know how to fix error 02019. I need your help. Below is my sample script:
INSERT INTO lic_info (db_name, count_date, user_count)
SELECT name, sysdate, sessions_highwater
FROM v$database@B.world, v$license@B.world;
I might be missing something, but I understood that to create links to database you needed to set up tnsnames.ora file to see the other database (on the server that you are connecting from), then you test to see if you can connect using the '@'. The next step would be 'CREATE DATABASE LINK...' statement, to be able to directly access tables etc from the remote database.
Am I wrong? This was how I did it, but have things changed?
I didn't go to the tnsnames.ora. I went straight svrmgrl and create database link.
From then on, I can connect to the remote database using sql*plus from my local database.
What was the name of the database link you created?
Check your remote databas's paramenter of global database name. If it had been set to true, then you have to use that database instance name on your link not any thing else.
If it had been set to false then you can use any name as your link for that instance.
Life is a journey, not a destination!
I check out the global_name and it shows true. It matches with my local NT machine.
I drop the database link and recreate to see what happen. I think you're right Nirasha.
It gives an error message:
ORA-12154: TNS:could not resolve service name
I'm not familiar with tnsname.ora on the server. Name of the database is A.
The tnsname.ora should be on the server 7.3.4 (please correct me if I'm wrong.)
(COMMUNITY = TCPCOM.world)
(PROTOCOL = TCP)
(Host = "my_host_name")
(Port = 1521)
get data from remote...
This has continuation of your lines.....
(CONNECT_DATA = (SID = your SID)
(GLOBAL_NAME = A.world)
Repeat for another instance name..which you want to connect say in your case B.save it.
Then it will work.
Click Here to Expand Forum to Full Width