TNS-01201: Listener cannot find executable $ORACLE_HOME/bin/dg4odbc for SID .......

I have setup the gateway configuration .and restart the listener, listener fails to restart

With below error

TNS-01201: Listener cannot find executable $ORACLE_HOME/bin/dg4odbc for SID XYZ

Listener.ora file looks like below

Error 11gr2 runInstaller solairs 11 motif21/libmawt.so: ld.so.1: java: fatal: libXm.so

I was trying to Install oracle database 11.2.0.1 on one of newly configured Oracle Solaris 11.3 on sparc 64-bit T7-1 server. I have encountered below error message while executing runInstaller:


jdk/jre/ lib/amd64/motif21/libmawt.so: ld.so.1: java: fatal: libXm.so open failed no such file or directory.

Cause:

Installer couldn't find the expecting library file "libmawt.so". There is missing package on OS.



Solution:

Install missing package 

1. Search for missing package in repository

# pkg search library/motif

ORA-39710 only connect AS SYSDBA is allowed when OPEN in UPGRADE mode

Oracle Database Error ORA-39710

We upgrade oracle 11g database patch on solaris. Database showing restricted mode.

You have to shutdown the database (Shutdown immediate) & startup database in normal mode.

ORA-39710 only connect AS SYSDBA is allowed when OPEN in UPGRADE mode

Cause

An attempt was made to connect to a database when the database was OPEN for UPGRADE or DOWNGRADE.

Action

Try to connect again after the database upgrade or downgrade is complete.

Oracle 11gR2 Patch 11.2.0.4 on Solaris

Download the ‘patch’ software

Login to Oracle support site.

• Download the below patch .

•  p13390677_112040_SOLARIS64_1of7 (Oracle Database, including Oracle RAC components)
•  p13390677_112040_SOLARIS64_2of7 (Oracle Database, including Oracle RAC components)
•  p13390677_112040_SOLARIS64_3of7 (Oracle Grid Infrastructure, includes: Oracle ASM, Oracle Clusterware, Oracle Restart)
•  p13390677_112040_SOLARIS64_4of7 (Oracle Database Client)
•  p13390677_112040_SOLARIS64_5of7 (Oracle Gateways)
•  p13390677_112040_SOLARIS64_6of7(Oracle Examples)
•  p13390677_112040_SOLARIS64_7of7 (Deinstall)

Once you’ve downloaded the software, unzip both files to a staging area:

$ unzip p13390677_112040_SOLARIS64_1of7  -d /ora/Desktop/db

$ unzip p13390677_112040_SOLARIS64_2of7  -d /ora/Desktop/db

All of the contents from the above will be extracted to a “database” directory.

$ /ora/Desktop/db/runInstaller

# /u01/app/oralce/product/11.2.0.4/root.sh

[root@linux03 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

/u01/app/oracle/product/11.2.0.4/root.sh

[root@linux03 ~]# /u01/app/oracle/product/11.2.0.4/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME= /u01/app/oracle/product/11.2.0.4

Enter the full pathname of the local bin directory: [/usr/local/bin]: <enter>
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

Finally, back to the GUI, click close to finish, and you’re all done 

Goto to new oracle_home

./dbua