Oracle11g Export Database

Enter exp.exeat runtime, and then enter exp.exe in the doscommand to export the database conveniently.

 

Possible Error 1: the database is not loaded

EXP-00056: Oracle error 1034

A ORA-01034: Oracle not available

ORA-27101: Shared Memory realm does not exist

EXP-00005: All allowed login attempts failed

EXP-00000: Export termination failed

This error occurs because the database is not open.

Alter database Mount; // load the database

Possible Error 2: ORA-12560: TNS protocol adapter Error

1. The listening service is not started. For Windows, perform the following operations: start ---Program--- Management tools --- services, open the service panel,

Start the oraclehome92tnslistener service.
2. The database instance is not started. On Windows, perform the following operations: start --- program --- management tools --- Service, open the service

Panel, start oracleservicexxxx, XXXX is your database Sid.
3. Registry issues. Regedit, and then enter HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle \ home0 to change the environment variable oracle_si

D is set to xxxx, XXXX is your database Sid. Or the right few my computers, properties -- Advanced -- environment variables --- system variables -- New

, Variable name = oracle_sid, variable value = XXXX, XXXX is your database Sid. Or before entering sqlplus, under command line

Set oracle_sid = XXXX, XXXX is your database Sid.

View database_sid

Select * from V $ instance;