| Installation [message #329697] |
Thu, 26 June 2008 05:00  |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
1. Oracle 9i is installed on C drive.
2. We need two instances of Oracle 9i, one on drive C: and another on drive D:, on the same machine.
3. User name for both the instances should be: TESTSERVER
password for both the instances should be: TESTSERVER
4. The user "TESTSERVER" for both the instances should have DBA rights on Oracle server.
How can i do it?
Thanks in advance.
|
|
|
|
|
|
| Re: Installation [message #329814 is a reply to message #329697] |
Thu, 26 June 2008 11:10  |
hhelgen
Messages: 12
Registered: April 2007
Location: Duluth MN
|
Junior Member |
|
|
What do you mean by two instances?
- If you mean two separate installs into their own Oracle home? Oracle 9i database can be installed in a single home and serve multiple databases.
- If you mean two separate databases, they cannot have the same SID or service name. One could be named DEV and the other could be TEST, for example. Try the Database Configuration Assistant that gets installed with Enterprise Manager.
- If you mean two schemas in an existing database see the following code to create a DBA user in a database. This assumes that the USR tablespace in one database has its datafiles on C: and the USR tablespace on the other database has its datafiles on D:
CREATE USER "TESTSERVER" PROFILE "DEFAULT"
IDENTIFIED BY "TESTSERVER" DEFAULT TABLESPACE "USR"
ACCOUNT UNLOCK;
GRANT "CONNECT" TO "TESTSERVER";
GRANT "DBA" TO "TESTSERVER";
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
