-
Hi,
Can anyone confirm whether can I set an alias database name in Oracle database? How to do this if can?
Thanks & regards,
GS
-
Can u tell of what use will this to u? Based on it,maybe we can see for alternatives.
-
Hi,
Actually I was thinking whether I can add another alias name for the database instead of changing all client's tnsnames.ora. The purpose for this is because we will migrate the old 7.3.4 db to 9i db which currently using.
Thank you
GS
-
U can go for Oracle Names Service wherein the tnsnames entry are centralised instead of local tnsnames in each clients machine.
-
Hi,
I think this is one of the way. But I doubt whether I can specify an alias database name for my existing database. So that one database having 2 SID.
Thanks
GS
-
Hi.
There is nothing to stop you doing this in your tnsnames.ora file:
BANANA.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = W2K1.WORLD)
)
)
APPLE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = W2K1.WORLD)
)
)
Here there are two different tnsnames entries for the same instance.
Is that what you mean?
Cheers
-
Hi Tim,
Thank you for your advise. Actualy what I mean is whether we can set 2 name for db_name in init.ora file.
-
No. Only one DB name.
Cheers
-
Hi,
Got it! Thank you for your help.
-
Originally posted by TimHall
Hi.
There is nothing to stop you doing this in your tnsnames.ora file:
BANANA.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = W2K1.WORLD)
)
)
APPLE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = W2K1.WORLD)
)
)
Here there are two different tnsnames entries for the same instance.
Is that what you mean?
Cheers
Hi ,
I Think we need to create a database link inorder to meet the above situation in addition to the above changes in tnsnames.ora .
database link pointing to itself .
But , i doubt the performance of accessing the database
siva prakash
DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|