Connecting to 64bit Oracle 11g  from 32bit Client on Windows 7 64bit OS.

November 30 1
Advertisement
Hi All,
We have installed Oracle 11g 64 bit on a Windows 7 64 bit system. As we need to run some 32 bit application on the system, We installed 32 bit client and try to configured Local Net Service Name Configuration using Oracle Net Configuration Assistant and during test, it is unable to connect and giving the following error.
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Best Regards
Fred
Advertisement
user13144834 wrote:
Hi All,
We have installed Oracle 11g 64 bit on a Windows 7 64 bit system. As we need to run some 32 bit application on the system, We installed 32 bit client and try to configured Local Net Service Name Configuration using Oracle Net Configuration Assistant and during test, it is unable to connect and giving the following error.
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Best Regards
Fred=================================
A couple of important points.
First, the listener is a server side only process. It's entire purpose in life is to receive requests for connections to databases and set up those connections. Once the connection is established, the listener is out of the picture. It creates the connection. It doesn't sustain the connection. One listener, with the default name of LISTENER, running from one oracle home, listening on a single port, will serve multiple database instances of multiple versions running from multiple homes. It is an unnecessary complexity to try to have multiple listeners or to name the listener as if it belongs to a particular database. That would be like the telephone company building a separate switchboard for each customer.
Additional notes on the listener: One listener is capable of listening on multiple ports. But please notice that it is the listener using these ports, not the database instance. You can't bind a specific listener port to a specific db instance. Similarly, one listener is capable of listnening on multiple IP addresses (in the case of a server with multiple NICs) But just like the port, you can't bind a specific ip address to a specific db instance.
Second, the tnsnames.ora file is a client side issue. It's purpose is for address resolution - the tns equivalent of the 'hosts' file further down the network stack. The only reason it exists on a host machine is because that machine can also run client processes.
Assume you have the following in your tnsnames.ora:
larry =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = curley)
  )Now, when you issue a connect, say like this:
$> sqlplus scott/[email protected] will look in your tnsnames.ora for an entry called 'larry'. Next, tns sends a request to (PORT = 1521) on (HOST = myhost) using (PROTOCOL = TCP), asking for a connection to (SERVICE_NAME = curley).
Where is (HOST = myhost) on the network? When the request gets passed from tns to the next layer in the network stack, the name 'myhost' will get resolved to an IP address, either via a local 'hosts' file, via DNS, or possibly other less used mechanisms. You can also hard-code the ip address (HOST = 123.456.789.101) in the tnsnames.ora.
Next, the request arrives at port 1521 on myhost. Hopefully, there is a listener on myhost configured to listen on port 1521, and that listener knows about SERVICE_NAME = curley. If so, you'll be connected.
What can go wrong?
First, there may not be an entry for 'larry' in your tnsnames. In that case you get "ORA-12154: TNS:could not resolve the connect identifier specified" No need to go looking for a problem on the host, with the listener, etc. If you can't place a telephone call because you don't know the number (can't find your telephone directory (tnsnames.ora) or can't find the party you are looking for listed in it (no entry for larry)) you don't look for problems at the telephone switchboard.
Maybe the entry for larry was found, but myhost couldn't be resolved to an IP address (say there was no entry for myhost in the local hosts file). This will result in "ORA-12545: Connect failed because target host or object does not exist"
Maybe there was an entry for myserver in the local hosts file, but it specified a bad IP address. This will result in "ORA-12545: Connect failed because target host or object does not exist"
Maybe the IP was good, but there is no listener running: "ORA-12541: TNS:no listener"
Maybe the IP was good, there is a listener at myhost, but it is listening on a different port. "ORA-12560: TNS:protocol adapter error"
Maybe the IP was good, there is a listener at myhost, it is listening on the specified port, but doesn't know about SERVICE_NAME = curley. "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
Third: If the client is on the same machine as the db instance, it is possible to connect without referencing tnsnames and without going through the listener.
Now, when you issue a connect, say like this:
$> sqlplus scott/tigertns will attempt to establish an IPC connection to the db instance. How does it know the name of the instance? It uses the current value of the enviornment variable ORACLE_SID. So...
$> export ORACLE_SID=fred
$> sqlplus scott/tigerIt will attempt to connect to the instance known as "fred". If there is no such instance, it will, of course, fail. Also, if there is no value set for ORACLE_SID, the connect will fail.
check executing instances to get the SID
[[email protected] ~]$ ps -ef|rgrep pmon
oracle    4236     1  0 10:30 ?        00:00:00 ora_pmon_vlnxora1
oracle    4878  4854  0 10:42 pts/0    00:00:00 grep pmonset ORACLE_SID appropriately, and connect
[[email protected] ~]$ export ORACLE_SID='vlnxora1
[[email protected] ~]$ sqlplus scott/tiger
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 22 10:42:37 2010
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsNow set ORACLE_SID to a bogus value, and try to connect
SQL> exit
[[email protected] ~]$ export ORACLE_SID=FUBAR
[[email protected] ~]$ SQLPsqlplus scott/tigere
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 22 10:42:57 2010
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Enter user-name: Now set ORACLE_SID to null, and try to connect
[[email protected] ~]$ export ORACLE_SID=
[[email protected] ~]$ SQLsqlplus /scott/tiger
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 22 10:43:24 2010
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
ERROR:
ORA-12162: TNS:net service name is incorrectly specified=====================================
Connecting to 64bit Oracle 11g  from 32bit Client on Windows 7 64bit OS.

