| vikhardba |
Posted: Dec 31, 2007 11:23:38 AM |
Total Post: 84
Joined: Apr, 2007
|
Oracle 10g is installed on Win 2000 professional . I have created a database "DEVL" using DBCA, and its home directory is f:\oracle\product\10.2.0\db_1 . However .dbf, .ctl and redo files are created in the following path:
f:\oracle\oradata\devl\ and bdump, cdump, udump are created in devl folder. Now my issue is i need to create another database called "PROD" , can anyone guide me how to do it. I need to manually create the database. What is the best method? Also, the reason for creating another database on my same machine is have to link this two databases. E:\ is having sufficient space ( around 30 GB ) So, i would like to create another database in E:\ drive.
Existing Env Variable is: ORACLE_HOME=F:\oracle\product\10.2.0\db_1
TNS_ADMIN = F:\oracle\product\10.2.0\db_1\network\admin
Waiting for your response. |
|
|
 Mohammed Taj |
| Posted: Dec 31, 2007 11:24:24 PM |  |
|
Total Post: 694
Joined: Jul, 2007
|
YOu can create more than one database on single system.
the procedure is same which you follow in first database creation time.
means you can use DBCA to create new database.
|
|
|
|
|
| vikhardba |
| Posted: Jan 01, 2008 04:15:25 AM | |
|
Total Post: 84
Joined: Apr, 2007
|
Yes, you are rite. However, instead of using dbca, i would like to create database manually. Please see below given steps, i followed. Please correct me...
1st database = devl
2nd database = prod ( going to create as follow: )
Specifying the instance ID
F:\oracle\product\10.2.0 > set ORACLE_SID=prod
Creating an Oracle Service:
As we all know, on windows, each instance requires a Windows service. This This service must be created with oradim:
F:\oracle\product\10.2.0 > oradim -new -sid prod -intpwd password -startmode m
Creating the initialization parameter file and then connect to sql
sql>startup nomount ( creates SGA and background processes )
Error
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-00371 : not enough shared pool memory, should be atleast 67232153 bytes
I have increased the shared_pool_size value but still i am getting same error.
I am using 384 MB RAM
|
|
|
|
|
| vikhardba |
| Posted: Jan 01, 2008 04:16:32 AM | |
|
Total Post: 84
Joined: Apr, 2007
|
Hi Taj,
Thanks for your speedy response. Also, if possible can you please forward documentation on this.
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 01, 2008 07:30:49 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
>ORA-32004: obsolete and/or deprecated parameter(s) specified
First what is your oracle version ? becuase according your oracle version your using obsolete parameter so please show us your init.ora file.
>ORA-00371 : not enough shared pool memory, should be atleast 67232153 bytes
What is your actual RAM size in system and what is size of your first database ?
again post your init.ora file.
http://dbataj.blogspot.com/2006/11/manually-database-creation.html
|
|
|
|
|
| vikhardba |
| Posted: Jan 01, 2008 11:02:37 AM | |
|
Total Post: 84
Joined: Apr, 2007
|
Using 256 + 128 = 384 MB RAM
Please find below given SPFILEPROD.ORA file. but atlast i followed dbca procedure to create another database on same system and created successfully.
version is 10.2.0.1.0 and installed on Windows 2000 prof
*.background_dump_dest='e:\oracle\oradata\prod\udump'
*.control_files='e:\oracle\oradata\prod\cont.ctl','e:\oracle\oradata\prod\cont1.ctl'
*.core_dump_dest='e:\oracle\oradata\prod\cdump'
*.db_block_size=8192
*.db_cache_size=30M#DEMO
*.db_file_multiblock_read_count=16
*.db_name='prod'
*.log_archive_dest='e:\oracle\oradata\prod\arch'
*.optimizer_mode='choose'
*.parallel_automatic_tuning=true
*.parallel_threads_per_cpu=4#SMALL
*.pga_aggregate_target=30M#DEMO
*.query_rewrite_enabled='true'
*.query_rewrite_integrity='trusted'
*.shared_pool_size=20M#DEMO
*.star_transformation_enabled='true'
*.undo_management='auto'
*.undo_retention=900
*.undo_tablespace='UNDO_PRODTB'
*.user_dump_dest='e:\oracle\oradata\prod\udump'
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
