Oracle10g an old project, database into not to go, suddenly up sqlplus input password login, such as for a long time, suggest a 12560 error, could you tell me how to solve, bosses, this should be

CodePudding user response:

Up sqlplus "/as sysdba"

Look at the above, can go in?


Before your experiment, cut a figure,

CodePudding user response:

reference 1st floor selling fruit net reply:

up sqlplus "/as sysdba"

Look at the above, can go in?


Before your experiment, cut a figure,

Good webmaster
Listener:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=D: \ oracle \ product \ 10.2.0 \ db_1)
(the PROGRAM=extproc)
)
)

The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=XXXXXXXX) (1521) PORT=)
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC0))
)
)
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

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

EXTPROC_CONNECTION_DATA=https://bbs.csdn.net/topics/
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1))
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SID=PLSExtProc)
(the PRESENTATION=RO)
)
)
__________________________________________
Also used up sqlplus/as sysdba landed on, like normal login, etc. Along while tip 12560

CodePudding user response:

Are you sure you are the listener service normal boot, or you restart the monitor service

CodePudding user response:

reference weixin_40290083 reply: 3/f

are you sure you the listener service normal boot, or you restart the monitor service

This operation at least ten times,,,,