AIO causes sqlplus/As sysdba not to use 2008-04-23 not only: "AIO causes sqlplus/As sysdba to be unavailable"
I2 system maintained by the user
OS: AIX 5.3
ORACLE: 1, 10.2
Asked and checked the situation:
1. reinstalled the Operating System. Oracle software and data files are stored in another VG.
2. The environment variable is restored to the State before the system is reinstalled. oracle users and groups have been created (UID and GID are the same as the original), and the file permissions have not changed.
3. When sqlplus/As sysdba, an error is reported:
[Qasmdm1: Oracle]/Oracle/Home> sqlplus/As sysdba
SQL * Plus: Release 10.2.0.2.0-production on Wed Apr 23 10:34:49 2008
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Cocould not load program oracledevmdm:
Symbol resolution failed for/usr/lib/libc. A [aio_64.o] because:
Symbol kaio_rdwr64 (number 1) is not exported from dependent
Module/Unix.
Symbol listio64 (Number 2) is not exported from dependent
Module/Unix.
Symbol acancel64 (Number 3) is not exported from dependent
Module/Unix.
Symbol iosuspend64 (number 4) is not exported from dependent
Module/Unix.
Symbol aio_nwait (number 5) is not exported from dependent
Module/Unix.
Symbol aio_nwait64 (Number 6) is not exported from dependent
Module/Unix.
Symbol aio_nwait_timeout (Number 7) is not exported from dependent
Module/Unix.
Symbol aio_nwait_timeout64 (number 8) is not exported from dependent
Module/Unix.
System Error: error 0
Examine. loader section symbols with the 'dump-TV 'command.
Error:
ORA-12547: TNS: Lost contact
Metalink checked it and said it was a problem with Aio. Check the AIO
Pekax131:/dev> Smit AIO
Change/show characteristics of asynchronous I/O
Type or select values in entry fields.
Press enter after making all desired changes.
[Entry fields]
Minimum number of servers [1] #
Maximum number of servers per CPU [15] #
Maximum number of requests [1, 4096] #
Server priority [39] #
State to be configured at system restart defined +
State of fast path enable
If Automatic startup is not performed, perform the following operations to start AIO:
Pekax131:/> mkdev-l aio0
Aio0 available
In addition, Smit AIO modifies state to be configured at system restart to available.
There is no problem when I connect to and start the database with sqlplus.
[Qasmdm1: Oracle]/Oracle/Home> sqlplus/As sysdba
SQL * Plus: Release 10.2.0.2.0-production on Wed Apr 23 11:20:24 2008
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
After inquiry, I know the reason:
The user used mksysb (command Method for backing up the AIX operating system)
The problem was that mksysb was restored after the operating system problem occurred the night before, and AIO was not enabled after AIX was restored.
Normally, rootpre is executed before oracle is installed on Aix.