| some problem in database creation [message #318846] |
Thu, 08 May 2008 03:47  |
mbhavin
Messages: 30
Registered: May 2008
Location: INDIA |
Member |
|
|
can anybody solve this problem i am getting while creating database manually
here is the step that i perform to create database manually
this is my initcatdb.ora file
*._job_queue_interval=60
*.aq_tm_processes=1
*.background_dump_dest='/u02/app/oracle/admin/CATDB/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u02/app/oracle/admin/CATDB/catdb1.ctl'
*.core_dump_dest='/u02/app/oracle/admin/CATDB/cdump'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_cache_size=805306368
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='catdb'
*.db_writer_processes=4
*.dispatchers='(PROTOCOL=TCP) (SERVICE=********)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='catdb'
*.java_pool_size=83886080
*.job_queue_processes=20
*.large_pool_size=8388608
*.log_archive_dest_1='location=/u02/app/oracle/admin/CATDB/arch'
#*.log_archive_dest_2='SERVICE=*********'
#*.log_archive_dest_state_2='ENABLE'
#*.log_archive_dest_state_3='ENABLE'
and my create database script is as follow
CREATE DATABASE catdb
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 '/newdata/app/oracle/oradata/CATDB/redo01.log' SIZE 100M,
GROUP 2 '/newdata/app/oracle/oradata/CATDB/redo02.log' SIZE 100M,
GROUP 3 '/newdata/app/oracle/oradata/CATDB/redo03.log' SIZE 100M
DATAFILE
'/newdata/app/oracle/oradata/CATDB/system01.dbf',
'/newdata/app/oracle/oradata/CATDB/undotbs01.dbf',
'/newdata/app/oracle/oradata/CATDB/drsys01.dbf',
'/newdata/app/oracle/oradata/CATDB/indx01.dbf'
CHARACTER SET WE8ISO8859P1
;
error that i am getting is as below
when i start database in nomount mode using pfile it work fine
SQL> startup nomount pfile=initcatdb.ora
ORACLE instance started.
Total System Global Area 1615403728 bytes
Fixed Size 453328 bytes
Variable Size 704643072 bytes
Database Buffers 805306368 bytes
Redo Buffers 105000960 bytes
i am getting this error
SP2-0734: unknown command beginning "MAXLOGFILE..." - rest of line ignored.
SP2-0734: unknown command beginning "MAXLOGMEMB..." - rest of line ignored.
SP2-0734: unknown command beginning "MAXDATAFIL..." - rest of line ignored.
SP2-0734: unknown command beginning "MAXINSTANC..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "MAXLOGHIST..." - rest of line ignored.
SP2-0042: unknown command "LOGFILE" - rest of line ignored.
SP2-0734: unknown command beginning "GROUP 1 '/..." - rest of line ignored.
SP2-0734: unknown command beginning "GROUP 2 '/..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "GROUP 3 '/..." - rest of line ignored.
SP2-0042: unknown command "DATAFILE" - rest of line ignored.
SP2-0734: unknown command beginning "'/newdata/..." - rest of line ignored.
SP2-0734: unknown command beginning "'/newdata/..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/newdata/..." - rest of line ignored.
SP2-0734: unknown command beginning "'/newdata/..." - rest of line ignored.
SP2-0734: unknown command beginning "CHARACTER ..." - rest of line ignored.
1* CREATE DATABASE catdb
|
|
|
| Re: some problem in database creation [message #318853 is a reply to message #318846 ] |
Thu, 08 May 2008 04:17  |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
There is a blank line in your script.
Regards
Michel
|
|
|
|
| Re: some problem in database creation [message #318870 is a reply to message #318868 ] |
Thu, 08 May 2008 05:32 |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
You have to restrat from the beginning, shutting down the instance, verifying there is no file related to this database and so on, and then reexecute the script.
I forgot, you have to exit from sqlplus before.
Regards
Michel
|
|
|
|
|
]
Members
Search
Help
Register
Login
Home
create spfile from pfile