Oracle Client 32bit and 64 bit in the same machine Linux
972546Feb 21 2013 — edited Feb 22 2013Dears,
I installed Oracle 64bit server in my Linux box. The 64 bit client is sure to be installed too. But for some reason, I need to install 32 bit client in the same machine and make that work well as the 64 bit client.
I downloaded the 32 bit package and installed it successfully with user ora32. Ran the root.sh to set up the env.... The user who installed the original oracle server is oracle.
For oracle user, I could connect to the server.
But for ora32 user, I failed to connect to the database with the following error.
----error
[ora32@fpru oracle]$ . /home/ora32/bin/oraenv
ORACLE_SID = [ora32] ?
The Oracle base for ORACLE_HOME=/u01/app/ora32/product/11.2.0/client_1 is /u01/app/ora32
[ora32@fpru oracle]$ sqlplus
SQL*Plus: Release *11.2.0.1.0* Production on Thu Feb 21 22:34:06 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: scott
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist
----error end
I have checked the env for user ora32 and it looks right.
[ora32@fpru oracle]$ echo $ORACLE_HOME
*/u01/app/ora32/product/11.2.0/client_1*
[ora32@fpru oracle]$ echo $ORACLE_SID
ora32
[ora32@fpru oracle]$ echo $PATH
/usr/local/bin:/bin:/usr/bin::/usr/lib/jvm/jre-1.6.0-ibm.x86_64/bin::/ibm/softwares/cognos/c10_64/bin64:/opt/ibm/c4eb/bin:/home/oracle/bin:/usr/kerberos/bin:*/u01/app/ora32/product/11.2.0/client_1/bin*
[ora32@fpru oracle]$ ll /home/ora
ora32/ oracle/
[ora32@fpru oracle]$ echo $LD_LIBRARY_PATH
*/u01/app/ora32/product/11.2.0/client_1/lib*
[ora32@fpru oracle]$ cat /u01/app/ora32/product/11.2.0/client_1/network/admin/tnsnames.ora
ora32 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fpru.spss.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.cn.ibm.com)
)
)
[ora32@fpru oracle]$ ping fpru.spss.com
PING fpru.spss.com (9.119.129.240) 56(84) bytes of data.
64 bytes from fpru.spss.com (9.119.129.240): icmp_seq=1 ttl=64 time=0.031 ms
But I could connect to db server using the following command, but i do not know what's the difference....
[ora32@fpru oracle]$ sqlplus scott/tiger@ora32
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 21 22:35:47 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-28002: the password will expire within 3 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
I modified the /etc/oratab to append this line : ora32:/u01/app/ora32/product/11.2.0/client_1:N
orcl:/u01/app/oracle/product/11.1.0/db_1:N --for user oracle
ora32:/u01/app/ora32/product/11.2.0/client_1:N--for user ora32