Не запускается SAP/R3 после востановления с резервной копии

vlymar

vlymar написал:

:(
Enter user-name: system
пускает в SQL> под любым паролем и без него.

Svetlana

tr0ublemaker написал:

зачем??? не проще ли сразу зайти под sysdba и сменить пароль system?

sysdba в новых версиях не существует - brtools

запускайте brtools - от пользователя oraprd

Svetlana

vlymar написал:

:(
Enter user-name: system
пускает в SQL> под любым паролем и без него.

так не бывает

sqlplus "/as sysdba"

connect system

и что пускает?

Svetlana

su - oraprd
brtools
8
4

там увидите

vlymar

brtools > 8 > 4 > 2
2 - Database user/password (user) ............. [sapprd/********]
пасворд qwerasdf

Code:

###############################################################################

BR0801I BRCONNECT 7.00 (43)
BR0280I BRCONNECT time stamp: 2010-06-25 13.26.27
BR0301E SQL error -1017 at location db_connect-2, SQL statement:
'CONNECT sapprd/********'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance PRD failed

BR0280I BRCONNECT time stamp: 2010-06-25 13.26.27
BR0804I BRCONNECT terminated with errors

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 3

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

vlymar

точно Света, тут пускает только через пароль qwerasdf

Code:

sapr3:oraprd 66> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jun 25 13:27:45 2010

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options

SQL> connect system
Enter password: 
ERROR:
ORA-01005: null password given; logon denied


Warning: You are no longer connected to ORACLE.
SQL> connect system
Enter password: 
Connected.
SQL> 

Svetlana

vlymar написал:

brtools > 8 > 4 > 2
2 - Database user/password (user) ............. [sapprd/********]
пасворд qwerasdf

Code:

###############################################################################

BR0801I BRCONNECT 7.00 (43)
BR0280I BRCONNECT time stamp: 2010-06-25 13.26.27
BR0301E SQL error -1017 at location db_connect-2, SQL statement:
'CONNECT sapprd/********'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance PRD failed

BR0280I BRCONNECT time stamp: 2010-06-25 13.26.27
BR0804I BRCONNECT terminated with errors

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 3

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

не 2
а 3! потом спросит пароль пункт 2 не трогайте

Svetlana

-------------------------------------------------------------------------------
BRCONNECT options for changing password of database user

1 - BRCONNECT profile (profile) ............... [initER1.sap]
2 - Database user/password (user) ............. [/]
3 ~ Database owner to change password (owner) . [SYSTEM]
4 - Message language (language) ............... [E]
5 - BRCONNECT command line (command) .......... [-p initER1.sap -l E -f chpass -o SYSTEM]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2010-06-25 14.41.42
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRCONNECT will be started with options '-p initER1.sap -l E -f chpass -o SYSTEM'

BR0280I BRTOOLS time stamp: 2010-06-25 14.41.42
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2010-06-25 14.41.45
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR0801I BRCONNECT 7.00 (11)
BR0280I BRCONNECT time stamp: 2010-06-25 14.41.46
BR0263I Enter password for database user 'SYSTEM' (maximum 30 characters):

BR0280I BRCONNECT time stamp: 2010-06-25 14.41.55
BR0263I Reenter password for database user 'SYSTEM' (maximum 30 characters):

BR0280I BRCONNECT time stamp: 2010-06-25 14.42.00
BR0829I Password changed successfully in database for user SYSTEM

BR0280I BRCONNECT time stamp: 2010-06-25 14.42.00
BR0802I BRCONNECT completed successfully

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 0
BR0280I BRTOOLS time stamp: 2010-06-25 14.42.00
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:

так должно быть

шрам

самое главное, когда все получится, подсчитать трудозатраты по времени и сделать орг выводы :wink:

vlymar

Ой а я sapprd туда суну..

так..

Code:

-------------------------------------------------------------------------------
BRCONNECT options for changing password of database user

 1 - BRCONNECT profile (profile) ............... [initPRD.sap]
 2 - Database user/password (user) ............. [/]
 3 ~ Database owner to change password (owner) . [SYSTEM]
 4 ~ Log file name (log) ....................... []
 5 - Message language (language) ............... [E]
 6 - BRCONNECT command line (command) .......... [-p initPRD.sap -l E -f chpass -o SYSTEM]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:

c
BR0280I BRTOOLS time stamp: 2010-06-25 13.38.18
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRCONNECT will be started with options '-p initPRD.sap -l E -f chpass -o SYSTEM'

BR0280I BRTOOLS time stamp: 2010-06-25 13.38.18
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2010-06-25 13.38.29
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR0801I BRCONNECT 7.00 (43)
BR0280I BRCONNECT time stamp: 2010-06-25 13.38.29
BR1048I Enter new password for database user 'SYSTEM' (max. 30 characters):

BR0280I BRCONNECT time stamp: 2010-06-25 13.38.55
BR1048I Reenter new password for database user 'SYSTEM' (max. 30 characters):

BR0280I BRCONNECT time stamp: 2010-06-25 13.38.59
BR0829I Password changed successfully in database for user SYSTEM

BR0280I BRCONNECT time stamp: 2010-06-25 13.38.59
BR0802I BRCONNECT completed successfully

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 0

так и есть.
дальше жать "с" или "b" и выход?

Code:

BR0280I BRTOOLS time stamp: 2010-06-25 13.41.46
BR0663I Your choice: 'b'
BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2010-06-25 13.41.46
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 + Additional functions
 9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
9
BR0280I BRTOOLS time stamp: 2010-06-25 13.41.48
BR0663I Your choice: '9'
BR0280I BRTOOLS time stamp: 2010-06-25 13.41.48
BR0680I Do you really want to exit BRTOOLS? Enter y[es]/n[o]:
yes
BR0280I BRTOOLS time stamp: 2010-06-25 13.41.50
BR0257I Your reply: 'yes'

BR0280I BRTOOLS time stamp: 2010-06-25 13.41.50
BR0653I BRTOOLS completed successfully with warnings

шрам

теперь
R3trans -d

вот только нафига меняли пароль system-у?

Svetlana

то же самое но для SAPPRD

потом R3trans -x

vlymar

ааааааааааааааааааааааааааааааааа!Я ИДИЁТ, УБЕЙТЕ МИНЯ КТО-НИБУДЬ!Я ИДИЁТ, УБЕЙТЕ МИНЯ КТО-НИБУДЬ!

Code:

sapr3:prdadm 59> startsap

Checking PRD Database
------------------------------
 ABAP Database is running

Starting SAP-Collector Daemon 
------------------------------
13:44:15 25.06.2010   LOG: Effective User Id is root
***********************************************************************
* This is Saposcol Version COLL 20.95 700 - v2.12, AMD/Intel x86_64 with Linux, 2008/01/02
* Usage:  saposcol -l: Start OS Collector 
*         saposcol -k: Stop  OS Collector 
*         saposcol -d: OS Collector Dialog Mode
*         saposcol -s: OS Collector Status
* The OS Collector (PID 3965) is already running ..... 
************************************************************************
 saposcol already running

Starting SAP Instance DVEBMGS00
------------------------------
 Startup-Log is written to /home/prdadm/startsap_DVEBMGS00.log
 Instance Service on host sapr3 started
 Instance on host sapr3 started

Ура.. мне не верится..СпасибО!Я ИДИЁТ, УБЕЙТЕ МИНЯ КТО-НИБУДЬ!

шрам

а теперь:

Цитата:

и сделать орг выводы :wink:

Svetlana

ну слава богу

А всем участникам пиво???????????????????????????????

да и кстати пассворд для данного пользователя по умолчанию - это sap :rtfm:

Правила форума

Не запускается SAP/R3 после востановления с резервной копии

Кто сейчас на конференции