sapconn_role.sql and sapdba_role.sql / CONNECT sapsr3/****** AT PROF_CONN IN SYSOPER MODE' ORA-01031: insufficient privileges

134592 - Import of SAPDBA role (sapdba_role.sql)

C:\Users\XXXX>brconnect -u / -c -f stats -t all
BR0801I BRCONNECT 7.10 (39)
BR0805I Start of BRCONNECT processing: ceqivquo.sta 2015-04-23 19.02.54
BR0252E Function fopen() failed for 'F:\oracle\GPD\sapcheck\ceqivquo.sta' at loc
ation main-11
BR0253E errno 2: No such file or directory
BR0121E Processing of log file F:\oracle\GPD\sapcheck\ceqivquo.sta failed
BR0280I BRCONNECT time stamp: 2015-04-23 19.03.02
BR0301W SQL error -1031 at location brc_dblog_open-1, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('
20150423190254', 'sta', 'GPD', 'ALL', '9999', ' ', 'ceqivquo', '7.10 (39)')'
ORA-01031: insufficient privileges
BR0324W Insertion of database log header failed
BR0806I End of BRCONNECT processing: ceqivquo.sta 2015-04-23 19.03.01
BR0280I BRCONNECT time stamp: 2015-04-23 19.03.02
BR0804I BRCONNECT terminated with errors

Solution:

SQL> grant sapconn, unlimited tablespace to PSAPSR3
  2  ;
grant sapconn, unlimited tablespace to PSAPSR3
                                       *
ERROR at line 1:
ORA-01917: user or role 'PSAPSR3' does not exist

SQL> grant sapconn, unlimited tablespace to SAPSR3;
Grant succeeded.
SQL> COMMIT;
Commit complete.
SQL> grant sYSTEM, unlimited tablespace to SAPSR3;
grant sYSTEM, unlimited tablespace to SAPSR3
      *
ERROR at line 1:
ORA-01919: role 'SYSTEM' does not exist

SQL> grant sysdba, unlimited tablespace to SAPSR3;
Grant succeeded.
SQL> commit;
Commit complete.
SQL>



SQL> grant sysoper to sapsr3;
Grant succeeded.
SQL> grant sapconn to sapsr3
  2  ;
Grant succeeded.
SQL> grant sapdba to sapsr3;
Grant succeeded.
SQL> alter user SAPSR3 default role all;
User altered.
SQL> select grantee, granted_role, default_role
  2        from dba_role_privs
  3         where grantee = 'SAPSR3';
GRANTEE                        GRANTED_ROLE                   DEF
------------------------------ ------------------------------ ---
SAPSR3                         SAPCONN                        YES
SAPSR3                         SAPDBA                         YES
SQL> select * from session_roles;
no rows selected
SQL>

 ====================================================================
D:\usr\sap\GPD\SYS\exe\NTAMD64>sqlplus /nolog @sapconn_role SR3
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 23 19:29:19 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing option
D:\usr\sap\GPD\SYS\exe\NTAMD64>
Output:
Connected.
PL/SQL procedure successfully completed.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded. etc;;;;;;;

================================================
D:\usr\sap\GPD\SYS\exe\NTAMD64>sqlplus /nolog @sapdba_role SR3
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 23 19:39:29 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
D:\usr\sap\GPD\SYS\exe\NTAMD64>

Output:
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.                                                                          
                                                                               
old   1: grant ALL on &User..SDBAH to sapdba
new   1: grant ALL on SAPSR3.SDBAH to sapdba
Grant succeeded.
old   1: grant ALL on &User..SDBAD to sapdba
new   1: grant ALL on SAPSR3.SDBAD to sapdba
Grant succeeded.
old   1: grant ALL on &User..DBAML to sapdba
new   1: grant ALL on SAPSR3.DBAML to sapdba
Grant succeeded.

If database accesses are performed using the database tools BRBACKUP, BRARCHIVE, BRCONNECT, and BRSPACE, the relevant authorizations are missing.

BRBACKUP fails with the following error messages, for example:
BR0051I BRBACKUP 7.00 (20)
BR0055I Start of database backup: bddzbuxf.ant 2009-11-10 10.12.35
BR0280I Time stamp 2009-11-10 10.12.36
BR0301W SQL error -1031 at location BrLicCheck-7
ORA-01031: insufficient privileges
BR0301W SQL error -942 at location BrbDbLogOpen-1
ORA-00942: table or view does not exist
BR0324W Insertion of database log header failed
BR0280I Time stamp 2009-11-10 10.12.37
BR0301E SQL error -1031 at location BrCntrlCopy-1
ORA-01031: insufficient privileges
BR0320E Copying of control file to ... failed
BR0314E Collection of information on database files failed
BR0056I End of database backup: bddzbuxf.ant 2009-11-10 10.12.37
BR0280I Time stamp 2009-11-10 10.12.37
BR0054I BRBACKUP terminated with errors
In relation to table functions, the following errors, for example, can occur in SAP Release 7.40 SP10 or above:
BR0301E SQL error -1031 at location stats_tfun_update-2, SQL statement:
'BEGIN SAP091.UCONRFC_ATTRG (0, 1); END;'
ORA-01031: insufficient privileges
ORA-06512: at "SAP091.UCONRFC_ATTRG", line 1
ORA-06512: at line 1
BR1867E Updating statistics failed for table function SAP091.UCONRFC_ATTR

Other Terms

SAPDBA role, BR*Tools

Reason and Prerequisites

1. You did not create the SAPDBA role during an SAP/Oracle upgrade, as outlined in the upgrade instructions.
2. You use one of the tools mentioned above in a lower SAP release and the database authorizations have not been adjusted.
3. The database grants were deleted.

Solution

Download the SQL script for creating the SAPDBA role from the attachment to this SAP Note (for Oracle 10g: sapdba_role_ora10, for Oracle 11g: sapdba_role_ora11, and for Oracle 12c: sapdba_role_ora12 ). Execute this script as follows (sapdba_role.sql in the current directory):

sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

Where <SAPSCHEMA_ID> is the schema ID of the SAP database user:
- for User SAPR3:      R3
- For the user SAPSR3:     SR3
- for User SAP<SID>:   <SID>
- for User SAP<SID>DB: <SID>DB

Sample call for a standard installation with the schema SAPSR3:

sqlplus /nolog @sapdba_role SR3

and with the schema SAPR3:

sqlplus /nolog @sapdba_role R3

The log file sapdba_role.log is created in the current directory.

Note 1:
----------
The schema ID is not to be confused with the schema name. Therefore, the following call is incorrect:
sqlplus /nolog @sapdba_role SAPSR3

Caution 2
----------
For MCOD systems, the script must be executed for all SAP schemas, for example, for ABAP schemas and Java schemas in a database:
sqlplus /nolog @sapdba_role SR3
sqlplus /nolog @sapdba_role SR3DB

Caution 3
----------
Since non-ABAP systems/schemas (a pure SAP J2EE database, for example) do not contain all of the tables mentioned in the SAPDBA role, the log file will contain error messages, for example:
grant ALL on SAPSR3DB.DBAML to sapdba
                      *
ERROR at line 1:
ORA-00942: table or view does not exist

You can ignore these error messages.

134592 - Import of SAPDBA role (sapdba_role.sql)

 

\Program Files\sapinst_instdir\NW73\SBC\STANDARD\CONTROL.SQL (The system cannot find the file specified)

ERROR 2015-04-22 15:43:52.318
FCO-00141  The JVM reports an exception during execution of class ( com.sap.sdt.ins.component.ora_clone_obr.AdaptControlSqlFile ) and function executeStepClass. DIAGNOSIS: The reported error message from JVM is: java.io.FileNotFoundException: C:\Program Files\sapinst_instdir\NW73\SBC\STANDARD\CONTROL.SQL (The system cannot find the file specified)
 at java.io.FileInputStream.open(Native Method)

Solution:

May be the file got currpted or system cannot generate due to permission issue.

do the manual activities.:

open sql Console.

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Database altered.
SQL>
File location can be found in alert_SID

Copy control file details form that file and create control file and put in to

C:\Program Files\sapinst_instdir\NW73\SBC\STANDARD\

=========================================================

once its competed next error as follows:

Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 2004340736 bytes
Fixed Size      2256544 bytes
Variable Size   1006633312 bytes
Database Buffers   973078528 bytes
Redo Buffers     22372352 bytes
Database mounted.
Database altered.
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORACLE\GPQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

ORA-01109: database not open

Solution:
Run below

SQL>recover database;
media recovery completed;
SQL>alter database open;


Some steps need to be skipped .
edit keydb.xml  seArch ERORR on CDATA

DISABLE OR ENABLE SMARTFORM EDITOR

Run the Below

Program: RSCPSETEDITOR

                         742662 - MS Word as Editor in SAPscript and Smart Forms            


Thanks
Yoonus

SQL error 28001 when accessing table "PAKDATBUF".

What happened?
    Error Text of the Database: "ORA-28001: the password has expired"

What can you do?
    Note which actions and input led to the error.
    For further help in handling the problem, contact your SAP administrator
    .
    You can use the ABAP dump analysis transaction ST22 to view and manage
    termination messages, in particular for long term reference.
    Note which actions and input led to the error.
    For further help in handling the problem, contact your SAP administrator
    .
    You can use the ABAP dump analysis transaction ST22 to view and manage
    termination messages, in particular for long term reference.

Solution:

Check  the database user status. Might expired.

sapserver.cmd not recognize as internal or external program

When I click on sapserver.cmd from the folder according to my platform, it doesn't prompt me for drive and SID. It just blink once and goes away, nothing else

Input Error: There is no file extension in "C:\sap".
'C:\Users\ADMINI~1\AppData\Local\Temp\2\o11inst.cmd' is not recognized as an int
ernal or external command,
operable program or batch file.
'C:\sap' is not recognized as an internal or external command,
operable program or batch file.
C:\sap dump\ORA\Oracle_11g\Oracle_11g\database\SAP>

Solution:

Rename the folder without space
 where the Oracle dump located.

Error: Remote access to the NetWeaver Administrator is forbidden. See SAP Note 1451753 for details.

Error: Remote access to the NetWeaver Administrator is forbidden. See SAP Note 1451753 for details.

Refer this note:1451753 - Filtering of administration requests for AS Java            


Add the entry on icm_filter_rules.txt

If you do not want to restrict access to the administration requests to certain clients, remove the lines from the file or turn the lines into a comment:

           #if %{REMOTE_ADDR} !stricmp 127.0.0.1 [AND]
           #if %{REMOTE_ADDR} !stricmp ::1
           #RegIRedirectUrl ^/webdynpro/resources/sap. com/tc~lm~itsam~ui~mainframe~wd/(.)*$ /nwa/remote_access_error [QSA]

Thanks
Yoonus

Node 'bootstrap' failed with exit code 558.

F ********************************************************************************
F Process snapshot started with pid 3864
F ********************************************************************************
F [Thr 3368] *** LOG => Process snapshot started (pid 3864).
  [Thr 3368] *** LOG => Process snapshot running (pid 3864).
  [Thr 3368] *** LOG => SAP Start Service (pid 1832) connected.
F [Thr 3368] *** LOG => SAP Start Service (pid 1832) disconnected.
F 
F [Thr 732] Fri Apr 03 04:13:22 2015
F [Thr 732] *** LOG => Signal 13 SIGCHLD.
F 
F [Thr 3368] Fri Apr 03 04:13:22 2015
F [Thr 3368] *** LOG => Process snapshot stopped (pid 3864).
F [Thr 3368] *** LOG => Instance state is "Synchronizing binaries" (STOPPING @ 0, INACTIVE).
F [Thr 3368] *** LOG => Run level 2 completed.
F [Thr 3368] *** LOG => Instance state is "Some processes failed" (STOPPED @ 0, INACTIVE).
I [Thr 3368] MPI: dynamic quotas disabled.
I [Thr 3368] MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%
F 
F ********************************************************************************
F *** ERROR => Node 'bootstrap' failed with exit code 558.
F ***
F *** Please see section 'Failures in the 'synchronizing binaries' phase'
  *** in SAP Note 1316652 for additional information and trouble shooting advice.
  ********************************************************************************
F 
F [Thr 3368] *** LOG => exiting (exitcode 22002, retcode 1).


Solution:

Start the Oracle Listener service.


Thanks
Yoonus