Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
running script
I tried to run the create database script
SQL> @/home/oracle/Desktop/newd
SQL>
It is not working any syntax errors....
CREATE DATABASE "newdata"
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/n
GROUP 2 '/u01/app/oracle/oradata/n
GROUP 3 '/u01/app/oracle/oradata/n
DATAFILE
'/u01/app/oracle/oradata/n
'/u01/app/oracle/oradata/n
sysaux datafile '/u01/app/oracle/oradata/n
undo tablespace undotbs
datafile '/u01/app/oracle/oradata/n
CHARACTER SET US7ASCII;
SQL> @/home/oracle/Desktop/newd
SQL>
It is not working any syntax errors....
CREATE DATABASE "newdata"
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/n
GROUP 2 '/u01/app/oracle/oradata/n
GROUP 3 '/u01/app/oracle/oradata/n
DATAFILE
'/u01/app/oracle/oradata/n
'/u01/app/oracle/oradata/n
sysaux datafile '/u01/app/oracle/oradata/n
undo tablespace undotbs
datafile '/u01/app/oracle/oradata/n
CHARACTER SET US7ASCII;
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
First, you should never use double quotes on Oracle object names.
Second, what are you trying to do with the user01.dbf file? I think there is an issue there based on the name of the file.
What are you seeing? Does the script actually run? Are the files created?
Second, what are you trying to do with the user01.dbf file? I think there is an issue there based on the name of the file.
What are you seeing? Does the script actually run? Are the files created?
what error are you getting ?
your datafile and tablespace looks wrong
you are trying to create a users tablespace
after the first datafile word, only create the system tablespace
http://docs.oracle.com/cd/E11882_01/server.112/e17118/statements_5004.htm#i2142339
you don't need a users tablespace created in the beginning
create it after that script has run
you don't have a temp tablespace ...
your datafile and tablespace looks wrong
you are trying to create a users tablespace
after the first datafile word, only create the system tablespace
http://docs.oracle.com/cd/E11882_01/server.112/e17118/statements_5004.htm#i2142339
you don't need a users tablespace created in the beginning
create it after that script has run
you don't have a temp tablespace ...
CREATE DATABASE "newdata"
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/newdata/redo1.log' SIZE 10M,
GROUP 2 '/u01/app/oracle/oradata/newdata/redo2.log' SIZE 10M,
GROUP 3 '/u01/app/oracle/oradata/newdata/redo3.log' SIZE 10M
DATAFILE
'/u01/app/oracle/oradata/newdata/system01.dbf' size 100m
sysaux datafile '/u01/app/oracle/oradata/newdata/sysaux01.dbf' size 100m
undo tablespace undotbs
datafile '/u01/app/oracle/oradata/newdata/undotbs01.dbf' size 50m
CHARACTER SET US7ASCII;
The error now is
SQL> @/home/oracle/Desktop/newd
CREATE DATABASE "newdata"
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Process ID: 4622
Session ID: 1 Serial number: 3
SQL>
SQL> @/home/oracle/Desktop/newd
CREATE DATABASE "newdata"
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Process ID: 4622
Session ID: 1 Serial number: 3
SQL>
>>ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Check the pfile/spfile you created. Your script uses UNDOTBS. Looks like the init parameters isn't.
Check the pfile/spfile you created. Your script uses UNDOTBS. Looks like the init parameters isn't.
try this
CREATE DATABASE "newdata"
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/newdata/redo1.log' SIZE 10M,
GROUP 2 '/u01/app/oracle/oradata/newdata/redo2.log' SIZE 10M,
GROUP 3 '/u01/app/oracle/oradata/newdata/redo3.log' SIZE 10M
DATAFILE '/u01/app/oracle/oradata/newdata/system01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/newdata/sysaux01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/newdata/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/oradata/newdata/undotbs01.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET US7ASCII;
Here is the initnewdata.ora
newdata.__db_cache_size=41
newdata.__java_pool_size=4
newdata.__large_pool_size=
newdata.__oracle_base='/u0
newdata.__pga_aggregate_ta
newdata.__sga_target=10234
newdata.__shared_io_pool_s
newdata.__shared_pool_size
newdata.__streams_pool_siz
*.audit_file_dest='/u01/ap
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/
*.db_block_size=8192
*.db_cache_size=4194304
*.db_domain=''
*.db_name='newdata'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/u01/ap
*.dispatchers='(PROTOCOL=T
*.java_pool_size=4194304
*.open_cursors=300
*.processes=150
*.remote_login_passwordfil
*.shared_pool_size=7130316
*.undo_tablespace='UNDOTBS
*.utl_file_dir='/usr/tmp'
This is the new error
SQL> startup nomount
ORACLE instance started.
Total System Global Area 83697664 bytes
Fixed Size 1334660 bytes
Variable Size 75498108 bytes
Database Buffers 4194304 bytes
Redo Buffers 2670592 bytes
SQL> @/home/oracle/Desktop/newd
CREATE DATABASE "newdata"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file:
'/u01/app/oracle/flash_rec
ORA-27038: created file already exists
Additional information: 1
SQL>
newdata.__db_cache_size=41
newdata.__java_pool_size=4
newdata.__large_pool_size=
newdata.__oracle_base='/u0
newdata.__pga_aggregate_ta
newdata.__sga_target=10234
newdata.__shared_io_pool_s
newdata.__shared_pool_size
newdata.__streams_pool_siz
*.audit_file_dest='/u01/ap
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/
*.db_block_size=8192
*.db_cache_size=4194304
*.db_domain=''
*.db_name='newdata'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/u01/ap
*.dispatchers='(PROTOCOL=T
*.java_pool_size=4194304
*.open_cursors=300
*.processes=150
*.remote_login_passwordfil
*.shared_pool_size=7130316
*.undo_tablespace='UNDOTBS
*.utl_file_dir='/usr/tmp'
This is the new error
SQL> startup nomount
ORACLE instance started.
Total System Global Area 83697664 bytes
Fixed Size 1334660 bytes
Variable Size 75498108 bytes
Database Buffers 4194304 bytes
Redo Buffers 2670592 bytes
SQL> @/home/oracle/Desktop/newd
CREATE DATABASE "newdata"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file:
'/u01/app/oracle/flash_rec
ORA-27038: created file already exists
Additional information: 1
SQL>
look at comment again from slightvw: ID: 38736345
from your init:
*.undo_tablespace='UNDOTBS1'
from your create database script:
undo tablespace undotbs
datafile '/u01/app/oracle/oradata/n
the names of the undo tablespace are different
from your init:
*.undo_tablespace='UNDOTBS1'
from your create database script:
undo tablespace undotbs
datafile '/u01/app/oracle/oradata/n
the names of the undo tablespace are different
looks like when you first ran your script, the installation errored out but some files were created, that's why you get an erro "file already exists" when you ran the installation again
You can also specify REUSE for the controlfiles. This will overwrite the file if it exists.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/control003.htm#ADMIN11287
If files with the specified names currently exist at the time of database creation, you must specify the CONTROLFILE REUSE clause in the CREATE DATABASE statement, or else an error occurs. Also, if the size of the old control file differs from the SIZE parameter of the new one, you cannot use the REUSE clause.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/control003.htm#ADMIN11287
If files with the specified names currently exist at the time of database creation, you must specify the CONTROLFILE REUSE clause in the CREATE DATABASE statement, or else an error occurs. Also, if the size of the old control file differs from the SIZE parameter of the new one, you cannot use the REUSE clause.
walkerdba,
Can I ask why my post wasn't accepted since it was referenced/repeated in the post you accepted?
I pointed this out in my post: http:#a38736345
Can I ask why my post wasn't accepted since it was referenced/repeated in the post you accepted?
I pointed this out in my post: http:#a38736345
Premium Content
You need an Expert Office subscription to comment.Start Free Trial