I have just installed Oracle 9i database on a Windows Server 2003 running in VMWare Workstation hosted on a Windows XP x64 Edition. I want to connect to the database server using PL/SQL Developer but I cannot. I can connect to it using iSQL*Plus and also using Oracle SQL Developer. Here are my configuration details:
VMWare Host Name: star-1 (IP:192.168.1.15)
Guest OS Name (Windows 2003): rkgit-ora9i (IP: 192.168.1.16)
Oracle service name: srb.ora9i
Database user name: hr
Listener port: 1521
Can anyone tell me waht is the method to connect to the database using PL/SQL Developer?
No, I cannot because Client for 9i is not available for Win x64_86
And what about the following one ?
You have to download the software as well, then choose an Oracle Client install when the question about installation type is prompted to you.
Anyway, client 10g should work against a 9iR2 database (not 9iR1).
adding the link
Message was edited by:
Critical Notes For Oracle Database - Enterprise Edition
General Notes For Oracle Database - Enterprise Edition On Microsoft Windows XP (AMD64/EM64T):
32-bit and 64-bit Information
o There is no 64-bit version of 9iR2 nor 10gR1 for 64-bit Windows on AMD64/EM64T hardware
o Running 32-bit applications on a 64-bit operating system is generally referred to as "Compatibility-Mode" by many AMD64/EM64T hardware vendors. Irrespective of this terminology, 32-bit Oracle Database server is not certified on Windows x64. For the 32-bit Oracle database client, check the certification matrix for more details.
o Oracle certifies against the specific Microsoft operating system (OS) and, if applicable, service packs (SPs) stated in the Oracle product documentation. Oracle will support the use of our products on any later SP or OS security patch as soon as that SP or patch becomes generally available. Depending upon the severity, quantity, and impact of the SP or patch-related issues found, Oracle may recommend that customers wait until relevant Oracle patches have been released before upgrading to a particular SP or OS patch. Oracle may recommend or discourage the installation of specific SPs or patches if it will significantly affect the operation of Oracle software, either positively or negatively. If such a statement is deemed necessary, then Oracle Development will disseminate this statement in as timely a fashion as possible after the release of the SP or patch.
-->The link you provided is not x86_64. It is for Intel Itanium x64. When you run the app a message appears saying "this application is valid but not for this your machine".
Ok, then ? The compatibility matrix between Oracle software and your config should be solved before starting the installation of your system.
Anyway, as I said above, if your database is 9iR2, the 10g client should work fine.