Listener

How to Add Static Service Registered in Listener

Posted on
Static Service Registration Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service can be used to service external connections with or without a running instance on the server. According to Oracle 18c Advanced Features of Oracle Net Services, the use […]
Shell Script

How to Auto Start Oracle Database on Solaris

Posted on
For Linux Os, you should check this post: How to Auto Start Oracle Database on Linux. Assuming that you already have some knowledge about how to start Oracle database manually and Oracle provided shell script dbstart, then we can keep going to design and deploy our automatic startup scripts. By default, Oracle software installation does […]
Shell Script

How to Auto Start Oracle Database on Linux

Posted on
For Solaris OS, you should check this post: How to Auto Start Oracle Database on Solaris. Assuming that you already have some knowledge about how to start Oracle database manually and Oracle provided shell script dbstart, then we can keep going to design and deploy our automatic startup scripts. By default, Oracle software installation does […]
Listener

How to Resolve TNS-12546: TNS:permission denied + Solaris Error: 13: Permission denied

Posted on
TNS-12546 I got TNS-12546: TNS:permission denied when I tried to start listener as oracle. oracle@solaris11vm:~$ lsnrctl startLSNRCTL for Solaris: Version 11.2.0.4.0 – Production on 31-JAN-2018 21:01:57Copyright (c) 1991, 2013, Oracle.  All rights reserved.Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait…TNSLSNR for Solaris: Version 11.2.0.4.0 – ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to /u01/app/oracle/diag/tnslsnr/solaris11vm/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))TNS-12546: […]
DNS

sqlplus, tnsping or lsnrctl Hangs

Posted on
sqlplus, tnsping or lsnrctl Hangs I can’t cover all situations in this post, but I have some cases that can share with you. Those hanging all point to one problem: Domain name resolution. Does the database server use DNS to do name resolution? Sometimes, DNS traps the name resolution in an unknown and indefinite loop […]
Public IP

How to Add a Public IP Address to Grid

Posted on
Strictly speaking, adding a public IP to server at OS-level is no problem, but you can’t add any public IP to join any node of RAC at grid-level, because the clusterware must determine the public IP by resolving hostname of its node at startup-time. You can only replace it. There’re two possible scenarios of changing […]
SCAN IP

How to Add a SCAN VIP to Grid

Posted on
Looking up SCAN name on DNS before adding a SCAN VIP[root@primary01 ~]# nslookup primary-cluster-scanServer:         10.0.0.199Address:        10.0.0.199#53Name:   primary-cluster-scan.example.comAddress: 10.0.0.82Name:   primary-cluster-scan.example.comAddress: 10.0.0.81Name:   primary-cluster-scan.example.comAddress: 10.0.0.83There’re 3 SCAN VIPs for this name.Adding a SCAN VIP to DNS[root@dns ~]# cd /var/named/[root@dns named]# vi example.com.zone[root@dns named]# vi 0.10.zone[root@dns named]# systemctl restart […]
Listener

How to Resolve Endpoint Listener is Not Listening to Public IP

Posted on
I found that I can connect the database via VIP or SCAN, but not Public IP. I checked the endpoint listener. It did not listen the public IP. [grid@primary01 ~]$ cat $ORACLE_HOME/network/admin/endpoints_listener.ora #Backup file is  /u01/app/12.1.0/grid/network/admin/endpoints_listener.ora.bak.primary01 line added by Agent LISTENER_PRIMARY01=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=primary01-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)(IP=FIRST))))         # line added by Agent It was listening 127.0.0.1, no […]