on 03-04-2008 3:57 PM
Dear Gurus,
I am installing BI on Netweaver 2004s oracle,AIX. I have installed oracle and pataches. Just before end of the patch installation, system prompted me to log in as root and execute /oracle/SID/102_64/root.sh.. After executing, system prompted me "Enter the full path name of the local bin directory[usr/local/bin]:" unfortunately here i have entered '.y'.
So, then i have re executed the above script and mentioned nothing, then it was prompted as
The file dbhome already exists in usr/local/bin. Over write [y/n]
copying dbhome to /usr/local/bin......
The file oraenv already exists in usr/local/bin. Over write [y/n] :(i entered 'y')
copying oraenv to /usr/local/bin......
The file coraenv already exists in usr/local/bin. Over write [y/n] :(i entered 'y')
copying coraenv to /usr/local/bin......
Then it finishes well for oracle patch installation...
But while "CREATE DATABASE" phase(13/47).
it thrown an error:
the log is:
================================================================================
2008-03-04, 19:34:00 SAPINST ORACLE start logging for
STARTUP NOMOUNT;
exit;
Output of SQL executing program:
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Mar 4 19:34:01 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
exec(): 0509-036 Cannot load program oracleQBW because of the following errors:
0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
0509-136 Symbol kaio_rdwr64 (number 1) is not exported from
dependent module /unix.
0509-136 Symbol listio64 (number 2) is not exported from
dependent module /unix.
0509-136 Symbol acancel64 (number 3) is not exported from
dependent module /unix.
0509-136 Symbol iosuspend64 (number 4) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait (number 5) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait64 (number 6) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait_timeout (number 7) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait_timeout64 (number 😎 is not exported from
dependent module /unix.
0509-026 System error: Error 0
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
ERROR:
ORA-12547: TNS:lost contact
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
SAPINST: End of output of SQL executing program /oracle/QBW/102_64/bin/sqlplus.
SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.
2008-03-04, 19:34:01 SAPINST ORACLE stop logging
bwhqat:/tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS>cat sapinst_ora_environment.log
2008-03-04, 19:34:01 SAPINST Current process environment:
=/tmp/sapinstexe.454706.1204619394/sapinstexe
SAPINST_EXE_DIR=/tmp/sapinst_exe.454706.1204619394
MANPATH=/usr/dt/man:/usr/share/man
DTDATABASESEARCHPATH=//.dt/types,/etc/dt/appconfig/types/%L,/etc/dt/appconfig/types/C,/usr/dt/appconfig/t
ypes/%L,/usr/dt/appconfig/types/C
SESSIONTYPE=dt
LANG=en_US
LOGIN=root
PATH=.:/home/qbwadm:/usr/sap/QBW/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/dt/bin:/usr/bin/X11:/s
bin:/usr/java14_64/jre/bin:/usr/java14_64/bin
SAPINST_EXEDIR_CD=/dumps/Inst_Master/IM_AIX_PPC64/.
DTUSERSESSION=root-10.3.50.15-1...............................................
And when i connecting the oracle ORA<SID>
this is the log:
bwhqat:oraqbw 2> sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Mar 4 22:01:53 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> connect /as sysdba
exec(): 0509-036 Cannot load program oracleQBW because of the following errors:
0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
0509-136 Symbol kaio_rdwr64 (number 1) is not exported from
dependent module /unix.
0509-136 Symbol listio64 (number 2) is not exported from
dependent module /unix.
0509-136 Symbol acancel64 (number 3) is not exported from
dependent module /unix.
0509-136 Symbol iosuspend64 (number 4) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait (number 5) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait64 (number 6) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait_timeout (number 7) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait_timeout64 (number 😎 is not exported from
dependent module /unix.
0509-026 System error: Error 0
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
ERROR:
ORA-12547: TNS:lost contact
SQL>
Please help me
Thanks in advance...
Balaji,
I haven't had this issue so I am just guessing here. Can you may be take out the patch and then install the patch again (this time with right path)?
thanks
BMG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it is solved with OS level Asynchronous Input Output settings to active, some stack values to unlimited.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.