Oracle Exception Handling Rollup 1, Plsql cannot connect
Install Oracle, intermediate input password, user is: sys,pass: Enter the password.
Connect to the database, it is recommended to create a new user, preferably not directly with the SYS
After installation, you need to configure the net Configration Assistant to connect via PL/SQL
Ensure that the service monitoring service is started
2. Encountering Oracle error 12514
Solution:
1) Find the Listening file
C:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
Open it:
# Listener.ora Network Configuration file:c:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration Tools. LISTENER = (description_list = ( DESCRIPTION = ( address = (PROTOCOL = IPC) (KEY = EXTPROC1521)) (address = (PROTOCOL = TCP) (HOST = win-l7md6epho8q.localdomain) (PORT = 1521)))) Adr_base_listener = C:\Oracle
Modified to:
# Listener.ora Network Configuration file:c:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration Tools. LISTENER = (description_list = ( DESCRIPTION = ( address = (PROTOCOL = IPC) (KEY = EXTPROC1521)) (address = (PROTOCOL = TCP) (HOST = win-l7md6epho8q.localdomain) (PORT = 1521)) ) (Sid_desc = (global_dbname = ORCL) (oracle_home = \product\11.2.0\dbhome_1) (sid_name = ORCL) ) /c6> ) Adr_base_listener = C:\Oracle
Oracle_home:oracle installation directory
Global_dbname: Instance name, default is ORCL
2) Restart the listener, and of course you can restart the Windows service
Open cmd, execute:
Lsnrctl Stop //shutdown LSNRCTL start// start
3, Oracle 11g If you encounter this problem 12514
Solution:
1, Sid_name to the specific instance name, such as: ORCL
2. Delete (program = Extproc)
# Listener.ora Network Configuration File:d:\oracle\product\11.2.0\dbhome_1\network\admin\listener.Ora# Generated by Oracle configuration tools.Sid_list_listener= (Sid_list = (Sid_desc =(sid_name = ORCL)(Oracle_home = D:\oracle\product\11.2.0\dbhome_1)(program = extproc)(Envs = "Extproc_dlls=only:d:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")) )SID_LIST_ORCL= (Sid_list = (Sid_desc =(sid_name = clrextproc)(Oracle_home = D:\oracle\product\11.2.0\dbhome_1)(program = extproc)(Envs = "Extproc_dlls=only:d:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")) )LISTENER= (Description_list = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.134) (PORT = 1521)))Adr_base_listener= D:\oracle
4, IMP Restore database times wrong: Error 12514
IMP-00058: Encountered ORACLE error 12514ora-12514: TNS: Listener currently does not recognize service requested in connection descriptor imp-00000: Failed to terminate import successfully
Note If the imported instance name is correct, refer to the solution above.
Oracle Exception Handling Rollup