Osama_mustafa wrote:then explain this, from the op's posting of 'lsnrctl status'"DEDICATED" established:31 refused:0 state:readyYou database is not register with listener ,
The command completed successfully
Services Summary... Service "aaku" has 1 instance(s). Instance "aaku", status READY, has 1 handler(s) for this service...
Sqlplus / as sysdba
alter system register ;
Also Post Local_listener Parameter
CSM.DBA wrote:that what we are trying to do , excuse me if i didn't read your posts.
I'm not going to try that as it's clearly evident that the services are already registered.
I fell it's better if the members(particularly non-novice/non-beginner) won't try to spoil the integrity and the reliability of the Oracle forums when giving the solutions.
But you just clarified:
Used parameter files: C:\app\xxxx\client_22.214.171.124\network\admin\sqlnet.ora
check at listener.ora, listener.log and listener.trc for any error that can show any light about this issue. Check also windows registry looking for any wrong ORACLE_SID. Also i will try stopping & startint Oracle services (or restarting computer).
Hi Abu, My client tried with JDBC & SQLNET (through SQLDeveloper).