GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

OGG-00868 Extract ORA-01017: invalid username/password in ASM sys user

edited Jul 15, 2016 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi All,

My environment is Oracle RAC 11gR2 with 2 nodes with ASM running in AIX.. Golden Gate is 12c version.

I added an entry into tnsnames.ora for ASM.

I created an extract group but since I have ASM, in extract TRANLOGOPTIONS parameter  I wanted to use '\' as 'passwor\*d' because I do not have sys password for ASM instance.

Instead of using :

TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD passwor*d

How can I use '\' as 'passwor\*d' in example above without informing the sys sysasm password?

Error when I started extract in ext report is: ERROR   OGG-00868  Establishing ASM session for login user sys: (1017) ORA-01017: invalid username/password; logon denied.

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

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