Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

![Oracle error in PL SQL Developer][1] I am facing issues while trying to connect my database through PL-SQL Developer. It throws error - ORA-01034 everytime. Please note the below. 1.I am using Eazconnect method to connect database like username/passwd :/ in the connection fields for PL-SQL developer tool. but I am able to connect other database location with same method. 3.I am able to connect the same database through sql developer/Toad and putty for the same host and instance. 4.I checked the log.xml file in the server and i can see logs are updating with the request from my machine and program name as "plsqldev.exe" and my ip is also shown with " * establish * " printed.

I want to use pl/sql developer to find differences between various databases with data for which sql developer/toad is not suitable (I think).

Oracle 11g is installed in RHEL server info given below
++++++++++++++++++++++++++++++++
lsb_release -a
LSB Version: :core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch Distributor ID: RedHatEnterpriseServer Description: Red Hat Enterprise Linux Server release 6.3 (Santiago) Release: 6.3 Codename: Santiago ++++++++++++++++++++++++++++++++++
uname -a
Linux CROAMIS09 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
++++++++++++++++++++++++++++++++++

Firewall is off in this server.
++++++++++++++++++
service iptables status iptables: Firewall is not running.
++++++++++++++++++
Checked my local tnsnames.ora using easeconnet method and toad is able to connect.

tns entry from the server below
+++++++++++++++++++++
QTRDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ..*.*)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = qtrdb.localdomain) ) )

LISTENER_QTRDB = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ..*.*)(PORT = 1521)) )
+++++++++++++++++++++++++++++++

Please help me ... Struggling since long to sort this out.

Regards,
Vinay Sharma

share|improve this question
    
Check SID & Service Name please. –  user220630 May 21 at 16:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.