Hi All, We have installed Oracle 11g 64 bit on a Windows 7 64 bit system. As we need to run some 32 bit application on the system, We installed 32 bit client and try to configured Local Net Service Name Configuration using Oracle Net Configuration As

Installation of Oracle 11g 32 bit Client on Windows 7 (32 bit) laptop.

Hi, I just got a new Laptop with Windows 7 (32 bit) operating system. Has any one successfully installed Oracle 11g client on in Windows 7 environment and if so what are the steps involved. In the past I have never had any trouble installing an Oracl

Cannot Install 11g 64 bit client on Windows 7 Professional 64 bit OS

I am trying to install Oracle 11g 64 bit client on Windows 7 64 Bit Professional. I'm running setup as administrator and all prerequisites fail with Actual Value not Found Expected value not found. I select ignore and press next and the application j

Oracle 11g or higher client is not installed or not set to Primary Oracle..

Hi all, I have installed oracle 11g client on my machine. It connecting fine with the server throuhg sqlplus but when i connect my application that is developed in power builder, it prompts an errror message stated 'Oracle 11g or higher client is not

Install Oracle 11.2.0.3 32Bit Client on Window 7 x64

Good morning, I just tried to install the new Oracle 11.2.0.3 32Bit Client on Windows 7 x64, most of it works - just the OLEDB drivers are not registered ... does anyone know how to register them manually ? the 11.2.0.2 Client works fine .... And ple

Install oracle 11g r2 on client

HI Folks, please specify a good link to install oracle 11g r2 on client machine on windows xp and also steps how to install Thanks in advance Edited by: newbie on Feb 14, 2011 9:20 PMThe correct place for such question is {forum:id=64}Read other 2 an

Steps to UnInstall Oracle 11g 32 bit Client

Hi , I want to Uninstall the Oracle 11g 32 bit client from my server. Please provide the step by step instruction in order to uninstall the oracle 11g 32 bit client completely. Thanks SambitPl post exact OS details and exact 11g version. Uninstall st

Connect to 10g oracle server from 9i client

Hi All, Is it possible to connect to 10g oracle server from 9i client or Should i install 10g client on my machine? Regards, SeenaDepend of what releases you are talking about. The client 9iR1 has never been supported against a 10gR2 server. Find out

Oracle 11G database for 64 bit windows installation error

Hi, I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click n

Problem with Oracle 11g(32 bit) installation on windows 7 ultimate edition

Hello all, I have a problem with Oracle 11g(32 bit) installation on windows 7 ultimate edition (32 bit). I have successfully installed it immediately after OS installation. But today, i have decided to deinstall it and go for Oracle 10g version for 3

Problem in installing Oracle 11g in home edtion of windows xp

i m trying to install Oracle 11g in home edition of windows xp. it is trelling some files not found. plz help me.!!!!!!!!!Upgrade to XP Professional, Home Edition is not supported. WernerRead other 2 answers

Oracle 11g and 12c on same windows 7 machine

Hi folks, Want to try out 12c on my windows 7 laptop but still want to keep my 11g database. Anyone tried running Oracle 11g and 12c on same windows machine? Any links or guidelines are appreciated Thanksyou won't be the first or the last person to t

32bit client on windows 2003 server R2 64bit running oracle 10g release 2

Hello, could you please help me ? I have a windows 2003 r2 sp2 64 bit server on witch oracle 10g release 2 64 bit is installed. So far no issue. I need to have a 32bit client installed on the same server to be able to run some applications on the ser

SSIS Oracle 11g 64 bit client upgrade Issue

After the oracle client upgrade from 10g to 11g, the ssis jobs are getting failed for the BadImageFormatException. Attempt to load Oracle client libraries threw This problem will occur when running in 64 bit mode with the 32 bit Oracle client compone

Can installing Oracle 11g on a client in the same network as another implementation cause problems?

Hi, I have a running Oracle 11g r2 installation running.  Same network, different subnet.  I want to install 11gR2 for development/testing on another machine not connected in any way to the other system other than they are on the same network (differ

Heterogenous connection with dg4odbc Oracle 11g: insert did not work !

Hi, we just migrated to a 64bits version of our oracle 10.2.0.4 database. We had a heterogenus connection who was woking "A1" at that time (in 32 bits). Now, we had some problems with the Odbc 64bits and we found on this site that we can use dg4

Oracle 11g R2 Database Client for Mac OS X?

Is there an Oracle 11g R2 client for Mac OS X? If so, where is it?Hi; Please check: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Also see: Master Note For Oracle Database Client Installation [ID 1157463.1] Clie

DB connection issue for Oracle 11g with jdk1.3

Hi Experts, I have jdk1.3 installed. I need to connect to Oracle 11g, but there is no driver class for Oracle 11g with jdk1.3. I have Classes12.jar for Oracle 9i with jdk1.3. When I try to connect to Oracle 11g with jdk1.3 using Classes12.jar, I get

Oracle 11g R2 install problem on Windows Server 2008 R2 SP1

Hi all, Trying to install the Oracle 11g R2 database onto Windows Server 2008 R2 SP1. I get as far as running the setup and a black window flashes up on the screen and disappears. The log files only show the following: Using paramFile: C:\Temp\databa

Oracle 8.1.7 Client and Windows XP

Has anyone experienced any issues with installing the Oracle 8.1.7 Client on a new Windows XP PC? Does anyone know if Oracle 8.1.7 (client) is compatible with Windows XP? Thanks in advance for any comments. Lisa Mears [email protected]I don't know ab