SOA

OPatch how to use?

  export ORACLE_HOME=/u01/Middleware/Oracle_SOA1 echo $ORACLE_HOME cd to /u01/Middleware/Oracle_SOA1/OPatch copy the patch to Opatch Directory unzip patch [oracle@web OPatch]$ ./opatch apply 18072286/ -oh /u01/Middleware/Oracle_SOA1/ [oracle@web OPatch]$ ./opatch apply 18072286/ -oh /u01/Middleware/oracle_common/ you can specify the patch directory as follows [oracle@web OPatch]$ ./opatch apply /u01/Middleware/Oracle_SOA1/OPatch/18072286/ -oh /u01/Middleware/Oracle_SOA1/ [oracle@web OPatch]$ ./opatch apply /u01/Middleware/Oracle_SOA1/OPatch/18072286/ -oh /u01/Middleware/oracle_common/   output Verifying… Continue reading OPatch how to use?

Oracle · oracle · Uncategorized

Oracle Sql

USING SQL PLUS or Any Oracle Tool Like “SQL Developer or TOAD” ============================================================== create user supplier2 identified by supplier2 grant connect,resource,dba to supplier2 unlock ====== alter user joe account unlock; alter user awb account unlock identified by awb; change password =============== alter user awb identified by awb; To use import tool go to the following… Continue reading Oracle Sql

oracle

How to Fix ORA-12162 TNS:net service name is incorrectly specified Error in Oracle?

sometimes  the oracle profile is not prepared correctly and this give so many errors and you should go direct to directory of SqlPlus to start DB /u01/app/oracle/product/11.2.0/dbhome_1/bin ./sqlplus sys/password as sysdba; the following error will arises ORA-12162 TNS:net service name is incorrectly specified Cause This arises if you have not set ORACLE_HOME and ORACLE_SID. Solution… Continue reading How to Fix ORA-12162 TNS:net service name is incorrectly specified Error in Oracle?

ECM

how to get all schemas at oracle with owners and change them?

SQL> SELECT comp_id, comp_name, version, status, mrc_name, owner FROM schema_version_registry; COMP_ID    COMP_NAME                      VERSION    STATUS      MRC_NAME   OWNER ———- —————————— ———- ———– ———- ————— BAM        BAM Services                   11.1.1.2.0 VALID       DEV        DEV_ORABAM MDS        Metadata Services              11.1.1.4.0 VALID       SYSMAN     SYSMAN_MDS ORASDPM    SDP Messaging                  11.1.1.2.0 VALID       DEV        DEV_ORASDPM SOAINFRA   SOA Infrastructure Services    11.1.1.4.0 VALID       DEV        DEV_SOAINFRA 1. Log in as… Continue reading how to get all schemas at oracle with owners and change them?