This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits. RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]
Being DBA we all are aware that we must have knowledge of OS level too because Database not just runs over the only one OS. In a different organization, we have a different OS. Being a part if IT we understand that different OS environment has a different parameter. We have to set them. Today […]
We are continuing with the same series of listener errors. Let’s have looked over the new error. Let’s go for the steps
[oracle@hostname]$ sqlplus sys@test_1as sysdba
SQL*Plus: Release 184.108.40.206.0 Production on Tue Jul 7 15:01:04 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ORA-12154: TNS:could not resolve the connect identifier specified
Condition for error When Database is on in restricted on no mount status and you will see service handler for this instance is on BLOCKED or RESTRICTED state.
[oracle@hostname]$ lsnrctl status
LSNRCTL for Linux: Version 220.127.116.11.0 – Production on 07-JUL-2017 15:20:35
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
Version TNSLSNR for Linux: Version 18.104.22.168.0 – Production
Start Date 07-JUL-2015 14:18:31
Uptime 0 days 1 hr. 2 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /opt/oracle/product/22.214.171.124/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/stagedevdb2/listener/alert/log.xml
Listening Endpoints Summary…
Service “+ASM” has 1 instance(s).
Instance “+ASM”, status READY, has 1 handler(s) for this service…
Service “teston” has 1 instance(s).
Instance “teston“, status BLOCKED, has 1 handler(s) for this service…
The command completed successfully
Solution: Add (UR=A) […]
Let’s start the series of Oracle listener. Now are going to focus over the issue for the following errors. Let’s have looked over the steps and solve the issues.
TNS-12516 TNS: listener could not find an instance with the matching protocol stack
ORA-12516 TNS: listener could not find available handler with the matching protocol stack
TNS-12519 TNS: no appropriate service handler found
ORA-12519 TNS: no appropriate service handler found
ORA-12520 TNS: listener could not find available handler for requested type of server
Cause: None of the known and available service handlers for the given SERVICE_NAME support the client’s protocol stack: transport, session, and presentation protocols. Solution: check […]
Being human being we have a lot of unlimited qualities. Listening is one of them. Normally we ignore it but it is most important for all. Good listing keeps us away from 99% problems away and life makes us simple but if we don’t listen properly we invite unlimited problem in our life. In same […]
Being DBA we all are aware that Oracle Database makes a connection with a client with the help of listener. Oracle provides the facility to have look over the status of Oracle listen. Being a part of IT we must be aware that 24*7 We require database live but due to some unfortunate conditions database […]
Let’s have look on some listener issues in the database. Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified. Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If […]
This Post is about the trick by which we can use to monitor the CRDs of Oracle Database. Monitoring is the most important and common task in RDBMS. Without monitoring CDR Let’s have look on the query which we use to monitor main elements of Oracle Database CDRs. — MAXDATAFILES Select ‘MAXDATAFILES ‘ || records_total […]
Today we have looked over ASM Instance Remotely. We can see that the normal instance of RDBMS is different from ASM. Connect to ASM Instance Remotely Being DBA we are aware that By Default Oracle ASM don’t allow remote sysdba connection since ASM instance is in NOMOUNT state. You Might get ORA-12528: TNS:listener: all appropriate […]
As we are working on the series of listener errors. Now we are going to work on “ORA-12514“. Let’a have look on the steps which we use to resolve this issue. Cause: “The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID […]