Solutions to ora-12154 problems connecting to Oracle virtual machines

ConnectionOracle Virtual MachineAppearsOra-12154The knowledge about the solution to the problem is what we will introduce in this article. Speaking of ora-12154 problems, there are a lot of solutions online, the reasons are basically unified: tns or listener Configuration is incorrect. Generally, incorrect listener Configuration rarely occurs. Most people follow the default configuration to "Next", which is basically the service name of orcl. If you can connect to orcl locally, other machines cannot connect to listener.

Most of them are incorrect tns configurations. I encountered a phenomenon: A 2003 virtual machine was created on the machine, and oracle10g was installed on the virtual machine. The default configuration is as follows. The local machine only has an oracle10g client. When I used to connect the local machine to the orcl Service database in the local area network (the same as the local database in the local area network), there is no problem, but the orcl service in the connection virtual machine does not connect, always reports ora-12154 error. In the virtual machine, plsql can connect to the Virtual Machine oracle, but cannot connect to the oracle in the local area network.

Generally, you can solve the problem as follows:

Virtual Machine listener:

 
 

  
  
SID_LIST_LISTENER =
  
  
(SID_LIST =
  
  
(SID_DESC =
  
  
(GLOBAL_DBNAME = test) Custom Service name
  
  
(ORACLE_HOME = E: \ oracle \ product \ 10.2.0 \ db_1) db_home
  
  
(SID_NAME = test)
  
  
 
  
  
)
  
  
(SID_DESC =
  
  
(PROGRAM = extproc)
  
  
(SID_NAME = PLSExtProc)
  
  
(ORACLE_HOME = E: \ oracle \ product \ 10.2.0 \ db_1) # This Service ensures that you can use external processes, such as C Programs.
  
  
)
  
  
)
 
 

Local tns:

 
 

  
  
ORCL_XNJ =
  
  
(DESCRIPTION =
  
  
(ADDRESS_LIST =
  
  
(ADDRESS = (PROTOCOL = TCP) (HOST = 182.12.15.232) (PORT = 1521 ))
  
  
)
  
  
(CONNECT_DATA =
  
  
(SERVICE_NAME = test) corresponds to the Custom Service name
  
  
)
  
  
)
 
 

Connect again to solve the problem!

Summary:Remember, you must start from the simplest reason. Don't see any changes to the number of processes and registries on the Internet as soon as you go up. Think about why the local machine can connect to the network, locate the problem.

About the connection Oracle Virtual Machine Appears ora-12154 problem related knowledge to introduce here, I hope this introduction can be for you to gain something!