| creating multiple databases on same net service name [message #52355] |
Wed, 17 July 2002 08:55  |
V Sh
Messages: 8
Registered: June 2002
|
Junior Member |
|
|
Hi all,
I am using Oracle 9i and I was wondering if we can use the same service name and create multiple databases on the same service name.
For example :
Net Service Name : mynewdb
Database Name1 : db1
Database Name2 : db2
Can I bind both of these databases to the same net service name and then is there anyway I can tell sqlplus to connect to db1 or db2 using netservice name 'mynewdb'?
Are there any changes to be made in the "init.ora" file of each database?
Please reply.
Thanks.
V.
|
|
|
|
|
|
|
|
| Re: creating multiple databases on same net service name [message #52394 is a reply to message #52391] |
Thu, 18 July 2002 19:57  |
V Sh
Messages: 8
Registered: June 2002
|
Junior Member |
|
|
Thanks for the reply, Andrew.
What I am trying to say is that I have to create the same database again and again instead of creating instances of the same database and allocating those instances to the user. I am in a kind of situation where I need to have one user create one database and other user create the other database but the content of both the databases are same.
Now what I want to know is that can I be connecting to both the databases with the same service name? I guess I can't. I guess I have to specify a different service name for each kind of database that I create. Please reply me whether I am right or wrong over here.
Thanks.
V Sh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
