Tag Archives: oracle

Export and Import Oracle Database

this video created by Mohamed Yassin Advertisements

Posted in oracle | Tagged , , | Leave a comment

How to Export Oracle Schema

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

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?

  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

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?

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?

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

Posted in ECM | Tagged ,