ORACLE Export/Import

Oracle Import :

imp
Username:.......
Password:.......
Import data Only: no
Import file: EXPDAT.DMP
List contents of import file only (yes/no): no > no
Ignore create error due to object existence:>no
Import grants>yes
Import table data>yes
Import entire export file>no
Username:........


[root@fws Desktop]# cd /opt
[root@fws opt]# source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
[root@fws opt]# ls
Disk1                             New Text Document.txt
f101(1).sql                       oracle-xe-11.2.0-1.0.x86_64.rpm
f111(4).sql                       putty.rpm
image.sql                         rh
libaio-0.3.109-5.fc17.x86_64.rpm  SAJIB(1.oct.13).sql
lsnrctl status                    SAJIB.5.oct.13.DMP
lsnrctl status~                   teamviewer_linux.rpm
[root@fws opt]# imp

Import: Release 11.2.0.2.0 - Production on Tue Oct 8 03:51:27 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: system
Password:

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

Import data only (yes/no): no > no

Import file: expdat.dmp > SAJIB.5.oct.13.DMP

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V11.02.00 via conventional path

Warning: the objects were exported by SAJIB, not by you

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > no

Ignore create error due to object existence (yes/no): no > no

Import grants (yes/no): yes > yes

Import table data (yes/no): yes > yes

Import entire export file (yes/no): no > no
Username: sajib

Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:

. importing SAJIB's objects into SAJIB
. . importing table              "ADD_STOCK_FIBER"          4 rows imported
. . importing table                    "APEX$_ACL"          0 rows imported
. . importing table               "APEX$_WS_FILES"          0 rows imported
. . importing table             "APEX$_WS_HISTORY"          0 rows imported
. . importing table               "APEX$_WS_LINKS"          0 rows imported
. . importing table               "APEX$_WS_NOTES"          0 rows imported
. . importing table                "APEX$_WS_ROWS"          0 rows imported
. . importing table                "APEX$_WS_TAGS"          0 rows imported
. . importing table      "APEX$_WS_WEBPG_SECTIONS"          0 rows imported
. . importing table "APEX$_WS_WEBPG_SECTION_HISTORY"          0 rows imported
. . importing table          "APEX_ACCESS_CONTROL"         42 rows imported
. . importing table            "APEX_ACCESS_SETUP"          2 rows imported
. . importing table                          "BAF"         20 rows imported
. . importing table                          "BZB"         38 rows imported
. . importing table                         "CEPZ"         61 rows imported
. . importing table                          "CGB"         57 rows imported
. . importing table                         "CHKB"         59 rows imported
. . importing table                         "CHMB"          0 rows imported
. . importing table                         "CHWB"          0 rows imported
. . importing table               "DEMO_CUSTOMERS"          7 rows imported
. . importing table                  "DEMO_ORDERS"         10 rows imported
. . importing table             "DEMO_ORDER_ITEMS"         49 rows imported
. . importing table            "DEMO_PRODUCT_INFO"         10 rows imported
. . importing table                  "DEMO_STATES"         51 rows imported
. . importing table                   "DEMO_USERS"          2 rows imported
. . importing table                         "DEPT"          4 rows imported
. . importing table                         "DWHB"         67 rows imported
. . importing table                          "EMP"         14 rows imported
. . importing table                          "FGB"          0 rows imported
. . importing table                          "FWT"         29 rows imported
. . importing table                          "GEC"         71 rows imported
. . importing table                           "HQ"        332 rows imported
. . importing table                         "IMGB"         41 rows imported
. . importing table                         "KEPZ"         26 rows imported
. . importing table                          "KGB"          1 rows imported
. . importing table                          "KSB"         79 rows imported
. . importing table                          "LKB"         35 rows imported
. . importing table                       "MCOURT"          0 rows imported
. . importing table                          "MEB"         31 rows imported
. . importing table                          "MGB"         19 rows imported
. . importing table                          "NGB"         41 rows imported
. . importing table                          "NKB"        146 rows imported
. . importing table                          "PLB"         64 rows imported
. . importing table              "RADIO_LINK_INFO"         49 rows imported
. . importing table                           "SI"          0 rows imported
. . importing table                          "SPB"          1 rows imported
. . importing table                  "STOCK_FIBER"          6 rows imported
. . importing table                  "SWITCH_INFO"         56 rows imported
. . importing table                       "TEST10"          1 rows imported
. . importing table                  "UNIQUE_TEST"          4 rows imported
About to enable constraints...
Import terminated successfully without warnings.
[root@fws opt]#

Oracle-ARCHIVELOG

command on command Prompt:
...............................
sqlplus /nolog
connect / as sysdba

or sqlplus / as sysdba


Backing Up and Recovering:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>



***Enabling ARCHIVELOG Mode for Media Failure Protection:***
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

