| multiple databases & charcterset [message #98361] |
Tue, 17 August 2004 22:04  |
ramya
Messages: 87
Registered: August 2002
|
Member |
|
|
hi
how can i created multiple databases in one oracle software.i am using oracle9.2.How we can set multiple profiles cos i am logging as one user.so how to set defualt db we can use after creating multiple dbs.so we use ORACLE_SID=dbname;export ORACLE_SID.my dought is how to incorporate these things.if
i am using different characterset
with regards
ramya
|
|
|
|
| Re: multiple databases & charcterset [message #98362 is a reply to message #98361] |
Wed, 18 August 2004 01:34  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
You can easily create multiple databases under a single oracle software. It is not any special case, at almost all of the sites you will find multiple databases running under single oracle installation. That software will be owned by a single OS user in Unix/Linux. There is no need to create separate OS user for each database.
If you have multiple databases then the default will be one, whose entry would be in the OS user's profile. If you are sitting directly on oracle server box and want to access another database then you have to set ORACLE_SID environment variable, but to access it remotely use appropriate net connection string to identify each database uniquely. Moreover there is no harm at all to run multiple databases with different charactersets under single oracle software.
Hope it will help you.
Daljit Singh.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
