| DB_LINK not active [message #58739] |
Mon, 29 September 2003 05:25  |
shad
Messages: 50
Registered: October 2000
|
Member |
|
|
Hi all.
--> What should I do if the DB_LINK is not active?
How do I activate it?
Regards
Shad
|
|
|
|
| Re: DB_LINK not active [message #58799 is a reply to message #58739] |
Tue, 30 September 2003 23:48  |
Arvind Bhandari
Messages: 50
Registered: May 2003
|
Member |
|
|
go thru Initorcl.ora parameter file and set 1 parameter ie global_names = FALSE(Default is TRUE and default is commented hope so)
also uncommented following parameter(if commented)
db_domain = us.com
and check for DB Link is Active Now
Arvind
By default Following lines are used in parameter File
# Global Naming -- enforce that a dblink has same name as the db it connects to
# global_names = TRUE
# Edit and uncomment the following line to provide the suffix that will be
# appended to the db_name parameter (separated with a dot) and stored as the
# global database name when a database is created. If your site uses
# Internet Domain names for e-mail, then the part of your e-mail address after
# the '@' is a good candidate for this parameter value.
# db_domain = us.com # global database name is
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
