![Oracle error in PL SQL Developer] 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 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 ++++++++++++++++++++++++++++++++++
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) ) )
(ADDRESS = (PROTOCOL = TCP)(HOST = ..*.*)(PORT = 1521))
Please help me ... Struggling since long to sort this out.