| datebase link not active [message #75033] |
Sat, 24 March 2001 05:17  |
wyshuai
Messages: 13
Registered: December 2000
|
Junior Member |
|
|
I created a database link , but when I test it , the error message is "database link not active".how to do it?
----------------------------------------------------------------------
|
|
|
|
| Re: datebase link not active [message #75036 is a reply to message #75033] |
Thu, 12 April 2001 21:50  |
anjan
Messages: 9
Registered: February 2001
|
Junior Member |
|
|
1. change the global_names parameter in the
init.ora file. it should look like
: global_names=false
2. create a public database link. (better to
grant dba priviledge to the user who is
creating the db link.)
let me know whether it works or not.
anjan saikia.
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
| datebase link not active(it is urgent) [message #75553 is a reply to message #75262] |
Wed, 29 September 2004 07:01 |
Muhammad Rashid
Messages: 4
Registered: September 2004
|
Junior Member |
|
|
I am using Oracle 9i on windows 2000 server.
(1)I created two databases at two different computers
(i) mydb01.HOST1.AIT.COM
(ii) mydb02.HOST2.AIT.COM
(2) :global_names = false on both databases.
(3) create net service name "abc" at HOST1.AIT.COM. It is working properly.
(4)Create database link at mydb01.HOST1.AIT.COM by following command:
create public database link "mydb02.HOST2.AIT.COM" using 'abc'
(5) It shows "Database link not active"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
