ORACLE errors and configuration Collection [ora

And all characters should be mixed with letters and numbers ERROR description and solution: ERROR: ora-12541: TNS: No listener 1. no listener or the listener is not started. Solution: Configure or restart the listener. when the listener has been started, an error is reported, indicating that the listener and database are started in the order

And all characters should be mixed with letters and numbers ERROR description and solution: ERROR: ora-12541: TNS: No listener 1. no listener or the listener is not started. Solution: Configure or restart the listener. when the listener has been started, an error is reported, indicating that the listener and database are started in the order

All characters must contain letters and numbers.

Error descriptionAnd solutions ::

ERROR:

Ora-12541: TNS: No listener
1. There is no listener or the listener is not started;

Solution: Configure or restart the listener.

2. If the listener has been started, an error is reported, indicating that the listener and database startup sequence is incorrect.

Solution: Keep the listener on; restart the database Service (restart database)

ERROR:
ORA-12170: TNS: Connection timeout
Solution::

1. cmd ----- ping the IP address to view network problems and check whether the ping is successful.

2. cmd ----- tnsping IP address (or server instance name SID) If "TNS-12535: Operation timeout" is reported, it may be a server-side Firewall Not closed

3. Run cmd ---- netstat-na to check whether port 1521 is disabled. If the firewall settings in Windows XP are disabled, set port 1521 as an exception.

4. cmd ---- lsnrctl status Lsnrctl is the abbreviation of listener-control listener. It is used to view the listener status.

2. Database Connection error: ora 12541 TNS no listener

Field Back, login pl/SQL error: ORA-12541: TNS: No listener.

1. Check oracle \ product \ 10.1.0 \ db_1 \ NETWORK \ log \ listener. log:

TNSLSNR for 32-bit Windows: Version 10.1.0.2.0-Production on month-2010 13:38:34

Copyright (c) 1991,200 4, Oracle.All rights reserved.

The system parameter file is D: \ oracle \ product \ 10.1.0 \ db_1 \ network \ admin \ listener. ora.

Write the log information of D: \ oracle \ product \ 10.1.0 \ db_1 \ network \ log \ listener. log

Write trace information for D: \ oracle \ product \ 10.1.0 \ db_1 \ network \ trace \ listener. trc

The trail level is currently 0.

Start with pid = 7180

Listener: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (PIPENAME = \. \ pipe \ EXTPROCipc )))

Error listening to this object: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 )))

TNS-12542: TNS: Address occupied

TNS-12560: TNS: protocol adapter error.

TNS-00512: address already in use

32-bit Windows Error: 48: Unknown error

No listening: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (PIPENAME = \. \ pipe \ EXTPROCipc )))

2. The listener of Oracle has been started.

3. View oracle \ product \ 10.1.0 \ db_1 \ NETWORK \ ADMIN \ listener. ora

# Listener. ora Network Configuration File: D: \ oracle \ product \ 10.1.0 \ db_1 \ network \ admin \ listener. ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D: \ oracle \ product \ 10.1.0 \ db_1)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC ))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 ))

)

)

)

Put (ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 ))

Change to (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))

Pc-xxx.mail.yyy.cn is the computer name

127.0.0.1 is the IP address currently in use by the database.

4. View oracle \ product \ 10.1.0 \ db_1 \ NETWORK \ ADMIN \ tnsnames. ora

Find the following statement:

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 ))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

To (ADDRESS = (PROTOCOL = TCP) (HOST = pc-xxx.mail.yyy.cn) (PORT = 1521 ))

Change to (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))

5. Close the listener and start listener.

Run-> cmd to start the dos window, execute lsnrctl stop to close, and lsnrctl start to start.

Ora 12541 tns no listening program ORA 12541 TNS

Iii. Export the entire oracle Database

After the Office is moved, we need to export the database on server (A) to another server (B) as follows:

Double-click exp.exe in the E: \ oracle \ product \ 10.2.0 \ db_1 \ BIN directory of oracle B. 1:

1. Enter the user name and password (the user corresponding to the database you want to export ). Note: The user name is the full name in the upper-right corner of the form after PLSQL login. Press enter

2. Input array extract buffer size: 65536 press enter

3. enter the path of the exported file, for example, e: \ testenv20120502.cmp. Press enter.

4. Select the export type. You can export all tables as needed:(1) E (complete database), (2) U (User) or (3) T (table): (2) U, input EPress enter

5. Press enter to export permissions, table data, and compression areas.

After the preceding operations are completed, export is started. Effect 2:

After the execution is complete, go to the input path and check whether the exported xxx. dmp already exists ............