Log in to Oracle SQL Developer

650) this.width=650; "Width=" 501 "height=" 228 "title=" Od.png "style=" width:648px;height:321px; "alt=" wKiom1mC49_ Ijp8gaacllfoyuec759.png-wh_50 "src=" Https://s1.51cto.com/wyfs02/M02/9D/A1/wKiom1mC49_ijP8gAACLLFoyUEc759.png-wh _500x0-wm_3-wmp_4-s_211760162.png "/>

If a ORA-12514 error occurs, you need to locate the file F:\app\khe\product\11.2.0\dbhome_3\NETWORK\ADMIN\listener.ora

==============================

Open the file and add the red part up

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = F:\app\khe\product\11.2.0\dbhome_3)
(program = Extproc)
(Envs = "Extproc_dlls=only:f:\app\khe\product\11.2.0\dbhome_3\bin\oraclr11.dll")
)


(Sid_desc =
(Global_dbname = myoracle)
(Oracle_home = F:\app\khe\product\11.2.0\dbhome_3)
(Sid_name = myoracle)
)

)

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP) (HOST = D305875.asiapacific.epicor.net) (PORT = 1522))
)
)

Adr_base_listener = F:\app\khe

==============================

Which, global_dbname, can be queried by the statement

SELECT * FROM Global_name query

Oracle_home is the same as in the previous section. Sid_name is the same as global_dbname.

Restart the listener service.

In the signed-in form, HostName and Port are the same as the blue ones, and if this is the machine, localhost can be filled in. Service name is the same as global_dbname.

This article is from the "Epicor, Magento" blog, so be sure to keep this source http://3154408.blog.51cto.com/3144408/1953384

Log in to Oracle SQL Developer