Ora prompt for connection to Oracle11.2.0.1

Just installed Oracle11gR2, and there was a problem. Thanks to the previous experience, I 'd like to share with you the installation sequence. The Oracle11gR264Bit server, ArcSDE, oracle11gR232Bit client but prompts ora-12514 no listener error when establishing PLSQL connection solution: Because my machine already has fixed I

Just installed Oracle11gR2, and there was a problem. Thanks to the previous experience, I 'd like to share with you the installation sequence: Oracle11gR2 64Bit server, ArcSDE, oracle11gR2 32Bit client but prompts ora-12514 no listener error while establishing PL/SQL connection solution: Because my machine already has fixed I

I have just installed Oracle11gR2 and the problem has occurred. Thanks to the previous experience, I 'd like to share it with you.

Installation sequence: Oracle11gR2 64Bit server, ArcSDE, Oracle11gR2 32Bit Client

However, when a PL/SQL connection is established, the system prompts that the ora-12514 has no listener error.

Solution: Because my machine already has a fixed IP address, and the related Listener file and TNSName file record localhost

1: Change the localhost of the two files to the IP address of the user machine.

2: Modify the Hosts file of the operating system to map the IP address of the user's machine to localhost.

After this problem is solved, the connection has a new problem ora-12541

This is strange. It seems that there are few things to view the listener file.

# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )    (SID_DESC =      (GLOBAL_DBANAME = orcl)      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)      (SID_NAME = orcl)    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.111)(PORT = 1521))    )  )ADR_BASE_LISTENER = D:\app\Administrator

However, none are installed by default.

(SID_DESC =      (GLOBAL_DBANAME = orcl)      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)      (SID_NAME = orcl)    )

So you can add it, and modify your SID_NAME, GLOBAL_NAME, and ORACLE_HOME.