Oracle BRtools Backup issue

[Former Member]

Hi Experts,

I am trying to take backup using BRtools on Disk

Platform - Windows2003

Database - Oracle 10.2G

But i am getting an error while initiating the Backup.

this is what i am doing

selecting 4 - Backup and database copy

Selecting 1 = Database backup

i get this screen

1 - BRBACKUP profile (profile) ....... [initBIW.sap]

2 - Backup device type (device) ...... [disk]

3 # Tape volumes for backup (volume) . []

4 # BACKINT/Mount profile (parfile) .. []

5 - Database user/password (user) .... [/]

6 - Backup type (type) ............... [offline]

7 # Disk backup for backup (backup) .. [no]

8 # Delete disk backup (delete) ...... [no]

9 ~ Files for backup (mode) .......... [all]

i did continue

again continued

i get this error

BR0301E SQL error -12641 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-12641: Authentication service failed to initialize

BR0310E Connect to database instance BIW failed

BR0280I BRBACKUP time stamp: 2009-09-01 12.53.19

BR0301E SQL error -12641 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-12641: Authentication service failed to initialize

BR0310E Connect to database instance BIW failed

BR0056I End of database backup: bebjhobn.afd 2009-09-01 12.53.19

BR0280I BRBACKUP time stamp: 2009-09-01 12.53.19

BR0054I BRBACKUP terminated with errors

BR0292I Execution of BRBACKUP finished with return code 3

I tried note 134592 and executed the sapdba_role.sql and in the sapdba_role.log, it says all successful.

But still same issue

This is the first time i am using brtools and i dont know what changes i should make in the selection panel.

do i need to changed the user name in option 5. if yes what user and password should i mention.

Please guide me in this.

It will be great if you give me the step by step instruction to take backup in Disk

Thanks

Prakash

[Former Member · Accepted solution]

Hi ,

In the $ORACLE_HOME/network/admin/sqlnet.ora file SQLNET.AUTHENTICATION_SERVICES is set to ALL and Secure Network Services has not been used.

Whenever Secure Network Services is not being used, that is you try to logon to database using SQLNet from database host computer using above command, then it explicitly disallow applications from initiating SQLNet connect requests with authentication services. So to allow connection through SQLNet it is needed to disable authentication services while still allowing normal SQLNet connections.

Soltion of The Problem:

-

---

Issuing the above command from another computer rather than host will not produce the error because in that case secure network services will be used.

To disable SQLNet authentication services while still allowing normal SQLNet connections you can set in $ORACLE_HOME/network/admin/sqlnet.ora the following line,

SQLNET.AUTHENTICATION_SERVICES =(NONE)

Now try to connect and it will be ok.please check if this works fine.

You can refer SAP note 620540 also for the same issue.

Edited by: mohit gupta on Sep 1, 2009 10:46 AM

[Former Member · Accepted solution]

Thank you very much for quick reply. i changed to "none" in sqlnet

now i get a different error.

BR0051I BRBACKUP 7.00 (40)

BR0055I Start of database backup: bebjhwol.afd 2009-09-01 14.29.03

BR0484I BRBACKUP log file: D:\oracle\BIW\sapbackup\bebjhwol.afd

BR0278E Command output of 'D:\oracle\BIW\102\BIN\sqlplus /nolog < D:\oracle\BIW\

sapbackup\.bebjhwol.spi':

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Sep 1 14:29:03 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> ERROR:

ORA-01031: insufficient privileges

SQL>

SQL> SP2-0640: Not connected

SQL>

BR0280I BRBACKUP time stamp: 2009-09-01 14.29.03

BR0279E Return code from 'D:\oracle\BIW\102\BIN\sqlplus /nolog < D:\oracle\BIW\s

apbackup\.bebjhwol.spi': 0

BR0302E SQLPLUS call for database instance BIW failed

BR0303E Determination of Oracle version failed

BR0056I End of database backup: bebjhwol.afd 2009-09-01 14.29.03

BR0280I BRBACKUP time stamp: 2009-09-01 14.29.03

BR0054I BRBACKUP terminated with errors

I know i missing something, because this is newly installed server.

Please help me resolving this issue.

Thanks

Prakash

[Former Member · Accepted solution]

Hi Prakash,

What is the user used to login to the system.

The user should be <sid>adm.

Note 620540 - Authentication Troubleshooting Guide

Regards

Ashok Dalai

Edited by: Ashok Dalai on Sep 1, 2009 11:38 AM

[Former Member · Accepted solution]

Thanx you Ashok.... i logged in by SIDadm and now i am able to take backup....

Thanks for all you guys for the Quick replies.

Prakash