Home » RDBMS Server » Server Administration » some problem in database creation
some problem in database creation [message #318846] Thu, 08 May 2008 03:47 Go to next message
mbhavin
Messages: 32
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is a blank line in your script.

Regards
Michel
Re: some problem in database creation [message #318868 is a reply to message #318853] Thu, 08 May 2008 05:21 Go to previous messageGo to next message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

i removed the blank line and again executed the same line

now i got this error

CREATE DATABASE CATDB
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


please guide me where i might have been mistaken
Re: some problem in database creation [message #318870 is a reply to message #318868] Thu, 08 May 2008 05:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Re: some problem in database creation [message #318873 is a reply to message #318870] Thu, 08 May 2008 05:38 Go to previous messageGo to next message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

yes before executing this lines i remove all the files like
redo01.log ...and also all the file from udump,cdump,bdump and exited from the sqlplus

and after that i executed and i got the above error
Re: some problem in database creation [message #319083 is a reply to message #318873] Fri, 09 May 2008 00:25 Go to previous message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

error solved sir

right from scratch i followed this step

1) created a pfile
2) created a database creation script(createdb.sql) as mentioned above
3) created a password file
4) placed all this file in the $ORACLE_HOME/dbs though it is not required for all the file
5) set my sid export ORACLE_SID=DBNAME
6) connected to idle instance with sys/s as sysdba
7) startup nomount
Cool create spfile from pfile
9) run the script @createdb.sql
10)add database information in tnsnames.ora $ORACLE_HOME/network/admin/tnsnames.ora
11)run @$ORACLE_HOME/rdbms/admin/catalog.sql
12)run @$ORACLE_HOME/rdbms/admin/catproc.sql

and all thing are done now i can connect to my database



Previous Topic: dbms_resource_manager
Next Topic: partition error
Goto Forum:
  


Current Time: Sun Dec 04 18:41:22 CST 2016

Total time taken to generate the page: 0.08395 seconds