Home » SQL & PL/SQL » Client Tools » Connect to Oracle 9i database using PL/SQL Developer (Oracle 9i DB, Win Server 2003, VMware, PL/SQL Developer 7.1)
icon5.gif  Connect to Oracle 9i database using PL/SQL Developer [message #289524] Sun, 23 December 2007 09:57 Go to next message
saurabh_
Messages: 3
Registered: December 2007
Location: India
Junior Member

Hi,
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 using PL/SQL Developer but I cannot. I can connect to it using iSQL*Plus and also using Oracle SQL Developer (on the VM host machine). Here are my configuration details:

VMWare Host Name (Windows XP x64): 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 what is the method to connect to the database using PL/SQL Developer?
Re: Connect to Oracle 9i database using PL/SQL Developer [message #289525 is a reply to message #289524] Sun, 23 December 2007 11:27 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there any error message? If so, which one?
Re: Connect to Oracle 9i database using PL/SQL Developer [message #289529 is a reply to message #289525] Sun, 23 December 2007 11:44 Go to previous messageGo to next message
saurabh_
Messages: 3
Registered: December 2007
Location: India
Junior Member

No, there is no error message. If there is I can't see it because the resulting dialog box is too small (and it doesn't get bigger).

I am entering hr as the user name and the password. I don't know what to enter in the database field.

I have tried the connect string that I use with Oracle SQL Developer 1.2 which goes as:
<user>@//<host-name>:<port>/<service-name>
eg,
hr@//rkgit-ora9i:1521/srb.ora9i
but this doesn't work.
Any help would be appreciated.
Re: Connect to Oracle 9i database using PL/SQL Developer [message #289531 is a reply to message #289529] Sun, 23 December 2007 11:51 Go to previous messageGo to next message
saurabh_
Messages: 3
Registered: December 2007
Location: India
Junior Member

...and here is my PL/SQL Developer support information:

--- Info ---

PL/SQL Developer
Version 7.1.4.1390
Windows 2003 (64-bit) 5.2 Build 3790 (Service Pack 2)

Physical memory : 2,096,516 kB (394,080 available)
Paging file : 3,538,088 kB (2,644,008 available)
Virtual memory : 2,097,024 kB (1,860,756 available)

Parameters
E:\Program_Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
E:\Program_Files\PLSQL Developer\Preferences\Default\Default.ini
E:\Program_Files\PLSQL Developer\Preferences\saurabh\default.ini

Plug-Ins

Aliases

Homes

DLLs
c:\perl\bin\oci.dll

TNS File
c:\perl\Network\Admin\tnsnames.ora

Using
Home:
DLL: c:\perl\bin\oci.dll
OCI: version 9.2

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files (x86)\Oracle\Inventory

SOFTWARE\ORACLE\ODP.NET

--- Path ---

c:\perl\bin
e:\Program Files (x86)\CodeGear\RAD Studio\5.0\bin
C:\Documents and Settings\All Users\Documents\RAD Studio\5.0\Bpl
c:\perl\bin\
c:\windows\system32
c:\windows
c:\windows\system32\wbem
c:\program files (x86)\sun\jstudio_ent81\ide\uml2\modules\doorsintegrationfiles\modules\bin
e:\embedded\nasm
c:\mplayer
e:\web\php5
.
e:\web\mysql server 5.0\bin
c:\program files (x86)\microsoft sql server\90\tools\binn\
c:\gnuplot\bin
e:\java\jdk1.6.0_03\bin
e:\program files (x86)\rational\common
c:\network\snort\bin
c:\network\hping2.win32
c:\network\nc111nt
c:\network\windump
c:\network\angryipscanner
c:\network\fport-2.0
c:\network\ngrep-1.43\release
c:\network\nmap-4.20
c:\network\superscan
c:\network\wikto
c:\dosbox-0.70
h:\svn-win32-1.4.4\bin
c:\program files (x86)\amd\mcat\
E:\Program Files\MATLAB\R2007a\bin
E:\Program Files\MATLAB\R2007a\bin\win64
C:\network\putty
C:\Program Files (x86)\OpenSSH\bin
C:\SysinternalsSuite
E:\Program Files (x86)\QuickTime\QTSystem\

e:\Program Files (x86)\STI\bin\pc-win95

--- TNS names ---


I don't have the oracle client installed on my VMware host machine.
Re: Connect to Oracle 9i database using PL/SQL Developer [message #289537 is a reply to message #289531] Sun, 23 December 2007 13:28 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Check your tnsnames.ora (c:\perl\Network\Admin\tnsnames.ora) if there is an entry for your database.
Use that entry in the database-field.
Re: Connect to Oracle 9i database using PL/SQL Developer [message #377743 is a reply to message #289524] Wed, 24 December 2008 16:21 Go to previous message
kumarpiyus
Messages: 1
Registered: December 2008
Junior Member
Hi, I also had the same problem. I think you need to restart you system and after that relogin using Username as hr.
Previous Topic: Executing GET_DDL output in SQLPLUS
Next Topic: procedure
Goto Forum:
  


Current Time: Thu Dec 08 06:18:10 CST 2016

Total time taken to generate the page: 0.20814 seconds