64-bit Win7 under Pl/sql cannot connect Oracle Resolution _ORACLE

1, Pl/sql Cannot connect Oracle (ORA 12154:tns: Unable to resolve the specified connection identifier)

Workaround: Pl/sql cannot be installed under the Program Files folder, to be installed under the Program Files folders x86

2. Pl/sql cannot connect to remote Oracle (ORA-12514:TNS: The listener does not currently recognize the service requested in the connection descriptor)

Solution: ① under Linux to find the Oracle directory of Listener.ora, with VI edit
② The following red is added, where global_dbname is consistent with the client-configured Oracle Network name, Sid_name to be consistent with the local database instance name

Copy Code code as follows:

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Plsextproc)
(Oracle_home =/u01/app/oracle/product/10.2.0/db_1)
(program = Extproc)
)
(sid_desc=
(GLOBAL_DBNAME=LXORCL)
(Oracle_home =/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME=ORCL)
)
)

3. Start and shutdown of Oracle Listener program

Copy Code code as follows:

Start: Lsnrctl start
OFF: Lsnrctl stop
Status: Lsnrctl Status