GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

ERROR OGG-00868 Attaching to ASM server ASM: (12514) ORA-12514: TNS:listener does not currently know

edited May 28, 2012 1:32AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓
hi, I could not proceed with migration test , because I keep getting my extract abended after ora-12514 connection to oralce asm.

ERROR OGG-00868 Attaching to ASM server ASM: (12514) ORA-12514: TNS:listener does not curr
ently know of service requested in connect descriptor.
I have tnsnames.ora entry for asm, and listener. ora also.

LISTENER_ASM =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.xxxxxx)(PORT = 1529))
)
)

SID_LIST_LISTENER_ASM =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=ASM)
(ORACLE_HOME = /u01/orahome_asm)
(SID_NAME =+ASM)
)
)

Tnsnames.ora entry:
ASM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.xxxx)(PORT = 1529))
)
(CONNECT_DATA =
(SERVICE_NAME =+ASM)

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center