Technology Stack - EBS (MOSC)

MOSC Banner

RMAN-04006: error from auxiliary database: ORA-12504: TNS:listener was not given the SERVICE_NAME in

edited Aug 20, 2021 11:53AM in Technology Stack - EBS (MOSC) 5 commentsAnswered ✓

Hello All,

Thanks for your concern.

When I used RMAN that want to duplicate data from target database to auxiliary database, I got a problem as below:

Does anyboby has suggestions? Thanks.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-04006: error from auxiliary database: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Here are my servers' settings:

  • Target Server:
    • Oracle version: Oracle 12c
    • OS version: RHEL 7.4
    • Hostname: ERPBK2.domain.com
    • Oracle database SID: ERPBK2
  • Auxiliary Server:
    • Oracle version: Oracle 12c
    • OS version: RHEL 7.4
    • Hostname: ERPTAP2.domain.com
    • Oracle database SID:TEST

Target's listener.ora

Target's tnsnames.ora

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS TechStack Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center