10.1.0.3 SLES9+SP1 dbstart Error 01031 2005-05-20 - By Arun Singh
On Friday 20 May 2005 11:10, Magni Fabrizio wrote:
> > > 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.
or use Enterprise Manager to set this :-)
Thanks Fabrizio, I will rewrite this section.
Regards,
-Arun
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
