Tag Archives: oracle

Export and Import Oracle Database

Posted on August 10, 2017 by lorddisk

this video created by Mohamed Yassin

Posted in oracle | Tagged , , | Leave a comment

How to Export Oracle Schema

Posted on August 10, 2017 by lorddisk

just use this commend exp ODS/welcomw FIlE=/u01/software/ODS.dmp OWNER=ODS statistics=none log=/u01/software/logODS.log where ODS is schema name

Posted in Oracle | Tagged , , | Leave a comment

ORA-01940: cannot drop a user that is currently connected solved

Posted on August 3, 2014 by lorddisk

select sid, serial# from v$session where username = ‘AXF’; Alter user AXF account lock; alter system kill session ‘209,8029’; drop user AXF cascade;

Posted in database, oracle | Tagged , , , | Leave a comment

OPatch how to use?

Posted on June 23, 2014 by lorddisk

  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]$ … Continue reading →

Posted in SOA | Tagged , , , , , , , | Leave a comment

Oracle Sql

Posted on January 22, 2014 by lorddisk

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 … Continue reading →

Posted in Oracle, oracle, Uncategorized | Tagged , , | Leave a comment

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

Posted on August 18, 2013 by lorddisk

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 … Continue reading →

Posted in oracle | Tagged , , , , , , | 2 Comments

how to Check listener status?

Posted on May 30, 2012 by lorddisk

http://www.orafaq.com/wiki/Lsnrctl#Check_listener_status

Posted in ECM | Tagged , | Comments Off on how to Check listener status?

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

Posted on May 27, 2012 by lorddisk

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 … Continue reading →

Posted in ECM | Tagged , | Comments Off on how to get all schemas at oracle with owners and change them?