Find in this Blog

Thursday, June 18, 2015

HP DATA PROTECTOR SQL> SQL> SQL> ERROR: ORA-01031: insufficient privileges

hp DATA PROTECTOR INTEGRATION ERROR
 
 
 
BR0002I BRARCHIVE 7.10 (39)
BR0006I Start of offline redolog processing: aeqtjfza.sve 2015-06-18 10.44.38
BR0484I BRARCHIVE log file: G:\oracle\GPQ\saparch\aeqtjfza.sve
BR0280I BRARCHIVE time stamp: 2015-06-18 10.44.43
BR0301W SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT system/*********'
ORA-01017: invalid username/password; logon denied
BR0310W Connect to database instance GPQ failed

BR0101I Parameters
Name                           Value
oracle_sid                     GPQ
oracle_home                    D:\oracle\GPQ\11203
oracle_profile                 D:\oracle\GPQ\11203\database\initGPQ.ora
sapdata_home                   G:\oracle\GPQ
sap_profile                    D:\oracle\GPQ\11203\database\initGPQ.sap
backup_dev_type                util_file
system_info                    SYSTEM TEST-SERVERWindows 6.0 Build 6001 Service Pack 1 AMD64
oracle_info                    GPQ 11.2.0.3.0 8192 0 0    0
make_info                      NTAMD64 OCI_10201_SHARE May 17 2011
command_line                   D:\usr\sap\GPQ\SYS\exe\uc\NTAMD64\brarchive.exe -c -u system/*********
BR0280I BRARCHIVE time stamp: 2015-06-18 10.44.49
BR0301W SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT system/*********'
ORA-01017: invalid username/password; logon denied
BR0310W Connect to database instance GPQ failed
BR0278W Command output of 'D:\oracle\GPQ\11203\BIN\sqlplus /nolog < G:\oracle\GPQ\saparch\.aeqtjfza.spi':

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 18 10:44:49 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
SQL> SQL> SQL> ERROR:
ORA-01031: insufficient privileges


SQL>
SQL> ORA-01012: not logged on
SQL>
BR0280I BRARCHIVE time stamp: 2015-06-18 10.44.49
BR0279W Return code from 'D:\oracle\GPQ\11203\BIN\sqlplus /nolog < G:\oracle\GPQ\saparch\.aeqtjfza.spi': 0
BR0302W SQLPLUS call for database instance GPQ failed
BR0323W 'Archive log list' for database instance GPQ failed

BR0545W Database reset logs ID not found
BR0013W No offline redolog files found for processing
BR0280I BRARCHIVE time stamp: 2015-06-18 10.44.59
BR0301W SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT system/*********'
ORA-01017: invalid username/password; logon denied
BR0310W Connect to database instance GPQ failed


BR0007I End of offline redolog processing: aeqtjfza.sve 2015-06-18 10.44.52
BR0280I BRARCHIVE time stamp: 2015-06-18 10.44.59
BR0004I BRARCHIVE completed successfully with warnings

 
 
Solution:
 
 Either re install or update the Client from Data protector.
 
[Normal]  Starting installation session on Thursday, June 18, 2015, 10:58:41 AM...
[Normal]  Getting list of clients for installation...
[Normal]  Done.
[Normal]  Expanding and checking clients to be installed...
[Normal]  Data Protector is already installed on the remote computer, updating it...
[Normal]  Starting installation on client test-server at Thursday, June 18, 2015, 10:58:41 AM...
[Normal] <test-server>   Reinstalling Core...
[Normal] <test-server>   Reinstall of Core succeeded.
[Normal] <test-server>   Reinstalling Core Technology Stack...
[Normal] <test-server>   Reinstall of Core Technology Stack succeeded.
[Normal] <test-server>   Reinstalling Integrations...
[Normal] <test-server>   Reinstall of Integrations succeeded.
[Normal] <test-server>   Reinstalling Automatic Disaster Recovery...
[Normal] <test-server>   Reinstall of Automatic Disaster Recovery succeeded.
[Normal] <test-server>   Reinstalling User Interface...
[Normal] <test-server>   Reinstall of User Interface succeeded.
[Normal] <test-server>   Reinstalling Disk Agent...
[Normal] <test-server>   Reinstall of Disk Agent succeeded.
[Normal] <test-server>   Reinstalling English Documentation (Guides, Help)...
[Normal] <test-server>   Reinstall of English Documentation (Guides, Help) succeeded.
[Normal] <test-server>   Reinstalling General Media Agent...
[Normal] <test-server>   Reinstall of General Media Agent succeeded.
[Normal] <test-server>   Reinstalling Manager-of-Managers User Interface...
[Normal] <test-server>   Reinstall of Manager-of-Managers User Interface succeeded.
[Normal] <test-server>   Reinstalling Oracle Integration...
[Normal] <test-server>   Reinstall of Oracle Integration succeeded.
[Normal] <test-server>   Reinstalling SAP R/3 Integration...
[Normal] <test-server>   Reinstall of SAP R/3 Integration succeeded.
[Normal]  Starting installation/update for client system test-server at TEST.TEST.local.
[Normal]  Update of client system test-server completed.
[Normal]  Installation session finished on Thursday, June 18, 2015, 11:06:20 AM.


============================================================================
                      Session completed successfully!
============================================================================

  1.  Check the backing.exe is existing in kernel directory
/usr/sap/sid/SYS/exe/NTAMD64/baclint.exe 
 
Check the system user status.
if its locked status unlock it.
 
SQL> alter user system account unlock;
User altered.
SQL> commit;
 
2. Check the sqlnet.ora file in both directory
 
 /usr/sap/sid/SYS/profile/oracle
%ORACLE_HOME%network/admin/
 
3. keep the same sqlnet file on both location as well as listener file also should be the same configuration.

4. Check the OS level permission for above files and the folders.
 
Thanks
Yoonus
 
 

No comments:

Post a Comment

Ask Your Questions ?#