>sqlplus / as sysdba
>select log_mode from v$database;
>SHUTDOWN IMMEDIATE
>STARTUP MOUNT
>ALTER DATABASE ARCHIVELOG;
>ALTER DATABASE OPEN;
>exit;



***Flash Recovery Area***
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Two parameters:
* DB_RECOVERY_FILE_DEST and
* DB_RECOVERY_FILE_DEST_SIZE

Flash Recovery Area Default Location:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Linux:    /usr/lib/oracle/xe/app/oracle/flash_recovery_area/
Windows:  c:\oraclexe\app\oracle\flash_recovery_area/

To change the flash recovery area location:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

>sqlplus /as sysdba
>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'new_path';
>@?/sqlplus/admin/movelogs
Example:(for windows)
>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'E:\FRA';
>@?/sqlplus/admin/movelogs

 "C:\oraclexe\app\oracle\product\11.2.0\server/sqlplus/admin/movelogs.sql"



To Changing the Flash Recovery Area Size:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = new_size;
>exit;
Example:
>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G;
>exit;



Monitoring Location & Space in the Flash Recovery Area:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


SELECT
NAME,
TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,
TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999')
AS SPACE_AVAILABLE,
ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)
AS PERCENT_FULL
FROM V$RECOVERY_FILE_DEST;


Restoring and Recovering the Database:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

> On Windows: Click Start, point to Programs (or All Programs), point to
Oracle Database 11g Express Edition, and then select Restore Database.

> On Linux with Gnome: In the Applications menu, point to Oracle Database
11g Express Edition, and then select Restore Database.

> On Linux with KDE: Click the icon for the K Menu, point to Oracle Database
11g Express Edition, and then select Restore Database.

Setting Enviroment Variables on Linux platform for Oracle

Setting Enviroment Variables on Linux platform

For Bourne,Korn or Bash shell

>source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

For C shell:
>source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.csh

 not path for 11g2

>source /usr/lib/oracle/xe/app/oracle/product/11.2.0/server/bin/oracle_env.sh



For Remote login

SQL>EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

[sajib@fws ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 05-OCT-2013 22:33:15

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                05-OCT-2013 22:01:03
Uptime                    0 days 0 hr. 32 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/fws/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully



[sajib@fws ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sat Oct 5 22:34:37 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

Check HTTP Port:


SQL>SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

-- If the above returns 0 then run this

Set HTTP Port:

EXEC DBMS_XDB.SETHTTPPORT(8080);

 SQL>SELECT LOG_MODE FROM SYS.V$DATABASE;

 ARCHIVELOG  or  NO ARCHIVELOG

SQL> select dbms_xdb.gethttpport from dual;

GETHTTPPORT
-----------
       8080


SQL> show parameter DB_RECOVERY_FILE_DEST;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     /u01/app/oracle/fast_recovery_
                         area
db_recovery_file_dest_size         big integer 10G


SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 50G;

System altered.

SQL> show parameter DB_RECOVERY_FILE_DEST;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     /u01/app/oracle/fast_recovery_
                         area
db_recovery_file_dest_size         big integer 50G



SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE
------------
NOARCHIVELOG

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  622149632 bytes
Fixed Size            2229048 bytes
Variable Size          394267848 bytes
Database Buffers      222298112 bytes
Redo Buffers            3354624 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE
------------
ARCHIVELOG

[root@fws Desktop]# lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-OCT-2013 02:57:19

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                08-OCT-2013 02:36:40
Uptime                    0 days 0 hr. 20 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/fws/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fws.colbd.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fws.colbd.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
[root@fws Desktop]#



 expdp system schemas=sajib directory=dmpdir dumpfile=sajib.dmp logfile=expsajib.log

expdp system/051502718 schemas=sajib directory=dmpdir dumpfile=expsajib.dmp logfile=expsajib.log

EXPORT COMMAND
for Full Data Mode:
exp full=y file=dba.dmp grants=y rows=y
exp full=y file=dba.dmp log=dba.log

for User Mode:
exp sajib/sajib file=sajib.dmp owner=sajib grants=y rows=y compress=y log=sajib.log

IMPORT COMMAND

imp full=y ignore=y file=expdat.dmp

How do I stop firewall?

Start Iptables under Linux

Q. How do I start Iptables firewall under RHEL / Red Hat / CentOS / Fedora Linux from a shell prompt? How do I stop firewall?

A. First, you need to configure firewall rules by editing text file located at /etc/sysconfig/iptables. You can also use setup command to configure firewall. Just type the following as root user:

# setup

Select Firewall configuration and just follow on screen instructions.
Once configuration is updated type the following command at a shell prompt:

To start firewall from a shell enter:

# chkconfig iptables on
# service iptables start

To stop firewall, enter:

# service iptables stop



For Details about iptables:
http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch14_:_Linux_Firewalls_Using_iptables#.UXFvBMr0nIV