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
By default, Oracle software installation does not deploy startup and shutdown init scripts on the platform, you have to create them by yourself. Here I introduce my scripts for you to use or modify with. Turn on startup option in oratab Please change the startup option to “Y” at the last character of the line. […]
Shell Script

How to Auto Start Oracle Database on Linux

Posted on
By default, Oracle software installation does not deploy automatic startup and shutdown init scripts on the platform, you have to create them by yourself. Here I introduce my scripts for you to use or modify with. Turning on startup option in oratab Please change the startup option to “Y” at the last character of the […]
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: […]
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 AgentLISTENER_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 AgentIt was listening 127.0.0.1, no wonder I can’t connect […]