Oracle to monitor won't start
Linster. Ora below

LISTENER1=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=xin) (1521) PORT=)
)
)

The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1521) PORT=)
)
)

ADR_BASE_LISTENER=G: \ app \ zhangsan \ product \ 12.1.0 \ dbhome_1 \ log
Can't use 127.0.0.1 and host names
Command line manually start the monitoring service is not as shown in figure:

Tnsnames. Ora below

ORACLR_CONNECTION_DATA=https://bbs.csdn.net/topics/
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521))
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SID=CLRExtProc)
(the PRESENTATION=RO)
)
)

LISTENER_ORCL=
(ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1521) PORT=)


Former=
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1521) PORT=)
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SERVICE_NAME=former)
)
)

The strange thing is using SQL plus can login user

For a great god

CodePudding user response:

Tnsnames is client configuration, the listener. Ora is the server configuration, you can back up sqlplus connected to the database, because the connection way you have bypassed the listening, also can so go on the server,

You put the monitor configuration file listener. Ora to deleted, I estimate that you solved the problem of

CodePudding user response:

You have a static listening to
LISTENER1=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=xin) (1521) PORT=)
)
)

The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1521) PORT=)
)
)
Delete the

With the
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=former)
(SID_NAME=former)
(ORACLE_HOME=D: \ Oracle_12C \ Administrator \ product \ 12.2.0 \ dbhome_1)
)

SID_NAME GLOBAL_DBNAME database name, instance name ORACLE_HOME path

Then did you see inside your system environment variable Oracle_home

Basically, these should be no problem

CodePudding user response:

Did you first open the Oracle server is opened, determine the query again after open the configuration folder; I suggest you have a static listening:
# listener. Ora Network Configuration File: D: \ app \ admin \ 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: \ \ admin \ product \ app 11.2.0 \ dbhome_1)
(the PROGRAM=extproc)
(ENVS="EXTPROC_DLLS=ONLY: D: \ app \ admin \ product \ 11.2.0 \ dbhome_1 \ bin \ oraclr11 DLL")
)
)

The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521))
(ADDRESS=(TCP) PROTOCOL=(HOST=localhost) (1521) PORT=)
)
)

ADR_BASE_LISTENER=D: \ app \ admin

CodePudding user response:

I was the same problem did not solve
According to the above 3 methods are tried, useless
Haven't solve the problem of the original poster is solved

CodePudding user response:

Is at the same time, there are several different oracle database on the server version, or oracle server and the client at the same time, so you can check the path set, right

CodePudding user response:

The command line, use netca reconfiguration,

CodePudding user response:

You try to open your task manager