Home » Infrastructure » Linux » oracle 10gR2 skgaio.o missing
oracle 10gR2 skgaio.o missing [message #276985] Sat, 27 October 2007 12:21 Go to next message
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 Go to previous messageGo to next message
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
Re: oracle 10gR2 skgaio.o missing [message #277006 is a reply to message #276988] Sat, 27 October 2007 22:16 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: oracle 10gR2 skgaio.o missing [message #277008 is a reply to message #276985] Sat, 27 October 2007 22:35 Go to previous messageGo to next message
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.
Re: oracle 10gR2 skgaio.o missing [message #277010 is a reply to message #277008] Sat, 27 October 2007 22:56 Go to previous message
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
Previous Topic: how to shutdown and up database in oracle 9i
Next Topic: Database doesn't connect , SQLPlus doesn't start
Goto Forum:
  


Current Time: Fri Mar 29 09:19:31 CDT 2024