Computing.Net > Forums > Linux > Oracle 9iR2 on RH9

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

Oracle 9iR2 on RH9

Reply to Message Icon

Name: Peter
Date: December 17, 2003 at 09:26:41 Pacific
OS: Linux
CPU/Ram: 500
Comment:

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.



Sponsored Link
Ads by Google

Response Number 1
Name: Guido
Date: December 17, 2003 at 11:06:00 Pacific
Reply:

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


0

Response Number 2
Name: Jeaf Sun
Date: December 18, 2003 at 00:01:41 Pacific
Reply:

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.sql

CREATE 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 exist

Procedure created.

drop procedure sys.subptxt
*
ERROR at line 1:
ORA-04043: object SUBPTXT does not exist

RA-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 exist

Synonym 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 exist

View 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 declared

Synonym 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 SYSTEM

CREATE 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;


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


install 3 ethernet cards ... Drivin me crazy with Linu...



Post Locked

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


Go to Linux Forum Home


Sponsored links

Ads by Google


Results for: Oracle 9iR2 on RH9

D-Link DFE-690TXD on RH9 wont work www.computing.net/answers/linux/dlink-dfe690txd-on-rh9-wont-work/25674.html

Oracle 8i on Linux www.computing.net/answers/linux/oracle-8i-on-linux/1812.html

Oracle Drivers on LINUX www.computing.net/answers/linux/oracle-drivers-on-linux/15767.html