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

Oracle Enterprise Manager 13c-R1 Installation on Database 12.1.0.2

ORA-65096: create 12c user without c## prefix

 I am trying to create a user in Oracle 12c and I don't give a rat's butt about pluggable databases.  When I try to create a user with the c## prefix I get the dreaded ORA-65096 error:

create user fred identified by flintstone;
ORA-65096: invalid common user or role name



I don't care if the user ID is used as a pluggable database, I just want to create a user named fred without being required to add the c## prefix (create user c##fred).


How do I fix the ORA-65096 error and create my use without a container database c## prefix?


Solution:


The oerr utility is not at all helpful for the ORA-65096 error:

ORA-65096: invalid common user or role name

Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters.

Action: Specify a valid common user or role name.

The solution to the ORA-06596 is to set a hidden parameter "_oracle_script".  When you set the undocumented (hidden) parameter "_oracle_script"=true  you can create the fred user without a C## in from of the user ID.  However, this user will not used useful in a pluggable/container database:

connect system/manager as sysdba

alter session set "_ORACLE_SCRIPT"=true;

create user fred identified by flintstone;

grant dba to pubs;

connect fred/flintstone

 

(90) media manager received no data for backup image

 

 

 

 (90) media manager received no data for backup image

 

 

 

Cause

 

 

The Backup Policy is configured as:
·               Backup Selection is  "All Local Drives"
·               one or more drives are excluded
·               Multi-streaming is enabled.

Solution

Modify the excluded drive as follows:
Add an asterisk (*) to the excluded drive list:
i.e.
If drive X is to be excluded and is listed in the excluded list as "X:\"
Add an asterisk  "*" to make the exclusion "X:\*"
Modify Exclude list, and retry backup.