cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-12547: TNS lost contact

Former Member
0 Kudos

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...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Murali

How can i remove only the patch?

Thanks in advance

Answers (1)

Answers (1)

Former Member
0 Kudos

it is solved with OS level Asynchronous Input Output settings to active, some stack values to unlimited.