Regarding Database Link Name - Page 2 Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Regarding Database Link Name

  1. #11
    Join Date
    Mar 2002
    Hi Tarry,

    If I want to work with the server, we have PCAnywhere and VNC.
    Now, I want to establish a db link between 2 databases existing in 2 different locations.
    I am stuck with this error.

    Say No To Plastics

  2. #12
    Join Date
    Jan 2002
    why wud it cause any trouble to enable global_names on your stby db.
    I think if you enable it thru the pcanywhere and then try connecting , it shud work!
    I'm myself curious to know what happens...
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    --- Everything was meant to be---

  3. #13
    Join Date
    Dec 2001
    Keene, NH

    First of all, I'm no longer going to post unless I'm certain of what I'm talking about. Secondly, I was very unclear and wrong about the ALTER SYSTEM in my post.

    Here is what I was thinking about. What is displayed from
    SELECT * FROM global_name;

    and using....

    alter database rename global_name to ''

    I did not see the global_name change until I issued the alter system.

    So sorry for the confusion.

  4. #14
    Join Date
    May 2002

    Very Important (from my experience):

    Very Important (from my experience):
    If you change the parameter in the init.ora and bounce the database, it is not enough! You must issue the ALTER SYSTEM to really change it.

    Surprising though !!

    Should the ALTER SYSTEM be done before bouncing or after?!

    Never give up !

    Nanda Kumar - Vellore

  5. #15
    Join Date
    Jul 2000

    Well did you get it to work

    Vijay did you get it to work? what did you do?

    I'm experiencing exactly the same problem.

    You'll always learn something if you take your time to ask.

  6. #16
    Join Date
    Jul 2000

    found in the forum

    Originally posted by e067450
    See if this helps you ?

    Found this in a Metalink article (DocID=1024124.6)

    This is not documented in the Oracle manuals and can be useful (even required) when the init.ora parameter GLOBAL_NAMES is set to TRUE.....
    Note that if GLOBAL_NAMES is set to FALSE, you can name the dblink anything you desire.

    Database Links
    Database links are created using the following syntax:

    SQL> create database link
    connect to identified by
    using '';

    The name of the database link should match the global name of the target
    database if GLOBAL_NAMES=TRUE. This may seem restricting since then there can
    be only one database link per schema to a given database if global_names is
    set to true. To overcome this use database link qualifiers. For example:

    SQL> create database link oradb@link1
    using 'D:BOSTON-MFG';

    NOTE: in this example, 'link1' is database link qualifier
    and 'D:BOSTON-MFG' is the connect string

    My NOTE : your select to the remote database would look like this :
    select * from table_name@oradb@link1;

    This was in an earlier thread did you try this?

    You'll always learn something if you take your time to ask.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width