OraFAQ Forum: Linux » oracle 10gR2 skgaio.o missing

Home » Infrastructure » Linux » oracle 10gR2 skgaio.o missing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle 10gR2 skgaio.o missing [message #276985]

Sat, 27 October 2007 12:21

el33t
Messages: 29
Registered: October 2007

Junior Member

Hello,

I have Oracle 10GR2 and RHEL4.

I ran this command:

make -f ins_rdbms.mk async_on

and got this error

rm -f /opt/app/oracle/db/rdbms/lib/skgaioi.o
cp /opt/app/oracle/db/rdbms/lib/skgaio.o /opt/app/oracle/db/rdbms/lib/skgaioi.o
cp: cannot stat `/opt/app/oracle/db/rdbms/lib/skgaio.o': No such file or directory
make: *** [do_async_on] Error 1

and stupid me ran this twice Shocked

(stress maybe)

make -f ins_rdbms.mk async_off

and it disabled asynch in the oracle binary and also lost the backup "Oracle0" binary Shocked

While searching on google I realized that Oracle 10GR2 has aio enabled by default Shocked

Please help me how can I rebuild the oracle binary with asyncio?

Thank You.

[Updated on: Sat, 27 October 2007 12:22]

Report message to a moderator

Re: oracle 10gR2 skgaio.o missing [message #276988 is a reply to message #276985]

Sat, 27 October 2007 12:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The following is like giving chicken soup to a dead man.
It can't hurt, & just might help.
In ORACLE_HOME/bin should be a utility called "relink".
invoke it & see what happens

Report message to a moderator

Re: oracle 10gR2 skgaio.o missing [message #277006 is a reply to message #276988]

Sat, 27 October 2007 22:16

el33t
Messages: 29
Registered: October 2007

Junior Member

alas i'm vegeterian Sad

I did relink oracle but it did the same thing as make -f ins_rdbms.mk async_off it seems.

I have another database server on linux which is fine and comparing the oracle binary it is 90 MB on normal server and 82MB on my screwed testbed server.

Btw is this normal message in alertlog?

replication_dependency_tracking turned off (no async multimaster replication found)

How do i make sure async is working?

I did make sure:

ldd oracle | grep libaio
libaio.so.1 => /usr/lib/libaio.so.1 (0x00427000)

Thank You.

[Updated on: Sat, 27 October 2007 22:17]

Report message to a moderator

Re: oracle 10gR2 skgaio.o missing [message #277007 is a reply to message #276985]

Sat, 27 October 2007 22:27

el33t
Messages: 29
Registered: October 2007

Junior Member

and this dead man also tried copying oracle binary from normal server and it fails to open the database so it is compiled unique for a given machine it seems.

Report message to a moderator

Re: oracle 10gR2 skgaio.o missing [message #277008 is a reply to message #276985]

Sat, 27 October 2007 22:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I don't think I can help much more on this issue.

ldd oracle | grep libaio
libaio.so.1 => /usr/lib64/libaio.so.1 (0x000000397e400000)

grep replication /prime/oracle/product/admin/comdb01/bdump/a*log
replication_dependency_tracking turned off (no async multimaster replication found)
replication_dependency_tracking turned off (no async multimaster replication found)
replication_dependency_tracking turned off (no async multimaster replication found)
replication_dependency_tracking turned off (no async multimaster replication found)

Above are cut & pasted from Production server
No offense intended to others here but many Oracle authors
monitor & respond on the ORACLE-L email list.

http://www.freelists.org/list/oracle-l

You might even be able to find an answer in the ORACLE-L archives
It is late Saturday night for me & I've had a loooooong week.

If/when you find an answer, please post back here so others (like me) can benefit.

Report message to a moderator

Re: oracle 10gR2 skgaio.o missing [message #277010 is a reply to message #277008]

Sat, 27 October 2007 22:56

el33t
Messages: 29
Registered: October 2007

Junior Member

hi anacedent..you have been very helpful man. No problem I will do some more searching on this and definitely update this post if i find something.

Thanks a ton Smile

Report message to a moderator

Previous Topic:	how to shutdown and up database in oracle 9i
Next Topic:	Database doesn't connect , SQLPlus doesn't start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 04:13:43 CST 2025