Hello All..
I need your help in establishing the connection with the database .
I've DB11gR2 11.2.0.3 running on Ol6.8
It running fine
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 20-SEP-2017 19:40:49
Uptime 0 days 0 hr. 19 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/sscdbvmp01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sscdbvmp01.abc.com)(PORT=1521)))
Services Summary...
Service "orcl.abc.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.abc.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
The listner.ora and tnsnames.ora -- they all have correct host names.
I'm able to start the instance as well:
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
I can create schema as well.
I am able to ping the database server and vice-versa ..
But I am not able to connect from my sql developer and getting this error
Any help will be appreciated ..
Regards