Question:
hello
there are windows2003+oracle9i+crm4.0(640).
i am facing a problem,when i run DB13 for a backup,there are some error:
No application server found on database host - rsh/Gateway will be used
Execute logical command BRCONNECT On host CRM-DB
参数: -u / -c -f stats -t ALL
BR0801I BRCONNECT 6.40 (11)
BR0805I Start of BRCONNECT processing: cdsfkfqu.sta 2006-03-23 09.15.52
BR0280I BRCONNECT time stamp: 2006-03-23 09.15.52
BR0301E SQL error -1017 at location db_connect-2
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance PRD failed
BR0280I BRCONNECT time stamp: 2006-03-23 09.15.52
BR0301E SQL error -1017 at location db_connect-2
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance PRD failed
BR0806I End of BRCONNECT processing: cdsfkfqu.sta2006-03-23 09.15.52
BR0280I BRCONNECT time stamp: 2006-03-23 09.15.52
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
can anybody give me some advice?
thanks in advance.
squall
Answer:
Hi,
Since you are using Windows 2003 can you try this command at the DOS prompt
brconnect -u system/sap -c -f stats -t all
You have to update first your br* files to the latest version/patch
Answer:
when i run oradbusr.sql and sapdba_role.sql ,it was terminational suddenly.
---------------------------------------------------------------
SQL> drop user "OPS$ORAPRD" cascade;
User dropped.
SQL> @ORADBUSR.SQL SAPPRD CRM-DB
Connected.
old 6: if length('&&1') = 5 then
new 6: if length('SAPPRD') = 5 then
old 7: if substr(upper('&&1'),1,5) = 'SAPR3' then
new 7: if substr(upper('SAPPRD'),1,5) = 'SAPR3' then
old 10: if upper('&&2') = 'NT' then
new 10: if upper('CRM-DB') = 'NT' then
Enter value for 3:
old 17: :sDomain := upper('&&3');
new 17: :sDomain := upper('');
Enter value for 4:
old 18: :sSapSid := upper('&&4');
new 18: :sSapSid := upper('');
old 20: :sSapSid := upper('&&3');
new 20: :sSapSid := upper('');
old 36: :sSchema := upper('&&1');
new 36: :sSchema := upper('SAPPRD');
old 37: if upper('&&2') = 'NT' then
new 37: if upper('CRM-DB') = 'NT' then
old 44: :sDomain := upper('&&3');
new 44: :sDomain := upper('');
old 45: :sSapSid := upper('&&4');
new 45: :sSapSid := upper('');
old 47: :sSapSid := upper('&&3');
new 47: :sSapSid := upper('');
using following Parameters:
.
. Oracle Version: 9.2.0.6.0
. Parametervalue os_authent_prefix: OPS$
. Schema Id: PRD
. Database User (Schema): SAPPRD
. SAP R/3 Administrator: OPS$ADM
.
Connected.
Connected.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
------------------------------------------------------------------------------
SQL> @sapdba_role.sql SAPPRD
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
-----------------------------------------------------------------------------
the log is following:
oradbusr.log
old 6: if length('&&1') = 5 then
new 6: if length('SAPPRD') = 5 then
old 7: if substr(upper('&&1'),1,5) = 'SAPR3' then
new 7: if substr(upper('SAPPRD'),1,5) = 'SAPR3' then
Enter value for 2:
old 10: if upper('&&2') = 'NT' then
new 10: if upper('') = 'NT' then
Enter value for 3:
old 17: :sDomain := upper('&&3');
new 17: :sDomain := upper('');
Enter value for 4:
old 18: :sSapSid := upper('&&4');
new 18: :sSapSid := upper('');
old 20: :sSapSid := upper('&&3');
new 20: :sSapSid := upper('');
old 36: :sSchema := upper('&&1');
new 36: :sSchema := upper('SAPPRD');
old 37: if upper('&&2') = 'NT' then
new 37: if upper('') = 'NT' then
old 44: :sDomain := upper('&&3');
new 44: :sDomain := upper('');
old 45: :sSapSid := upper('&&4');
new 45: :sSapSid := upper('');
old 47: :sSapSid := upper('&&3');
new 47: :sSapSid := upper('');
using following Parameters:
.
. Oracle Version: 9.2.0.6.0
. Parametervalue os_authent_prefix: OPS$
. Schema Id: PRD
. Database User (Schema): SAPPRD
. SAP R/3 Administrator: OPS$ADM
.
-----------------------------------------------------------------------
sapdba_role.sql log:
Connected.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
old 1: grant ALL on &User..SDBAH to sapdba
new 1: grant ALL on SAPR3.SDBAH to sapdba
grant ALL on SAPR3.SDBAH to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..SDBAD to sapdba
new 1: grant ALL on SAPR3.SDBAD to sapdba
grant ALL on SAPR3.SDBAD to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAML to sapdba
new 1: grant ALL on SAPR3.DBAML to sapdba
grant ALL on SAPR3.DBAML to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBARCL to sapdba
new 1: grant ALL on SAPR3.DBARCL to sapdba
grant ALL on SAPR3.DBARCL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAFID to sapdba
new 1: grant ALL on SAPR3.DBAFID to sapdba
grant ALL on SAPR3.DBAFID to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAEXTL to sapdba
new 1: grant ALL on SAPR3.DBAEXTL to sapdba
grant ALL on SAPR3.DBAEXTL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAREOL to sapdba
new 1: grant ALL on SAPR3.DBAREOL to sapdba
grant ALL on SAPR3.DBAREOL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBABARL to sapdba
new 1: grant ALL on SAPR3.DBABARL to sapdba
grant ALL on SAPR3.DBABARL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBADFL to sapdba
new 1: grant ALL on SAPR3.DBADFL to sapdba
grant ALL on SAPR3.DBADFL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAOPTL to sapdba
new 1: grant ALL on SAPR3.DBAOPTL to sapdba
grant ALL on SAPR3.DBAOPTL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBASPAL to sapdba
new 1: grant ALL on SAPR3.DBASPAL to sapdba
grant ALL on SAPR3.DBASPAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBABD to sapdba
new 1: grant ALL on SAPR3.DBABD to sapdba
grant ALL on SAPR3.DBABD to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBABL to sapdba
new 1: grant ALL on SAPR3.DBABL to sapdba
grant ALL on SAPR3.DBABL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBATL to sapdba
new 1: grant ALL on SAPR3.DBATL to sapdba
grant ALL on SAPR3.DBATL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAOBJL to sapdba
new 1: grant ALL on SAPR3.DBAOBJL to sapdba
grant ALL on SAPR3.DBAOBJL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAPHAL to sapdba
new 1: grant ALL on SAPR3.DBAPHAL to sapdba
grant ALL on SAPR3.DBAPHAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAGRP to sapdba
new 1: grant ALL on SAPR3.DBAGRP to sapdba
grant ALL on SAPR3.DBAGRP to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAERR to sapdba
new 1: grant ALL on SAPR3.DBAERR to sapdba
grant ALL on SAPR3.DBAERR to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBATRIAL to sapdba
new 1: grant ALL on SAPR3.DBATRIAL to sapdba
grant ALL on SAPR3.DBATRIAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTATC to sapdba
new 1: grant ALL on SAPR3.DBSTATC to sapdba
grant ALL on SAPR3.DBSTATC to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTATTORA to sapdba
new 1: grant ALL on SAPR3.DBSTATTORA to sapdba
grant ALL on SAPR3.DBSTATTORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTATIORA to sapdba
new 1: grant ALL on SAPR3.DBSTATIORA to sapdba
grant ALL on SAPR3.DBSTATIORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTATHORA to sapdba
new 1: grant ALL on SAPR3.DBSTATHORA to sapdba
grant ALL on SAPR3.DBSTATHORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTAIHORA to sapdba
new 1: grant ALL on SAPR3.DBSTAIHORA to sapdba
grant ALL on SAPR3.DBSTAIHORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBMSGORA to sapdba
new 1: grant ALL on SAPR3.DBMSGORA to sapdba
grant ALL on SAPR3.DBMSGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBCHECKORA to sapdba
new 1: grant ALL on SAPR3.DBCHECKORA to sapdba
grant ALL on SAPR3.DBCHECKORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..MLICHECK to sapdba
new 1: grant ALL on SAPR3.MLICHECK to sapdba
grant ALL on SAPR3.MLICHECK to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..TGORA to sapdba
new 1: grant SELECT on SAPR3.TGORA to sapdba
grant SELECT on SAPR3.TGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..IGORA to sapdba
new 1: grant SELECT on SAPR3.IGORA to sapdba
grant SELECT on SAPR3.IGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..TSORA to sapdba
new 1: grant SELECT on SAPR3.TSORA to sapdba
grant SELECT on SAPR3.TSORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..TAORA to sapdba
new 1: grant SELECT on SAPR3.TAORA to sapdba
grant SELECT on SAPR3.TAORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..IAORA to sapdba
new 1: grant SELECT on SAPR3.IAORA to sapdba
grant SELECT on SAPR3.IAORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..SVERS to sapdba
new 1: grant SELECT on SAPR3.SVERS to sapdba
grant SELECT on SAPR3.SVERS to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DD02L to sapdba
new 1: grant SELECT on SAPR3.DD02L to sapdba
grant SELECT on SAPR3.DD02L to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DD09L to sapdba
new 1: grant SELECT on SAPR3.DD09L to sapdba
grant SELECT on SAPR3.DD09L to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DDNTT to sapdba
new 1: grant SELECT on SAPR3.DDNTT to sapdba
grant SELECT on SAPR3.DDNTT to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DDART to sapdba
new 1: grant SELECT on SAPR3.DDART to sapdba
grant SELECT on SAPR3.DDART to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DARTT to sapdba
new 1: grant SELECT on SAPR3.DARTT to sapdba
grant SELECT on SAPR3.DARTT to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DBCHK to sapdba
new 1: grant SELECT on SAPR3.DBCHK to sapdba
grant SELECT on SAPR3.DBCHK to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DBDIFF to sapdba
new 1: grant SELECT on SAPR3.DBDIFF to sapdba
grant SELECT on SAPR3.DBDIFF to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 12: Statement := 'grant SELECT on &User..RSNSPACE to sapdba';
new 12: Statement := 'grant SELECT on SAPR3.RSNSPACE to sapdba';
old 21: Statement := 'grant SELECT on &User..RSPSPACE to sapdba';
new 21: Statement := 'grant SELECT on SAPR3.RSPSPACE to sapdba';
PL/SQL procedure successfully completed.
-------------------------------------------------------------------------
can anyone give some advice?
any help will be appreciated.
squall
Answer:
hello TAKONG
i have changed my "system" password to ****,not sap.is it OK?
BTW,my system is a distuibute system,CI and DB at separate host.
Answer:
Hi squall,
Seems you have resolve your remote exec problem ...Now, is it using Ataman or SAPGW? ...as SAPGW can replace some of rsh functions..
I think the problem below is related with user "OPS$<HOST>|<OS_USER>" on your oracle ...
<OS_USER> should be SAPSERVICESID and/or SIDADM ...related with brconnect, brbackup it will use SAPSERVICESID ...
For more detail how to set it, please read OSS note 400241 and 562863
_________________
Hery Darmawan
"Guitar Shredder from Bandung-Indonesia"
Answer:
Hi squall,
Seems you have resolve your remote exec problem ...Now, is it using Ataman or SAPGW? ...as SAPGW can replace some of rsh functions..
I think the problem below is related with user "OPS$<HOST>|<OS_USER>" on your oracle ...
<OS_USER> should be SAPSERVICESID and/or SIDADM ...related with brconnect, brbackup it will use SAPSERVICESID ...
For more detail how to set it, please read OSS note 400241 and 562863
Hello,hery
thank you for you reply.
when i run command:
----------------------------------------------
SQL> select username from dba_users;
USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
OPS$CRM-DB\PRDADM
SAPPRD
OPS$CRM-DB\SAPSERVICEPRD
OPS$ORAPRD
OPS$ADM
PRD
OPS$\ADM
USERNAME
------------------------------
OPS$\SAPSERVICE
12 rows selected.
SQL> conn /
Connected.
SQL> show user
USER is "OPS$CRM-DB\PRDADM"
------------------------------------------------------
there are enough OPS$ user here.
i have installed gatewany instance and a dialog instance on my DB server.
the RFC SAPXPG_DBDEST_CRM-DB with the new gateway information is OK now.
but the DB13 is also failed,error:ORA-01017: invalid username/password; logon denied.
could you kindly add my MSN(liunan0212@hotmail.com)??
i want to discuss this problem(DB13) with you.could you?
thank you very much.
it is aboring me for a long time.
squall
Answer:
Hi,
If you have CI and DB server, it means you have to setup Ataman for your requirement. Search SAP OSS note for this.
For the table view does not exist, have you just recently patch your Oracle database? To resolve this ou need to run additional sql script to resolve this problem. Check your Oracle patch CD for the post installation instruction.
Answer:
Hi,
If you have CI and DB server, it means you have to setup Ataman for your requirement. Search SAP OSS note for this.
For the table view does not exist, have you just recently patch your Oracle database? To resolve this ou need to run additional sql script to resolve this problem. Check your Oracle patch CD for the post installation instruction.
thank you.
i run the sql:SQL> @sapdba_additional.sql PRD NT
SQL> @sapdba_additional.sql PRD NT
Connected.
old 3: :sSchemaUser := upper('&&1');
new 3: :sSchemaUser := upper('PRD');
old 4: if upper('&&2') = 'NT' then
new 4: if upper('NT') = 'NT' then
Enter value for 3:
old 10: :sOsUser := upper('&&3');
new 10: :sOsUser := upper('');
using following Parameters:
.
. Schema User: PRD
. Parametervalue os_authent_prefix: OPS$
. OS User:
.
unable to create table: PRD.SDBAH
begin
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
ORA-06512: at line 62
i do konw how to Enter value for "3",i try "sapprd" and other users,the error not disappear.
thank you very much.
squall
Answer:
Hi Squall,
I think you need to check oracle authorization on your system (OSS note 700548)..
for
unable to create table: PRD.SDBAH
begin
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
Check whether all OPS$ users, SAP<SID>, and SYSTEM have privilage "UNLIMITED TABLESPACE" ...If not, grant it to them ..
btw, MSN and YM are blocked for external comm at my place
_________________
Hery Darmawan
"Guitar Shredder from Bandung-Indonesia"