help me to start the Oracle 9i

shaoping

#./ora9
LRM-00109: could not open parameter file '/opt/ora9/product/9.2/dbs/initora9i.ora' <------
SQL>; Disconnected
[root@localhost init.d]#

then i use

su -oralce

then,

SQL>; startup pfile=/opt/ora9/product/9.2/dbs/initbvst.ora <---
LRM-00109: could not open parameter file '/opt/ora9/product/9.2/dbs/initbvst.ora'
ORA-01078: failure in processing system parameters

but .... this is ok

SQL>; startup pfile=/opt/ora9/product/9.2/dbs/init.ora <---
ORACLE instance started.

Total System Global Area 42741800 bytes
Fixed Size 450600 bytes
Variable Size 41943040 bytes
Database Buffers 204800 bytes
Redo Buffers 143360 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

shaoping

http://www.linuxsir.org/bbs/showthread.php?s=&postid=396842#post396842

shaoping

ding xia la ...

zhaosi

用google查找一下ORA-01078错误号，看看解决办法。

ktan

There are three main problems and its solution
for installing ora9i under linux.

1>; Modify kernel parameter permanently
   HOW-TO:
     Modify file /etc/sysctl.conf by adding/modifing followed rows:
       kernel.sem = 250 32000 128 128
       kernel.shmmax = 335544320
       kernel.shmmni = 4096
       kernel.shmall = 2097152
       net.ipv4.ip_local_port_range = 1024 65535
     then reboot the system.

2>; When Oracle is installing, ins_ctx error message come out.
   WHY:  
     $ORACLE_HOME/ctx/lib/ins_ctx.mk does not include '-ldl' option.
   HOW-TO:
     Modify the 'ins_ctx.mk'
     from ctxhx: $(CTXHXOBJ) $(LINK) $(CTXHXOBJ) $(INSO_LINK)
     to ctxhx: $(CTXHXOBJ) $(LINK) -ldl $(CTXHXOBJ) $(INSO_LINK)
     then click Retry.

3>; When message "Can't find init file for Database <SID>;" come out for
   starting up the oracle server by dbstart command.
   HOW-TO:
     copy file $ORACLE_BASE/admin/$ORACLE_SID/pfile/init$ORACLE_SID.ora.<A_DIGIT_STRING>;
     to $ORACLE_HOME/dbs/init$ORACLE_SID.ora
     then run dbstart again.

shaoping

Thank u anybody for help me. Thank u your guys so much. I don't know how to say
how much i thank u your guys.

Anyway, i just fixed my Oricle 9i.

SQL>; startup
ORACLE instance started.

Total System Global Area  235999352 bytes
Fixed Size                   450680 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
    

shaoping

By the way,  after i installed the Oracle 9i, i didn't know what i could to do with Oracle!  What  can I do with Oracle?