Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
I was able to install Oracle 9iR2 on RH9, however I have not been able to create a database. If anyone knows how to do this I would appriciate any advice.

There are "HOWTO's" available for Oracle at www.tldp.org; maybe there's something in it you could use.

CREATE DATABASE ora9i
USER SYS IDENTIFIED BY ora9i
USER SYSTEM IDENTIFIED BY ora9i
LOGFILE GROUP 1
('/export/oracle/oradata/ora9i/redo01a.log','/export/oracle/oradata/ora9i/redo01b.log')
SIZE 5M,
GROUP 2
('/export/oracle/oradata/ora9i/redo02a.log','/export/oracle/oradata/ora9i/redo02b.log')
SIZE 5M,
GROUP 3
('/export/oracle/oradata/ora9i/redo03a.log','/export/oracle/oradata/ora9i/redo03b.log')
SIZE 5M
MAXLOGFILES 126
MAXLOGHISTORY 10
MAXDATAFILES 1024
MAXINSTANCES 63
DATAFILE '/export/oracle/oradata/ora9i/system01.dbf' SIZE 500M
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/export/oracle/oradata/ora9i/temp01.dbf'
SIZE 500M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/export/oracle/oradata/ora9i/undo01.dbf'
SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;CREATE TABLESPACE users LOGGING
DATAFILE '/export/oracle/oradata/ora9i/users01.dbf'
SIZE 50M
EXTENT MANAGEMENT LOCAL;CREATE TABLESPACE tools LOGGING
DATAFILE '/export/oracle/oradata/ora9i/tools01.dbf'
SIZE 50M
EXTENT MANAGEMENT LOCAL;@/export/oracle/product/9.2.0.1/rdbms/admin/catalog.sql
@/export/oracle/product/9.2.0.1/rdbms/admin/catproc.sqlCREATE TABLESPACE ora9i
DATAFILE '/export/oracle/oradata/ora9i/ora9i01.dbf'
SIZE 100M;create user jeaf identified by jeaf
default tablespace ora9i
TEMPORARY TABLESPACE temp;create table tt(
a number,
b varchar2(20),
c blob
);insert into tt(a,b) values(2,'Jeaf Sun');
select a,b from tt;
rop procedure sys.subptxt2
*
ERROR at line 1:
ORA-04043: object SUBPTXT2 does not existProcedure created.
drop procedure sys.subptxt
*
ERROR at line 1:
ORA-04043: object SUBPTXT does not existRA-04043: object AQ$_JMS_HEADER does not exist
drop type aq$_jms_userproparray
*
ERROR at line 1:
ORA-04043: object AQ$_JMS_USERPROPARRAY does not exist
drop type aq$_jms_userproperty
*
ERROR at line 1:
ORA-04043: object AQ$_JMS_USERPROPERTY does not existSynonym created.
Grant succeeded.
Package body created.
Package created.
Synonym created.
Grant succeeded.
rant succeeded.
DROP SYNONYM def$_tran
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
DROP SYNONYM def$_call
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
DROP SYNONYM def$_defaultdest
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not existView created.
grant select on ku$_nt_parent_view to select_catalog_role
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 2196 bytes of shared memory ("shared
pool","OBJAUTH$SYS","KGLS heap","KGLS MEM BLOCK")grant select on ku$_fhtable_view to public
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 620 bytes of shared memory ("shared pool","select
ts#,file#,block#,nvl(...","Typecheck heap","qknAllocate : qkn")ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.SOURCE$ by 512 in tablespace SYSTEM
Errors for FUNCTION OLAP_TABLE:LINE/COL ERROR
----------------
0/0 PL/SQL: Compilation unit analysis terminated
6/17 PLS-00201: identifier 'OLAPIMPL_T' must be declaredSynonym created.
Grant succeeded.CREATE TYPE system.repcat$_object_null_vector AS OBJECT
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_OBJ# by 512 in tablespace SYSTEMCREATE TABLESPACE users LOGGING
DATAFILE '/export/oracle/oradata/ora9i/users01.dbf'
SIZE 100M
EXTENT MANAGEMENT LOCAL;CREATE TABLESPACE tools LOGGING
DATAFILE '/export/oracle/oradata/ora9i/tools01.dbf'
SIZE 100M
EXTENT MANAGEMENT LOCAL;CREATE TABLESPACE ora9i
DATAFILE '/export/oracle/oradata/ora9i/ora9i01.dbf'
SIZE 500M;create user jeaf identified by jeaf
default tablespace ora9i
TEMPORARY TABLESPACE temp;
grant connect,resource to jeaf;

![]() |
install 3 ethernet cards ...
|
Drivin me crazy with Linu...
|

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |