| View previous topic :: View next topic |
| Author |
Message |
beacher
n00b
Joined: 11 Mar 2003
Posts: 30
Location: Atlanta
|
 Posted: Mon Oct 10, 2005 2:46 am Post subject: Oracle 10G R2 - ORA-12547: TNS:lost contact |
 |
|
Not having fun here....
Been using The Gentoo / Oracle to install 10G on other machines previous to 10G R2. I should have noticed that there were significant changes when I couldn't find ship.db.cpio.gz .... It's 10201_database_linux32.zip now...
Anyways.. went through the install and got an error when it was trying to build something (wish I hadn't delete it )... and got a notice that I oracle was looking for libstdc++ .. performed
| Code: | | ln -s /usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.5-20050130/libstdc++.so.5 /usr/lib/libstdc++.so.5 |
rm -rf'd my oracle home and tried again.... (by the way WBC is my SID)
Used dbca and exported the scripts so I could see the detailed error message.....
| Code: | cassandra@cassandra /opt/oracle/10g/admin/WBC/scripts $ ./WBC.sh
You should Add this entry in the /etc/oratab: WBC:/opt/oracle/10g:Y
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Oct 9 15:42:40 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
specify a password for sys as parameter 1
Enter value for 1: <deleted>
specify a password for system as parameter 2
Enter value for 2: <deleted>
oracleWBC: relocation error: oracleWBC: symbol io_queue_init, version LIBAIO_0.1 not defined in file libaio.so.1 with link time reference
ERROR:
ORA-12547: TNS:lost contact
SQL> spool /opt/oracle/10g/admin/WBC/scripts/CloneRmanRestore.log
SQL> startup nomount pfile="/opt/oracle/10g/admin/WBC/scripts/init.ora";
oracleWBC: relocation error: oracleWBC: symbol io_queue_init, version LIBAIO_0.1 not defined in file libaio.so.1 with link time reference
oracleWBC: relocation error: oracleWBC: symbol io_queue_init, version LIBAIO_0.1 not defined in file libaio.so.1 with link time reference
ORA-12547: TNS:lost contact
SQL> @/opt/oracle/10g/admin/WBC/scripts/rmanRestoreDatafiles.sql;
SQL> set echo off;
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
oracleWBC: relocation error: oracleWBC: symbol io_queue_init, version LIBAIO_0.1 not defined in file libaio.so.1 with link time reference
ERROR:
ORA-12547: TNS:lost contact
SQL> spool /opt/oracle/10g/admin/WBC/scripts/cloneDBCreation.log
SQL> Create controlfile reuse set database "WBC"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 16
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 Datafile
8 '/opt/oracle/oradata/WBC/system01.dbf',
9 '/opt/oracle/oradata/WBC/undotbs01.dbf',
10 '/opt/oracle/oradata/WBC/sysaux01.dbf',
11 '/opt/oracle/oradata/WBC/users01.dbf'
12 LOGFILE GROUP 1 ('/opt/oracle/oradata/WBC/redo01.log') SIZE 51200K,
13 GROUP 2 ('/opt/oracle/oradata/WBC/redo02.log') SIZE 51200K,
14 GROUP 3 ('/opt/oracle/oradata/WBC/redo03.log') SIZE 51200K RESETLOGS;
SP2-0640: Not connected
|
Googled the error ( oracleWBC: relocation error: oracleWBC: symbol io_queue_init, version LIBAIO_0.1 not defined in file libaio.so.1 with link time reference ) and found only 1 webpage and it has no answer.
I'm not using ASM, I'm doing a very vanilla install. I'm a DBA by trade with almost a petabyte across 30 windows servers. I want to run a windows instance against a gentoo instance with the exact configuration (memory, file->hd locations, hardware, platform EXACT) to perform a cost/performance analysis so I can get windows out of our datacenter. (by the way the Oracle on windows/Oracle on linux study is MIA on the internet. You'll find links abound but the original is missing)
I'll probably wind up going back to 10g R1 to perform this analysis, but I'll have to move to R2 which means that I eventually will wind up with this problem. I'm pissed off that I had to lose a 4 day data run when we had to perform emergency reboots last month for patches.
Thanks in advance,
B |
|
| Back to top |
|
 |
tranquilcool
Veteran
Joined: 25 Mar 2005
Posts: 1179
|
| Posted: Thu Oct 13, 2005 9:46 pm Post subject: |
|
|
i think it's a libaio version proplem. at least this is how i solved a similar problem;
cd ~/
-wget "ftp://ftp.suse.com/pub/suse/i386/9.1/suse/src/libaio-0.3.102.src.rpm
-rpm2targz libaio-0.3.102.src.rpm
-tar zxf libaio-0.3.102.src.tar.gz
-tar jxf libaio-0.3.102.tar.bz2
-cd libaio-0.3.102
-make
-make install
hope this helps.
_________________
this is a strange strange world. |
|
| Back to top |
|
|
omars
n00b
Joined: 08 Nov 2005
Posts: 1
|
| Posted: Tue Nov 08, 2005 7:51 pm Post subject: |
|
|
Hi
Thanks that works fine, i just reinstalled that lib nad now its working
emerge libaio
Solved
_________________
s~~tf(\"%c\",^%72%61%6D%4F^prin~;m!\^(.*)\^!;$_=$+;y%\^%%d;$p="$'$`";s#%#$"#g;map
{s/.+/"$p hex(\"$_\")\)"/ee ;}reverse split/$"/ |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Unsupported Software
