Re: Help - Oracle not available on running catproc.sql in 9i

I'm using 9.2 on WinXP-Pro-SVP1. This is what I have for memory config parameters in my ini.ora file:

## Memory configuration parameters
db_cache_size = 25M
shared_pool_size = 4M
pga_aggregate_target = 30M
db_cache_advice = ON
log_buffer = 51200

## Process and Session Parameters
processes = 100
open_cursors = 100

This is the tail of the alert_sid.log file and everything looks normal..

.....
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Mar 19 22:18:34 2004
SMON: enabling tx recovery
Fri Mar 19 22:18:38 2004
Database Characterset is US7ASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Fri Mar 19 22:24:15 2004
Thread 1 advanced to log sequence 13
  Current log# 1 seq# 13 mem# 0:
D:\ORACLE\ORA92\ORADATA\REMORSE\REDO01.LOG Fri Mar 19 22:26:03 2004
Thread 1 advanced to log sequence 14
  Current log# 2 seq# 14 mem# 0:
D:\ORACLE\ORA92\ORADATA\REMORSE\REDO02.LOG Fri Mar 19 22:28:02 2004
Thread 1 advanced to log sequence 15
  Current log# 1 seq# 15 mem# 0:
D:\ORACLE\ORA92\ORADATA\REMORSE\REDO01.LOG The catproc.sql output is like this as seen in sqlplus *
ERROR at line 1:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
SELECT :owa_file_name FROM DUAL*
ERROR at line 1:
ORA-03114: not connected to ORACLE

Any ideas what might be wrong here..??

thanks
Sunit

Enter value for owa_file_var:
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<405b874b$0$3957$afc38c87_at_news.optusnet.com.au>...
> "Sunit Joshi" <sjoshi_at_ingr.com> wrote in message
> news:8f8ffe67.0403191428.7a36dc5b_at_posting.google.com...
> > Hello All
> > I'm trying to create a new database on Oracle9.2. I ran the
> > catalog.sql and then tried to run the catproc.sql. It run fines for
> > about 20mins and then I get the message "Oracle not available"
> >
> > After this I have again connect to the instance, and start the run of
> > catproc.sql, but I get the same error after 20-25 mins...any help is
> > appreciated.
> >
> > thanks
> > Sunit
> > sunitjosh_at_netzero.net
>
> What's your operating system? And how much RAM do you have?
>
> If Linux or a Unix, did you set your kernel parameters?
>
> Regards
> HJR
Received on Fri Mar 19 2004 - 22:34:54 CST