| Unable to create an Oracle10g database [message #127221] |
Sun, 10 July 2005 05:21  |
dkimethu
Messages: 1
Registered: July 2005
Location: Columbus, Ohio, USA
|
Junior Member |
|
|
Unable to create an Oracle10g database from scripts why?
I am sourcing the environment thus:-
export ORACLE_SID=ALTODB - new database to create
export ORACLE_HOME=/u01/app/oracle/product/10.1.0/Db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin
Then from the same session and as oracle do following:-
sqlplus /nolog
connect /as sysdba
@altodb_cr.sql -- see this script below.
Errors stream on the screen as scripts is executed and no database is created.
---scripts below
[oracle@linuxcp16017 admin]$ more altodb_cr.sql
--execute as sysdba
create database ALTODB
user sys identified by @!sys#
user system identified by @!system#
logfile group 1 ('/u01/app/oracle/oradata/ALTODB/redo01.log') size 5om,
group 2 ('/u01/app/oracle/oradata/ALTODB/redo02.log') size 5om,
group 3 ('/u01/app/oracle/oradata/ALTODB/redo03.log') size 5om
maxlogfiles 5
maxloghistory 1
maxdatafiles 100
maxinstances 1
character set US7ASCII
nationa character set ALI6UTF16
datafile /u01/app/oracle/oradata/ALTODB/system01.dbf' size 256064k reuse
autoextend on maxsize unlimited;
extent management local
datafile /u01/app/oracle/oradata/ALTODB/sysaux01.dbf' size 256064k reuse
autoextend on next 10240k maxsize 2048m
extent management local
default tablespace temp_01
tempfile '/u01/app/oracle/oradata/ALTODB/temp01.dbf' size 20544k reuse
undo tablespace undo_ts1
datafile '/u01/app/oracle/oradata/ALTODB/undo_ts101.dbf'
size 20544k reuse autoextend on maxsize unlimited;
--
--build data dictionary views & scripts required for PL/SQL respectively
@/u01/app/oracle/product/10.1.0/Db_1/rdbms/admin/catalog.sql
@/u01/app/oracle/product/10.1.0/Db_1/rdbms/admin/catproc.sql
--
create tablespace users logging
datafile '/u01/app/oracle/oradata/ALTODB/users01.dbf'
size 10304k reuse autoextend on next 10240k maxsize 2048m
extent management local;
create tablespace altodata_01 logging
datafile '/u01/app/oracle/oradata/ALTODB/altodata_0101.dbf'
size 10304k reuse autoextend on next 10240k maxsize 2048m
extent management local;
create tablespace altoindx_01 logging
datafile '/u01/app/oracle/oradata/ALTODB/altoindx_0101.dbf'
size 10304k reuse autoextend on next 10240k maxsize 2048m
extent management local;
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
