An error occurred while executing the startup command under rman, "ORA-12514: TNS: The Listener is currently unable to recognize the Service requested in the connection descriptor"

 

An example of "ORA-12514: TNS: The Listener currently cannot identify the service error requested in the connection descriptor" appears today in the exercise book, as shown below:

C: \> RMAN target sys/orcl @ demo

Recovery MANAGER: Release 10.2.0.1.0-production on Wednesday October 1 15:04:00 2008

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect to the target database: Demo (dbid = 3408444956)

RMAN> shutdown immediate

Use the target database control file to replace the recovery directory
Database closed
Database uninstalled
Oracle instance disabled

RMAN> startup

RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: startup command (on 15:04:50) failed
ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor

RMAN>

 

I did not find a solution after checking it on the internet for a long time. Later I discussed the problem with my friends in a group. It turned out that my listener. ora file had a problem.

The content automatically created by Oracle is:

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Program = EXTPROC)
)
)

After modification:

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = demo)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
)
)

After restarting the listening service, you can:

C: \> RMAN target sys/orcl @ demo

Recovery MANAGER: Release 10.2.0.1.0-production on Wednesday October 1 15:32:36 2008

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect to the target database: Demo (dbid = 3408444956)

RMAN> shutdown immediate

Use the target database control file to replace the recovery directory
Database closed
Database uninstalled
Oracle instance disabled

RMAN> startup

Connected to the target database (not started)
Oracle instance started
Database loaded
Database opened

The system's global region consists of 167772160 bytes.

Fixed size 1247900 bytes
Variable Size 75498852 bytes
Database buffers: 88080384 bytes
Redo buffers: 2945024 bytes

RMAN>