10.1.0.3 SLES9+SP1 dbstart Error 01031 2005-05-20 - By Magni Fabrizio
> > How can I "relink oracle for Async IO" ?
> You can find plenty of information on this by looking old
> threads.You can
> enable async i/o by doing ( Documented in :
> http://ftp.novell.com/partners/oracle/docs/10gR1_sles9_install.pdf):
>
> 1. cd $ORACLE_HOME/rdbms/lib
> make -f ins_rdbms.mk async_on
> make -f ins_rdbms.mk ioracle
>
There is an aio bug for 10g. Safer to go with:
cd $ORACLE_HOME/rdbms/lib
make PL_ORALIBS=-laio -f ins_rdbms.mk async_on
make PL_ORALIBS=-laio -f ins_rdbms.mk ioracle
> 2. Add "filesystemio_options=asynch" to
> $ORACLE_BASE/admin/<your_SID>/pfile
>
$ORACLE_BASE/admin/<your_SID>/pfile
it is usually used only for database creation.
The default pfile should be in $ORACLE_HOME/dbs.
However from 9i (so it is true even for 10g) the database use an spfile.
So you need to issue:
alter system set filesystemio_options=asynch scope=spfile;
and then restart the instance.
> > will differ
> > 2.4.18 Alexei
> > 2.4.21 Arun
> Both will do the job. Actually, you can live without that in
> 10g (except few
> apps). However, 2.4.21 is Oracle documented for 9iR2.
>
Much better to have LD_ASSUME_KERNEL unset for 10g components.
Regards
Fabrizio
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
