Announcement Banner
UNSOLVED

tsamuel0905

updated

12 years ago

T

tsamuel0905

2 Intern

•

136 Posts

0

3334

March 19th, 2015 23:00

DB Configuration

Hi All,

While configuring RMAN Backup, I am getting error as ORA-01017: Invalid username/password; logon denied.

Steps Followed:

1. Same credential working when i am loging into DB directly as "sqlplus 'usernam/passwprd'"

2. Installed NMDA

3. Soft link created as "ln -s /usr/lib/libnsrora.so libobk.so"

4. Registered nmda for oracle as " nsrorara -i"

No luck. Am I missed anything? Please advice asap.

Thanks,

Samuel

  • tsamuel0905

    2 Intern

    •

    136 Posts

    2197

    0

    Posted March 20th, 2015 00:00

    Can I have the path for RMAN Script?

    Moreover I am in the "Specify the Oracle Information" Steps in Client Backup Configuration wizard.

    Please let me know the path & file for RMAN Script.

    Thanks,

    Samuel Thomas

  • crazyrov

    6 Operator

    •

    1319 Posts

    2197

    0

    Posted March 20th, 2015 00:00

    oh ok, so you on the client configuration wizard. You might have to gvive the sysdba credentials here.

  • crazyrov

    6 Operator

    •

    1319 Posts

    2189

    0

    Posted March 20th, 2015 00:00

    Does your RMAN script contain the credentials that your have mentioned above ?

  • tsamuel0905

    2 Intern

    •

    136 Posts

    2197

    0

    Posted March 20th, 2015 01:00

    Yes I gave below details..

    1. Oracle Home Directory

    2. Oracle TNS directory

    DB Credentials as,

    1. username

    2. Password

    3. Net service name

  • tsamuel0905

    2 Intern

    •

    136 Posts

    2197

    0

    Posted March 20th, 2015 01:00

    Yes I am very sure about case sensitive.. But i am using RMAN user to do configuration... Even for other DB's i used to have RMAN as a user.. I believe there wouldn't be any issue with user..

  • crazyrov

    6 Operator

    •

    1319 Posts

    2197

    0

    Posted March 20th, 2015 01:00

    For the user name did you try giving sysdba credentials, also ensure that the net service name provided is correct and case sensitive.

  • crazyrov

    6 Operator

    •

    1319 Posts

    2197

    0

    Posted March 20th, 2015 04:00

    Just to be sure can you try using the sysdba user, i had similar issue. Incase you are not using the wizard for the backup configuration the other user usually works.

  • tsamuel0905

    2 Intern

    •

    136 Posts

    1279

    0

    Posted March 21st, 2015 22:00

    @medhatrizk, I tried but still no luck..  any other suggestion pls?

  • tsamuel0905

    2 Intern

    •

    136 Posts

    1361

    0

    Posted March 21st, 2015 23:00

    crazyrov actually i am trying with user having SYSDBA permission. But still i am missing something there..

    FYI, I can log in to the DBA with those credentials from OS.. So there was no problem with oracle user credentials..

  • tsamuel0905

    2 Intern

    •

    136 Posts

    1361

    1

    Posted March 22nd, 2015 02:00

    Hi All,

    I got solution for this issue. That I was able to login with server but not able to connect with RMAN utility.

    Requested DBA to create a new user with complete permission & tried. Now Its working fine.

    Command to connect with RMAN utility,

    $rman target username/password@tns_service_name

    Thanks again to all..