Oracle self-starter settings and Import export methods

Linux system boot Oracle self Boot

Log in as root:

$su-root

1, Linux under the Oracle band Dbstart and Dbshut no response:

Modify Oracle System Configuration document/ETC/ORATAB document: #vi/etc/oratab

The/etc/oratab format is: SID:ORACLE_HOME:AUTO

To configure the Auto field to Y (uppercase), my:

Oradb:/opt/u01/app/oracle/product/9.2.0.4:y

Only in this way, Oracle Dbstart and Dbshut can play a role.

2, modify the/etc/rc.d/rc.local configuration document

Add the following in/etc/rc.d/rc.local: #vi/etc/rc.d/rc.local

Su-oracle-c "/u01/app/oracle/product/9.2.0.4/bin/lsnrctl Start"

Su-oracle-c "/u01/app/oracle/product/9.2.0.4/bin/dbstart Start"

3. Reboot

#reboot

、

ORACLE11G Import, Export::

ORACLE11G Export the database with exp, the empty table is not available, so you must import the Oracle database with data pump.

1, EXPDP

Sql> Create directory directory name (such as: DMPBX) as storage address (such as: '/root/usr/... ');

The directory has been created.

Sql> Grant Read,write on directory name to public;

The authorization was successful.

Sql> exit

EXPDP username 1/Password @ instance dumpfile= backup file name (ecology.dmp) directory= directory name (DMPBX)

2, IMPDP

Sql> Create directory directory name (such as: DMPBX) as storage address (such as: '/root/usr/... ');

The directory has been created.

Sql> Grant Read,write on directory name to public;

The authorization was successful.

Sql> exit

IMPDP username 2/Password @ instance directory= directory name dumpfile= backup file name. DMP logfile= log name. log remap_schema= User name 1: User Name 2

If the IMPDP is operating on the same machine, then the steps to create the directory and the weights before IMPDP can be omitted.

Note:: File permission issues, instance name = Service Name

Chown,chmod settings

Some Ora errors::

Ora-00845:memory_target not supported on this system

Modifying the size of the/DEV/SHM can be accomplished by modifying the/etc/fstab:

[ROOT@DB2 ~]# df-h/dev/shm//view/DEV/SHM size

Tmpfs 1.0G 500M 500M 50%/DEV/SHM

[ROOT@DB2 ~] #vi/etc/fstab//replacement/DEV/SHM default size is 2G

label=//ext3 Defaults 1 1

Label=/boot/boot ext3 Defaults 1 2

#tmpfs/dev/shm TMPFS defaults 0 0

Tmpfs/dev/shm Tmpfs defaults,size=2048m 0 0

Devpts/dev/pts devpts gid=5,mode=620 0 0

Sysfs/sys Sysfs Defaults 0 0

PROC/PROC proc Defaults 0 0

Label=swap-hda3 Swap Defaults 0 0

Mount-o REMOUNT/DEV/SHM

Ora-01102:cannot mount Database in EXCLUSIVE mode

/opt/oracle/ordata/orcl200

Fuser-u lk*

Fuser-k lk*