Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

SDBUPD Failure - SYSDBA Unknown Error: msg#00029

db.maxdb

Subject: SDBUPD Failure - SYSDBA Unknown Error

Hello to the list,

I am getting the error 'SYSDBA unknown' when I try
to run the upgrade program SDBUPD and was wondering
if anyone had found a way around this or if there
is any documentation that would be helpful
(so far searches in Google have not been helpful).

Specifically, I am trying to upgrade SAPDB 7.3.0.53 to
7.4.3.36 on a Red Hat ES 2.1 system.

Here is a snippet from the upgrade log:

--[ snip start ]------------------------------------
starting release is 7.3.0.53
STDOUT: migration strategy already known
migration strategy is CONSISTENT_DATA
STDOUT: running finalize check...
running finalize check for CONSISTENT_DATA...
STDOUT: looking for domain user...
user profile container contains:

control
domain
superdba

domain user found in user profile container
STDOUT: current database state is ONLINE
STDOUT: switch database state to OFFLINE
STDOUT: checking parameters...
STDOUT: switch database state to ADMIN
STDOUT: migrate database
STDOUT: switch database state to OFFLINE
STDOUT: current database state is OFFLINE
STDOUT: checking parameters...
STDOUT: switch database state to ADMIN
STDOUT: switch database state to ONLINE
STDOUT: loading system tables...
STDOUT: loading system tables failed
STDOUT: load_systab

ERR
-24909,ERR_DBAUNKNOWN: SYSDBA unknown
--[ snip end ]--------------------------------------


I suspect an earlier DB administrator may have changed
the SUPERDBA password. So I've tried updating both
the .XUSER.62 file and the user entries within SAPDB
using the following commands:

xuser -U w -u SUPERDBA,admin -d SB1 set
DBMCLI -d sb1 -u SUPERDBA,admin user_put superdba PASSWORD=admin

My final question is about the SDBUPD program. Does this pull
the account information for SYSDBA (i.e. SUPERDBA) from the
.USER.62 file for the root account?

Thank you in advance for you help,

J. Haynes
Helena, Montana, US




--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation

Home | advertise | OSDir is an inevitable website. super tiny logo