on 05-03-2011 4:42 PM
Hi,
I want to management and monitoring to a oracle remote database (JAVA database). I´ve made the connection from dbacockpit and I´ve put the user of schema sapsr3db and the connection it´s succesfully established
-- MESSAGE Database connection Java_db established successfully
But I want to schedule the administrative actions for DB, via DB13 I´ve always the next message error:
Parameters:-u / -jid LOG__20110501373222 -sid D10 -c force -p initepd.sap -sd
BR0002I BRARCHIVE 7.00 (52)
BR0252E Function fopen() failed for 'F:oracleorasap102databaseinitepd.sap' at location BrInitSapRead-1
BR0253E errno 13: Permission denied
BR0159E Error reading BR*Tools profile F:oracleorasap102databaseinitepd.sap
BR0280I BRARCHIVE time stamp: 2011-05-01
BR0301W SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310W Connect to database instance D10 failed
BR0007I End of offline redo log processing: aefuiaiw.log 2011-05-01
BR0280I BRARCHIVE time stamp: 2011-05-01
BR0005I BRARCHIVE terminated with errors
External program terminated with exit code 3
BRARCHIVE returned error status E
I´ve found several notes with this error 480266 , 400241, 113747, 651351 but I´m not sure that It´s the same error.
More thanks.
Looks like the problem described in
Note 1292339 - 10.2: DBUA changes file access authorizations during upgrade
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check at OS level in Administrative tools---> computer management.
What are the groups is available and compare both user ids sidadm and Sapservicesid
Is the both users sidadm and SAPService<SID> in the backup operators group?
if SAPService<SID> user is not there you have to this user under backup operators group.
Thanks
Siva
Hi Ruben,
You faced with the two major problems; first one is OPS$ mechanism and the second one is permission on file system. I assume that you are running on a standalone gateway installation over the Java server and have <sid>adm and SAPService<SID> users, belongs to the standalone gateway installation. Please find the answers, below;
In order to solve the permission problem;
1) Logon with "<sid>adm" gateway installation user, to the system,
2) Open "F:\oracle\orasap\102\database\initepd.sap" with a wordpad,
3) Copy all the content of the file,
4) Rename "initepd.sap" file to "initepd.sap.orig",
5) Create a new file with "initEPD.sap" under "F:\oracle\orasap\102\database\" and paste clipboard in it,
6) Then, save the file,
7) Probably, you will face with this error on "initEPD.dba" file, also. If you face this error, then apply steps 1 to 6 for "initEPD.dba", also,
😎 If you face with this problem on "sapcheck" folder, give full permission to the <sid>adm and SAPService<SID> gateway installation users.
It should solve the permission problem.
In order to solve the OPS$ mechanism problem;
1) You should create a new "SAPUSER" table and synonym, belongs to the gateway installation users, as below;
CREATE USER "OPS$<HOSTNAME>\<SID>ADM" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
CREATE USER "OPS$<HOSTNAME>\SAPSERVICE<SID>" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
CREATE TABLE "OPS$<HOSTNAME>\<SID>ADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
CREATE SYNONYM "OPS$<HOSTNAME>\SAPSERVICE<SID>".SAPUSER FOR "OPS$<HOSTNAME>\<SID>ADM".SAPUSER;
GRANT SELECT, UPDATE ON "OPS$<HOSTNAME>\<SID>ADM".SAPUSER TO "OPS$<HOSTNAME>\SAPSERVICE<SID>";
GRANT CONNECT, RESOURCE TO "OPS$<HOSTNAME>\SAPSERVICE<SID>";
GRANT CONNECT, RESOURCE TO "OPS$<HOSTNAME>\<SID>ADM";
INSERT INTO "OPS$<HOSTNAME>\<SID>ADM".SAPUSER VALUES ('<Java database owner (Ex:SAPSR3DB)>', '<Password>');
COMMIT;
Don't forget to execute commands, below, for gateway OS users, also;
brconnect -c -u / -f chpass -o "OPS$<HOSTNAME>\EPDADM" -p <password>
brconnect -c -u / -f chpass -o "OPS$<HOSTNAME>\SAPSERVICEEPD" -p <password>
It should solve the OPS$ mechanism problem.
Best regards,
Orkun Gedik
Hi Ruben,
Of course, you can use the ABAP instance as the gateway. In this case, you don't need an additional gateway instance. So, if we discuss over my message, replace "gateway OS users" with the "ABAP OS users", then apply the steps 1 to 6.
1) Logon with "<sid>adm" ABAP user, to the system,
2) Open "F:\oracle\orasap\102\database\initepd.sap" with a wordpad,
3) Copy all the content of the file,
4) Rename "initepd.sap" file to "initepd.sap.orig",
5) Create a new file with "initEPD.sap" under "F:\oracle\orasap\102\database\" and paste clipboard in it,
6) Then, save the file,
7) Probably, you will face with this error on "initEPD.dba" file, also. If you face this error, then apply steps 1 to 6 for "initEPD.dba", also,
😎 If you face with this problem on "sapcheck" folder, give full permission to the <sid>adm and SAPService<SID> ABAP OS users.
Best regards,
Orkun Gedik
Let me clarify the steps;
1) login to the java server OS by using <sid>adm user
2) perform the steps, below;
CREATE USER "OPS$<HOSTNAME>\<ABAP_SID>ADM" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
CREATE USER "OPS$<HOSTNAME>\SAPSERVICE<ABAP_SID>" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
CREATE TABLE "OPS$<HOSTNAME>\<ABAP_SID>ADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
CREATE SYNONYM "OPS$<HOSTNAME>\SAPSERVICE<ABAP_SID>".SAPUSER FOR "OPS$<HOSTNAME>\<ABAP_SID>ADM".SAPUSER;
GRANT SELECT, UPDATE ON "OPS$<HOSTNAME>\<ABAP_SID>ADM".SAPUSER TO "OPS$<HOSTNAME>\SAPSERVICE<ABAP_SID>";
GRANT CONNECT, RESOURCE TO "OPS$<HOSTNAME>\SAPSERVICE<ABAP_SID>";
GRANT CONNECT, RESOURCE TO "OPS$<HOSTNAME>\<ABAP_SID>ADM";
INSERT INTO "OPS$<HOSTNAME>\<ABAP_SID>ADM".SAPUSER VALUES ('<Java database owner (Ex:SAPSR3DB)>', '<Password>');
COMMIT;
Please note that, I recommend you install a standalone gateway for that kind of operations.
Best regards,
Orkun Gedik
Edited by: Orkun Gedik on May 5, 2011 11:18 AM
Hi Ruben,
First of all, you should login as sysdba role (sqlplus "/as sysdba") to the system, in order to execute the query, below;
CREATE TABLE "OPS$domain\<abapsid>ADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
Secondly, you should use domain name or hostname, as I noted in the SQL statements. By the way, please find the statement below, in the same note;
Note:
As a general rule, the user name and the domain of the Windows user, under which the SAP service was started on the NT computer, must be used. If the service is started with a local user, use the host name of the Application Server as the domain name.
Best regards,
Orkun Gedik
Edited by: Orkun Gedik on May 6, 2011 8:01 PM
Hi Orkun,
I´ve connected as sysdba user at portal database, but I´ve got the error.
SQL> connect /as sysdba
Connected.
SQL> CREATE TABLE "OPS$DOMAINSIDADM".SAPUSER (USERID VARCHAR2(256), PASSWD VAR
CHAR2(256));
CREATE TABLE "OPS$DOMAINSIDADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2
(256))
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
The users were created correctly
Hi Rubin,
Firstly, grant rights to the users, as below;
GRANT CONNECT, RESOURCE TO "OPS$<HOSTNAME>\SAPSERVICE<SID>";
GRANT CONNECT, RESOURCE TO "OPS$<HOSTNAME>\<SID>ADM";
Then, apply steps below;
CREATE TABLE "OPS$<HOSTNAME>\<ABAP_SID>ADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
CREATE SYNONYM "OPS$<HOSTNAME>\SAPSERVICE<ABAP_SID>".SAPUSER FOR "OPS$<HOSTNAME>\<ABAP_SID>ADM".SAPUSER;
GRANT SELECT, UPDATE ON "OPS$<HOSTNAME>\<ABAP_SID>ADM".SAPUSER TO "OPS$<HOSTNAME>\SAPSERVICE<ABAP_SID>";
INSERT INTO "OPS$<HOSTNAME>\<ABAP_SID>ADM".SAPUSER VALUES ('<Java database owner (Ex:SAPSR3DB)>', '<Password>');
COMMIT;
At this stage, please note that even you can use existing ABAP instance as a gateway, I recommend that you install a new standalone gateway. This because, that ABAP gateway is belong to the its own ABAP system. When you are executing br*tools, it will use existing environment variables (such as ORACLE_SID, dbs_ora_schema). Because of those values are belongs to the ABAP system, you will not be able to execute the commands successfully. When you install a new standalone gateway, it will have its own environment variables. By doing so, your existing ABAP stack will not be affected by this configuration.
I hope that I clarified issue,
Best regards,
Orkun Gedik
Hi Orkun,
I´ve executed the previous steps correctly. But, now what can i do?
In the connection of database in DBACOCKPIT I´ve filled with OPS$hostgatewayuserADM, but the connection is not successfully
What is the function of SAP gateway in this landscape?
The log show this:
Parameters:-u / -jid FLL__20110510122922 -sid SID -c force -t online -m full -p initsid.sap
BR0051I BRBACKUP 7.00 (52)
BR0055I Start of database backup: befvuhyl.fnd 2011-05-10 12.29.27
BR0484I BRBACKUP log file: D:oraclePBIsapbackup efvuhyl.fnd
BR0280I BRBACKUP time stamp: 2011-05-10 12.29.29
BR0301E SQL error -1045 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01045: user OPS$DOMAINSAPSERVICEPBI lacks CREATE SESSION privilege; logon denied
BR0310E Connect to database instance SID failed
BR0280I BRBACKUP time stamp: 2011-05-10 12.29.29
BR0301E SQL error -1045 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01045: user OPS$DOMAINSAPSERVICEPBI lacks CREATE SESSION privilege; logon denied
BR0310E Connect to database instance SID failed
Hi Ruben,
Where did you set "OPS$host\gatewayuserADM" value? You should use dbowner (Ex:SAPSR3) not ""OPS$host\gatewayuserADM" on the DBACOCKPIT tx. Please find the configuration summary, below;
1) You created "OPS$host\gatewayuserADM".SAPUSER table, on the Java database. Granted user rights to this table (all the steps that I've noted previously),
2) You installed a standalone gateway and configured same environment variables as Java "sidadm" user,
3) If you are able to collect data from DBACOCKPIT succesfully, with this configuration, you should be able to execute DB13 jobs over remote database, also.
First two items are prerequisites to execute DB13 jobs over remote database.
Best regards,
Orkun Gedik
Hi Orkun,
Where did you set "OPS$hostgatewayuserADM" value? You should use dbowner (Ex:SAPSR3) not ""OPS$hostgatewayuserADM" on the DBACOCKPIT tx. Please find the configuration summary, below;
I´ve put SAPSR3DB in the remote connection to the database
-- MESSAGE Database connection <NAME CONNECTION>L established successfully
1) You created "OPS$hostgatewayuserADM".SAPUSER table, on the Java database. Granted user rights to this table (all the steps that I've noted previously),
I've connected to the server with <JAVASID>adm and put the next sql sentences
CREATE USER "OPS$hostADM".SAPUSER VALUES ('SAPSR3DB', 'password');
COMMIT;
2) You installed a standalone gateway and configured same environment variables as Java "sidadm" user,
I´ve put the E.V for sidadm
ORACLE_HOME
ORACLE_SID
SAPDATA_HOME
TNS_ADMIN
3) If you are able to collect data from DBACOCKPIT succesfully, with this configuration, you should be able to execute DB13 jobs over remote database, also.
In the DBACOCKPIT only appear info in the Performance Overview in the other tabs nothing appears
First two items are prerequisites to execute DB13 jobs over remote database.
I´ve configured the RFC SAPXPG_DBDEST_HOST, but in the connections of database in dbacockpit I don´t know how to setting this connection.
Remote Database is sure, but in the next two options:
Database Connection
Via RFC Connection
RFC Connection
I´ve marked the all options but always RFC destination SAPXPG_DBDEST_Host: Communication error 'COMMUNICATION_FAILURE'
Hi Ruben,
The system generates "SAPXPG_DBDEST_HOST" connection, automatically. It is really hard to figure out what the problem is ,without investigating the configuration on the site. At this stage, I recommend that you open an OSS message in order to investigate the issue, on the site.
Best regards,
Orkun Gedik
Hi Ruben,
You just need to drop newly created "SAPUSER" table and the related synonym. Please be careful while dropping those objects. If you installed a standalone gateway, you can uninstall it easily. You don't need to do any thing, over OS level.
I hope that I clarified the issue.
Best regards,
Orkun Gedik
Hi Orkun,
I´ve connected with the database and now I can see the space statistics, scheduled backups.
But the problem now is when I´ve scheduled and Check and update optimizer statistics, Cleanup logs, Check database but always I get and error. I can see the log file over sap system, but I can´t find the file , for example cefweoev.log, in the server.
Where are stored this log files?
I´ve search the logs of the scheduled tasks of ABAP databases and the extension of
optimizer statistics --> *.sta
Check database--> *.chk
Then the file logs created for the scheduled tasks of remote databases doesn´t create?¿
More thanks.
Hi Ruben,
The configuration is working properly. Then, you have good news
The answer is; log files are created at the remote side.
For the instance, you are executing an "UpdateStats" job on the "DBA Planning Calendar", over the remote system. So, during the process and at the end of the process, you'll be able to see the trace files on remote system "/oracle/<SID>/sapcheck" path. Check the environment variables, including "SAPTRACE".
Best regards,
Orkun Gedik
Hi,
> BR0252E Function fopen() failed for 'F:\oracle\orasap\102\database\initepd.sap' at location BrInitSapRead-1
> BR0253E errno 13: Permission denied
> BR0159E Error reading BR*Tools profile F:\oracle\orasap\102\database\initepd.sap
Problem is initepd.sap profile. I think there is some special character.
Execute BRTOOLS at OS level login with sidadm user. You will get error message or paste your initepd.sap prfile
Thanks
Siva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@(#) $Id: //bas/701_REL/src/ccm/rsbr/initNT.sap#3 $ SAP
########################################################################
#
SAP BR*Tools sample profile. #
The parameter syntax is the same as for init.ora parameters. #
Enclose parameter values which consist of more than one symbol in #
double quotes. #
After any symbol, parameter definition can be continued on the next #
line. #
A parameter value list should be enclosed in parentheses, the list #
items should be delimited by commas. #
There can be any number of white spaces (blanks, tabs and new lines) #
between symbols in parameter definition. #
Comment lines must start with a hash character. #
#
########################################################################
backup mode [all | all_data | full | incr | sap_dir | ora_dir
| all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>)]
default: all
backup_mode = all
restore mode [all | all_data | full | incr | incr_only | incr_full
| incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>) | partial | non_db
redirection with '=' is not supported here - use option '-m' instead
default: all
restore_mode = all
backup type [offline | offline_force | offline_standby | offline_split
| offline_mirror | offline_stop | online | online_cons | online_split
| online_mirror | online_standby | offstby_split | offstby_mirror
default: offline
backup_type = online
backup device type
[tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk
| disk_copy | disk_standby | stage | stage_copy | stage_standby
| util_file | util_file_online | rman_util | rman_disk | rman_stage
| rman_prep]
default: tape
backup_dev_type = disk
backup root directory [<path_name> | (<path_name_list>)]
default: %SAPDATA_HOME%\sapbackup
backup_root_dir = F:\oracle\D10\sapbackup
stage root directory [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
stage_root_dir = F:\oracle\D10\sapbackup
compression flag [no | yes | hardware | only]
default: no
compress = no
compress command
first $-character is replaced by the source file name
second $-character is replaced by the target file name
<target_file_name> = <source_file_name>.Z
for compress command the -c option must be set
recommended setting for brbackup -k only run:
"%SAPEXE%\mkszip -l 0 -c $ > $"
no default
compress_cmd = "D:\usr\sap\D10\SYS\exe\uc\NTAMD64\mkszip -c $ > $"
uncompress command
first $-character is replaced by the source file name
second $-character is replaced by the target file name
<source_file_name> = <target_file_name>.Z
for uncompress command the -c option must be set
no default
uncompress_cmd = "D:\usr\sap\D10\SYS\exe\uc\NTAMD64\uncompress -c $ > $"
directory for compression [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
compress_dir = E:\oracle\D10\sapreorg
brarchive function [save | second_copy | double_save | save_delete
| second_copy_delete | double_save_delete | copy_save
| copy_delete_save | delete_saved | delete_copied]
default: save
archive_function = save
directory for archive log copies to disk
default: first value of the backup_root_dir parameter
archive_copy_dir = F:\oracle\D10\sapbackup
directory for archive log copies to stage
default: first value of the stage_root_dir parameter
archive_stage_dir = F:\oracle\D10\sapbackup
delete archive logs from duplex destination [only | no | yes | check]
default: only
archive_dupl_del = only
new sapdata home directory for disk_copy | disk_standby
no default
new_db_home = X:\oracle\C11
stage sapdata home directory for stage_copy | stage_standby
default: value of the new_db_home parameter
stage_db_home = /oracle/C11
original sapdata home directory for split mirror disk backup
no default
orig_db_home = /oracle/C11
remote host name
no default
remote_host = <host_name>
remote user name
default: current operating system user
remote_user = <user_name>
tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu
| rman_dd | rman_dd_gnu]
default: cpio
tape_copy_cmd = cpio
disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu
| rman_set | rman_set_gnu | ocopy]
default: copy
disk_copy_cmd = copy
stage copy command [rcp | scp | ftp]
default: rcp
stage_copy_cmd = rcp
pipe copy command [rsh | ssh]
default: rsh
pipe_copy_cmd = rsh
flags for cpio output command
default: -ovB
cpio_flags = -ovB
flags for cpio input command
default: -iuvB
cpio_in_flags = -iuvB
flags for cpio command for copy of directories to disk
default: -pdcu
use flags -pdu for gnu tools
cpio_disk_flags = -pdcu
flags for dd output command
default: "obs=16k"
caution: option "obs=" not supported for Windows
recommended setting:
Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_flags = "bs=64k"
flags for dd input command
default: "ibs=16k"
caution: option "ibs=" not supported for Windows
recommended setting:
Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_in_flags = "bs=64k"
number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]
default: 1
saveset_members = 1
additional parameters for RMAN
rman_channels and rman_filesperset are only used when rman_util,
rman_disk or rman_stage
rman_channels defines the number of parallel sbt channel allocations
rman_filesperset = 0 means:
one file per save set - for non-incremental backups
all files in one save set - for incremental backups
the others have the same meaning as for native RMAN
rman_channels = 1
rman_filesperset = 0
rman_maxpiecesize = 0 # in KB - former name rman_kbytes
rman_rate = 0 # in KB - former name rman_readrate
rman_maxopenfiles = 0
rman_maxsetsize = 0 # in KB - former name rman_setsize
additional parameters for RMAN version 8.1
the parameters have the same meaning as for native RMAN
rman_diskratio = 0 # deprecated in Oracle 10g
rman_pool = 0
rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex
rman_proxy = no | yes | only
special parameters for an external backup library, example:
rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"
rman_send = "'<command>'"
rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",
"channel sbt_2 '<command2>' parms='<parameters2>'")
rman_compress = no | yes
rman_maxcorrupt = (<dbf_name>|<dbf_id>:<corr_cnt>, ...)
remote copy-out command (backup_dev_type = pipe)
$-character is replaced by current device address
no default
copy_out_cmd = "dd ibs=8k obs=64k of=$"
remote copy-in command (backup_dev_type = pipe)
$-character is replaced by current device address
no default
copy_in_cmd = "dd ibs=64k obs=8k if=$"
rewind command
$-character is replaced by current device address
no default
operating system dependent, examples:
HP-UX: "mt -f $ rew"
TRU64: "mt -f $ rewind"
AIX: "tctl -f $ rewind"
Solaris: "mt -f $ rewind"
Windows: "mt -f $ rewind"
Linux: "mt -f $ rewind"
rewind = "mt -f $ rewind"
rewind and set offline command
$-character is replaced by current device address
default: value of the rewind parameter
operating system dependent, examples:
HP-UX: "mt -f $ offl"
TRU64: "mt -f $ offline"
AIX: "tctl -f $ offline"
Solaris: "mt -f $ offline"
Windows: "mt -f $ offline"
Linux: "mt -f $ offline"
rewind_offline = "mt -f $ offline"
tape positioning command
first $-character is replaced by current device address
second $-character is replaced by number of files to be skipped
no default
operating system dependent, examples:
HP-UX: "mt -f $ fsf $"
TRU64: "mt -f $ fsf $"
AIX: "tctl -f $ fsf $"
Solaris: "mt -f $ fsf $"
Windows: "mt -f $ fsf $"
Linux: "mt -f $ fsf $"
tape_pos_cmd = "mt -f $ fsf $"
mount backup volume command in auto loader / juke box
used if backup_dev_type = tape_box | pipe_box
no default
mount_cmd = "<mount_cmd> $ $ $ [$]"
dismount backup volume command in auto loader / juke box
used if backup_dev_type = tape_box | pipe_box
no default
dismount_cmd = "<dismount_cmd> $ $ [$]"
split mirror disks command
used if backup_type = offline_split | online_split | offline_mirror
| online_mirror
no default
split_cmd = "<split_cmd> [$]"
resynchronize mirror disks command
used if backup_type = offline_split | online_split | offline_mirror
| online_mirror
no default
resync_cmd = "<resync_cmd> [$]"
additional options for SPLITINT interface program
no default
split_options = "<split_options>"
resynchronize after backup flag [no | yes]
default: no
split_resync = no
pre-split command
no default
pre_split_cmd = "<pre_split_cmd>"
post-split command
no default
post_split_cmd = "<post_split_cmd>"
pre-shut command
no default
pre_shut_cmd = "<pre_shut_cmd>"
post-shut command
no default
post_shut_cmd = "<post_shut_cmd>"
volume size in KB = K, MB = M or GB = G (backup device dependent)
default: 1200M
recommended values for tape devices without hardware compression:
60 m 4 mm DAT DDS-1 tape: 1200M
90 m 4 mm DAT DDS-1 tape: 1800M
120 m 4 mm DAT DDS-2 tape: 3800M
125 m 4 mm DAT DDS-3 tape: 11000M
112 m 8 mm Video tape: 2000M
112 m 8 mm high density: 4500M
DLT 2000 10/20 GB: 10000M
DLT 2000XT 15/30 GB: 15000M
DLT 4000 20/40 GB: 20000M
DLT 7000 35/70 GB: 35000M
recommended values for tape devices with hardware compression:
60 m 4 mm DAT DDS-1 tape: 1000M
90 m 4 mm DAT DDS-1 tape: 1600M
120 m 4 mm DAT DDS-2 tape: 3600M
125 m 4 mm DAT DDS-3 tape: 10000M
112 m 8 mm Video tape: 1800M
112 m 8 mm high density: 4300M
DLT 2000 10/20 GB: 9000M
DLT 2000XT 15/30 GB: 14000M
DLT 4000 20/40 GB: 18000M
DLT 7000 35/70 GB: 30000M
tape_size = 100G
volume size in KB = K, MB = M or GB = G used by brarchive
default: value of the tape_size parameter
tape_size_arch = 100G
level of parallel execution
default: 0 - set to number of backup devices
exec_parallel = 0
address of backup device without rewind
[<dev_address> | (<dev_address_list>)]
no default
operating system dependent, examples:
HP-UX: /dev/rmt/0mn
TRU64: /dev/nrmt0h
AIX: /dev/rmt0.1
Solaris: /dev/rmt/0mn
Windows: /dev/nmt0 | /dev/nst0
Linux: /dev/nst0
tape_address = /dev/nmt0
address of backup device without rewind used by brarchive
default: value of the tape_address parameter
operating system dependent
tape_address_arch = /dev/nmt0
address of backup device with rewind
[<dev_address> | (<dev_address_list>)]
no default
operating system dependent, examples:
HP-UX: /dev/rmt/0m
TRU64: /dev/rmt0h
AIX: /dev/rmt0
Solaris: /dev/rmt/0m
Windows: /dev/mt0 | /dev/st0
Linux: /dev/st0
tape_address_rew = /dev/mt0
address of backup device with rewind used by brarchive
default: value of the tape_address_rew parameter
operating system dependent
tape_address_rew_arch = /dev/mt0
address of backup device with control for mount/dismount command
[<dev_address> | (<dev_address_list>)]
default: value of the tape_address_rew parameter
operating system dependent
tape_address_ctl = /dev/...
address of backup device with control for mount/dismount command
used by brarchive
default: value of the tape_address_rew_arch parameter
operating system dependent
tape_address_ctl_arch = /dev/...
volumes for brarchive
[<volume_name> | (<volume_name_list>) | SCRATCH]
no default
volume_archive = (D10A01, D10A02, D10A03, D10A04, D10A05,
D10A06, D10A07, D10A08, D10A09, D10A10,
D10A11, D10A12, D10A13, D10A14, D10A15,
D10A16, D10A17, D10A18, D10A19, D10A20,
D10A21, D10A22, D10A23, D10A24, D10A25,
D10A26, D10A27, D10A28, D10A29, D10A30)
volumes for brbackup
[<volume_name> | (<volume_name_list>) | SCRATCH]
no default
volume_backup = (D10B01, D10B02, D10B03, D10B04, D10B05,
D10B06, D10B07, D10B08, D10B09, D10B10,
D10B11, D10B12, D10B13, D10B14, D10B15,
D10B16, D10B17, D10B18, D10B19, D10B20,
D10B21, D10B22, D10B23, D10B24, D10B25,
D10B26, D10B27, D10B28, D10B29, D10B30)
expiration period for backup volumes in days
default: 30
expir_period = 30
recommended usages of backup volumes
default: 100
tape_use_count = 100
backup utility parameter file
default: no parameter file
util_par_file = initD10.utl
mount/dismount command parameter file
default: no parameter file
mount_par_file = initD10.mnt
Oracle connection name to the primary database
[primary_db = <conn_name> | LOCAL]
no default
primary_db = <conn_name>
Oracle connection name to the standby database
[standby_db = <conn_name> | LOCAL]
no default
standby_db = <conn_name>
description of parallel instances for Oracle RAC
parallel_instances = <inst_desc> | (<inst_desc_list>)
<inst_desc_list> - <inst_desc>[,<inst_desc>...]
<inst_desc> - <Oracle_sid>:<Oracle_home>@<conn_name>
<Oracle_sid> - Oracle system id for parallel instance
<Oracle_home> - Oracle home for parallel instance
<conn_name> - Oracle connection name to parallel instance
Please include the local instance in the parameter definition!
default: no parallel instances
example for initRAC001.sap:
parallel_instances = (RAC001:/oracle/RAC/920_64@RAC001,
RAC002:/oracle/RAC/920_64@RAC002, RAC003:/oracle/RAC/920_64@RAC003)
handling of Oracle RAC database services [no | yes]
default: no
db_services = yes
database owner of objects to be checked
<owner> | (<owner_list>)
default: all SAP owners
check_owner = sapr3
database objects to be excluded from checks
all_part | non_sap | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.][<prefix>]*[<suffix>] | <tablespace> | (<object_list>)
default: no exclusion, example:
check_exclude = (SDBAH, SAPR3.SDBAD)
special database check conditions
("<type>:<cond>:<active>:<sever>:[<chkop>]:[<chkval>]:[<unit>]", ...)
check_cond = (<cond_list>)
database owner of SDBAH, SDBAD and XDB tables for cleanup
<owner> | (<owner_list>)
default: all SAP owners
cleanup_owner = sapr3
retention period in days for brarchive log files
default: 30
cleanup_brarchive_log = 30
retention period in days for brbackup log files
default: 30
cleanup_brbackup_log = 30
retention period in days for brconnect log files
default: 30
cleanup_brconnect_log = 30
retention period in days for brrestore log files
default: 30
cleanup_brrestore_log = 30
retention period in days for brrecover log files
default: 30
cleanup_brrecover_log = 30
retention period in days for brspace log files
default: 30
cleanup_brspace_log = 30
retention period in days for archive log files saved on disk
default: 30
cleanup_disk_archive = 30
retention period in days for database files backed up on disk
default: 30
cleanup_disk_backup = 30
retention period in days for brspace export dumps and scripts
default: 30
cleanup_exp_dump = 30
retention period in days for Oracle trace and audit files
default: 30
cleanup_ora_trace = 30
retention period in days for records in SDBAH and SDBAD tables
default: 100
cleanup_db_log = 100
retention period in days for records in XDB tables
default: 100
cleanup_xdb_log = 100
retention period in days for database check messages
default: 100
cleanup_check_msg = 100
database owner of objects to adapt next extents
<owner> | (<owner_list>)
default: all SAP owners
next_owner = sapr3
database objects to adapt next extents
all | all_ind | special | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.][<prefix>]*[<suffix>] | <tablespace> | (<object_list>)
default: all abjects of selected owners, example:
next_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from adapting next extents
all_part | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.][<prefix>]*[<suffix>] | <tablespace> | (<object_list>)
default: no exclusion, example:
next_exclude = (SDBAH, SAPR3.SDBAD)
database objects to get special next extent size
all_sel:<size>[/<limit>] | [<owner>.]<table>:<size>[/<limit>]
| [<owner>.]<index>:<size>[/<limit>]
| [<owner>.][<prefix>]*[<suffix>]:<size>[/<limit>]
| (<object_size_list>)
default: according to table category, example:
next_special = (SDBAH:100K, SAPR3.SDBAD:1M/200)
maximum next extent size
default: 2 GB - 5 * <database_block_size>
next_max_size = 1G
maximum number of next extents
default: 0 - unlimited
next_limit_count = 300
database owner of objects to update statistics
<owner> | (<owner_list>)
default: all SAP owners
stats_owner = sapr3
database objects to update statistics
all | all_ind | all_part | missing | info_cubes | dbstatc_tab
| dbstatc_mon | dbstatc_mona | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.][<prefix>]*[<suffix>] | <tablespace> | (<object_list>)
| harmful | locked | system_stats | oradict_stats | oradict_tab
default: all abjects of selected owners, example:
stats_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from updating statistics
all_part | info_cubes | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.][<prefix>]*[<suffix>] | <tablespace> | (<object_list>)
default: no exclusion, example:
stats_exclude = (SDBAH, SAPR3.SDBAD)
method for updating statistics for tables not in DBSTATC
E | EH | EI | EX | C | CH | CI | CX | A | AH | AI | AX | E= | C= | =H
| =I | =X | +H | +I
default: according to internal rules
stats_method = E
sample size for updating statistics for tables not in DBSTATC
P<percentage_of_rows> | R<thousands_of_rows>
default: according to internal rules
stats_sample_size = P10
number of buckets for updating statistics with histograms
default: 75
stats_bucket_count = 75
threshold for collecting statistics after checking
<threshold> | (<threshold> [, all_part:<threshold>
| info_cubes:<threshold> | [<owner>.]<table>:<threshold>
| [<owner>.][<prefix>]*[<suffix>]:<threshold>
| <tablespace>:<threshold> | <object_list>])
default: 50%
stats_change_threshold = 50
number of parallel threads for updating statistics
default: 1
stats_parallel_degree = 1
processing time limit in minutes for updating statistics
default: 0 - no limit
stats_limit_time = 0
parameters for calling DBMS_STATS supplied package
all:R|B[<buckets>|A|S|R]:0|<degree>A|D
| all_part:R|B[<buckets>|A|S|R]:0|<degree>A|D
| info_cubes:R|B:A|D|0|<degree>
| [<owner>.]<table>:R|B[<buckets>|A|S|R]:0|<degree>A|D
| [<owner>.][<prefix>]*[<suffix>]:R|B[<buckets>|A|S|R]:0|<degree>A|D
| (<object_list>) | NO
R|B[<buckets>|A|S|R]:
'R' - row sampling, 'B' - block sampling,
<buckets> - histogram buckets count, 'A' - auto buckets count,
'S' - skew only, 'R' - repeat
<degree>A|D:
<degree> - dbms_stats parallel degree, '0' - table degree,
'A' - auto degree, 'D' - default degree
default: ALL:R:0
stats_dbms_stats = ([ALL:R:1,][<owner>.]<table>:R:<degree>,...)
definition of info cube tables
default | rsnspace_tab | [<owner>.]<table>
| [<owner>.][<prefix>]*[<suffix>] | (<object_list>) | null
default: rsnspace_tab
stats_info_cubes = (/BIC/D, /BI0/D, ...)
special statistics settings
(<table>:[<owner>]:<active>:[<method>]:[<sample>], ...)
stats_special = (<special_list>)
recovery type [complete | dbpit | tspit | reset | restore | apply
| disaster]
default: complete
recov_type = complete
directory for brrecover file copies
default: $SAPDATA_HOME/sapbackup
recov_copy_dir = E:\oracle\D10\sapbackup
time period for searching for backups
0 - all available backups, >0 - backups from n last days
default: 30
recov_interval = 30
degree of paralelism for applying archive log files
0 - use Oracle default parallelism, 1 - serial, >1 - parallel
default: Oracle default
recov_degree = 0
number of lines for scrolling in list menus
0 - no scrolling, >0 - scroll n lines
default: 20
scroll_lines = 20
time period for displaying profiles and logs
0 - all available logs, >0 - logs from n last days
default: 30
show_period = 30
directory for brspace file copies
default: $SAPDATA_HOME/sapreorg
space_copy_dir = E:\oracle\D10\sapreorg
directory for table export dump files
default: $SAPDATA_HOME/sapreorg
exp_dump_dir = E:\oracle\D10\sapreorg
database tables for reorganization
[<owner>.]<table> | [<owner>.][<prefix>]*[<suffix>]
| [<owner>.][<prefix>]%[<suffix>] | (<table_list>)
no default
reorg_table = (SDBAH, SAPR3.SDBAD)
database indexes for rebuild
[<owner>.]<index> | [<owner>.][<prefix>]*[<suffix>]
| [<owner>.][<prefix>]%[<suffix>] | (<index_list>)
no default
rebuild_index = (SDBAH0, SAPR3.SDBAD0)
database tables for export
[<owner>.]<table> | [<owner>.][<prefix>]*[<suffix>]
| [<owner>.][<prefix>]%[<suffix>] | (<table_list>)
no default
exp_table = (SDBAH, SAPR3.SDBAD)
database tables for import
<table> | (<table_list>)
no default
do not specify table owner in the list - use -o|-owner option for this
imp_table = (SDBAH, SDBAD)
Hi Ruben
Try to perform a local DB connection using the schema user
SQLPLUS SAPD10DB/<password>@D10
If you can connect sucessful: check note 134592.
If you cannot connect, check note 400241,
Hope that it help you
Kind regards
Marcelo Macedo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.