| shahul |
Posted: Dec 28, 2007 09:45:59 AM |
Total Post: 17
Joined: Sep, 2007
|
Im trying to create a database 9.2.0.4.0 manually in RedHat Linux, im able to login as /as sysdba and im statrting the database in nomount stage
.In that stage im trying create database using create database command. after giving the command im getting the following error
create database vm1 logfile
2 group 1 '/u01/app/oracle/oradata/vm1/redo01.log' size 10m,
3 group 2 '/u01/app/oracle/oradata/vm1/redo02.log' size 10m
4 datafile '/u01/app/oracle/oradata/vm1/system01.dbf' size 50m autoextend on
5 undo tablespace UNDOTBS1
6 datafile '/u01/app/oracle/oradata/vm1/undo01.dbf' size 40m
7 default temporary tablespace temp
8 tempfile '/u01/app/oracle/oradata/vm1/temp01.dbf' size 20m;
create database vm1 logfile
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
In bdump directory im not able to see the alert log file. but all files (i.e)controlfiles,redologfileand database files are created in oradata directory.
Can anybody help me please.......................
im also giving the parameter file below
*.aq_tm_processes=1
*.background_dump_dest='/u01/app/oracle/admin/vm1/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/vm1/control01.ctl','/u01/app/oracle/oradata/vm1/control02.ctl','/u01/app/oracle/oradata/vm1/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/vm1/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='vm1'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=vm1XDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='vm1'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/vm1/udump'
Im awaiting for your valuable replies.... |
|
|
 Rohit Chouhan |
| Posted: Dec 28, 2007 11:37:31 PM |  |
|
Total Post: 11
Joined: Aug, 2007
|
Hi,
I have checked command. It's correct.
If you are creating database in 10g then just add sysaux datafile clause in command like this :
SQL> create database............
sysaux datafile '/u01/app/oracle/vm1/sysaux.dbf' size 10m autoextend on next 10m maxsize 200m..........
Search for alert_vm1.log file, you will find path & rectify the problem.
check for the disk space also.
Regards,
Rohit Chouhan
|
|
|
|
|
| Mohammed Taj |
| Posted: Dec 28, 2007 11:57:14 PM | |
|
Total Post: 694
Joined: Jul, 2007
|
@OP,
Again check your undo tablespace parameter in pfile, in your above posted information it seem correct but disconnect instance happen during startup when undo tablespace name is not matched with pfile.
http://dbataj.blogspot.com/2006/11/manually-database-creation.html
@Rohit
OP is running on ORacle 9i and sysaux tablespace option introduce in 10g.
|
|
|
|
|
| shahul |
| Posted: Dec 29, 2007 02:20:10 AM | |
|
Total Post: 17
Joined: Sep, 2007
|
Hi Rohit,
This is 9i database, so there is no option like sysaux tablespace right?
Hi Taj,
you just check with my first thread where the Undo tablespace name are same in pfile and the command creat database. So i think that will not be problem. And also im not able to find the alert log file in bdump directory, Can you please tell me when the alert log file is being created , i.e In which stage the alert log file is created (whether it created when instance startup or nomount or mount or open stage please clarify me)
Thanks for your immediate replies
|
|
|
|
|
| Babu |
| Posted: Dec 29, 2007 05:43:46 AM | |
|
Total Post: 90
Joined: Oct, 2007
|
Are you sure there is no information in alert.log
|
|
|
|
|
| jothi |
| Posted: Dec 30, 2007 01:32:27 PM | |
|
Total Post: 24
Joined: Aug, 2007
|
hi,
you please check whether the password file was created sucessfully.
|
|
|
|
|
| shahul |
| Posted: Dec 31, 2007 04:11:26 AM | |
|
Total Post: 17
Joined: Sep, 2007
|
Hi
Im Sure that i didnt get created alert log file in bdump directory.
The password file also created successfuly
|
|
|
|
|
| jothi |
| Posted: Dec 31, 2007 04:40:48 AM | |
|
Total Post: 24
Joined: Aug, 2007
|
hi shahul,
you please give the command that you gave to create the password file.
|
|
|
|
|
| Babu |
| Posted: Dec 31, 2007 05:46:49 AM | |
|
Total Post: 90
Joined: Oct, 2007
|
Yes post your OraPwd command and post last 50-100 entries in your alert log file.
|
|
|
|
|
| shahul |
| Posted: Dec 31, 2007 09:29:26 AM | |
|
Total Post: 17
Joined: Sep, 2007
|
Hi guys,
Thanks for your response. The problem have been solved, i dont know what would be the reason,
i have tried by creating password file and giving permission 777 to bdump,udump,cdump at same time , so i dont know which is the cause to the problem whether the problem is from password file or from the file permission problem.
Thanks.
|
|
|
|
|
| jay |
| Posted: Jan 03, 2008 01:31:50 AM | |
|
Total Post: 1
Joined: Jan, 2008
|
hi,
I got a similiar error try changing the order of the statements in Ur create db script i mean
first U R creating logfiles then system,undo,temp
make it system,temp,undo,logfiles see if it works
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
