rman 04006 error from auxiliary database ora 12514

Tags: rmanoracle11g RAC + DG build process, the duplicate times error in the standby library is as follows:[[Emailprotected]:/u01/app/oracle/11.2/db_1/dbs] $rman targetsys/[emailprotected] auxiliarysys/[emailprotected]nocatalog recoverymanager:release 11.2.0.4.0-productiononfriabc2117:33:01xxxx Copyright (c) 1982,2011,Oracleand/oritsaffiliates.Allrights Reserved. connectedtotargetdatabase:racdb (dbid=93846

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,20

1. The following error occurred: Ora-12541:tns:no Listener, as shown in:The reason for the error is that we do not have the Listener listener service open and the workaround is to open the service in the service as shown in.2. The following error occurred: Ora-

1. The following error occurred: Ora-12541:tns:no Listener, as shown in:The reason for the error is that we do not have the Listener listener service open and the workaround is to open the service in the service as shown in.2. The following error occurred: Ora-

not started, the service can be started. The usual name: Oracleoradb10g_home1tnslistener: The service corresponds to the%oracle_hoembintnslsnr.exe Ora-12514:tns: The listener is currently unable to recognize the service requested by the link descriptor. For this error, the online approach is usually this: Open:%oracle_hoem%/network/admin/listener.ora file

= extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = D: oracleproduct10.1.0db _ 1) (SID_NAME = ORACLE) ) ) 4. Save the file and restart TNSListener in the service. OK! Note: You must restart TNSListener, Method: Command mode The Code is as follows: C:> lsnrctl LSNRCTL> stop LSNRCTL> start Done. Another cause of this problem is: Ora-12514: TNS: no listeners Solution: If the TNSListener service i

this problem is: ora-12514:tns: No Listener Solution: Tnslistener Service is not started, the service can be started.The usual name: Oracleoradb10g_home1tnslistener:The service corresponds to the%oracle_hoembintnslsnr.exeOra-12514:tns: The listener is currently unable to recognize the service requested by the link descriptor.For this

Question Prompt Error tip: Error:ora-12514:tns:listener could not resolve service_name given in Connect Workaround: The code is as follows 1. Open 2. Add: The code is as follows (Sid_desc = (global_dbname = Oracle) (Oracle_home = d:oracleproduct10.1.0db_1) (sid_name = Oracle)) 3. Finally becomes: The code follows Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = plsextproc) (Oracle_home = d:oracleprod

Oracle Database Backup export, error: ORA-12514 resolved connection Oracle 10g error: ORA-12514: TNS: Listeners currently unable to recognize requests in the connection Descriptor Solu

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/80/59/wKioL1c-iH3zuxv0AABBTPL_DDI325.png "title=" 14e02871897fcdf940369e7792fdef8b.png "alt=" Wkiol1c-ih3zuxv0aabbtpl_ddi325.png "/>Error, such as, first log on to the database server, start the database, found that the database is started, monitoring is also i

/dbhome_1/dbs/orapwoelora ' auxiliary format '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwoelora2 ' targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora.ora ' auxiliary format '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora2.ora '; SQL Clone "alter system set spfile= '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora2.

and Real Application testing optionssql>sql> create SPFile from pfile= '/oracle/pfile.12 '; File created. Sql> Startup Nomountoracle instance started. Total System Global area 1453092864 bytesfixed size 2213416 bytesvariable size 855640536 bytesdatabase buffers 587202 560 Bytesredo Buffers 8036352 bytessql>Then re-Rman quit login to perform the alter operation, you can alter the database mount.[[emailprote

Solutions to RMAN connection to secondary database ORA-04031 An error occurred while connecting to the secondary instance when Oracle 10 Gb built dg to use rman to copy the database. The error