- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Errors attaching to Database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2008 04:20 AM
тАО07-24-2008 04:20 AM
Thanks for your help.
SQLMOD :== $SQL$MOD/ANSI_PARMETER
SQLMOD DBREF:DB_WIP_PAY_SQL.SQLMOD
%SQL-F-ERRATTDEC, Error attaching to database WIP_DATABASE
-RDB-F-WRONG_ODS, the on-disk structure of database filename is not supported by
version of facility being used
-RDMS-F-ROOTMAJVER, database format 60.0 is not compatible with software version 70.1
%SQL-F-ERRATTDEC, Error attaching to database WIP_DATABASE
%SQL-F-ERRATTDEC, Error attaching to database WIP_DATABASE
%SQL-F-ERRATTDEC, Error attaching to database WIP_DATABASE
%SQL-F-ERRATTDEC, Error attaching to database WIP_DATABASE
%SQL-F-ERRATTDEC, Error attaching to database WIP_DATABASE
%SQL-F-ERRATTDEC, Error attaching to database WIP_DATABASE
%MMS-F-ABORT, For target DB_WIP_PAY_SQL.OBJ, CLI returned abort status: %X12228DCC.
definition of database:
(LNM$SYSTEM_TABLE)
"WIP_DATABASE" = "UPE$DISK:[PROD.UNPAYENT.DATA]WIP_DATABASE.RDB"
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2008 04:28 AM
тАО07-24-2008 04:28 AM
Re: Errors attaching to Database
This is confirmed by "ROOTMAJVER, database format 60.0 is not compatible with software version 70.1"
Looks like a 'simple' mismatch between the installed RDB version and the Database root being pointed to.
A simple google: +rdb +WRONG_ODS
points to a manual which explains:
http://download.oracle.com/docs/html/A90407_01/ig_ch2.htm
Did it ever work?
What changed?
You may hav to upgrade/convert that database.
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2008 05:35 AM
тАО07-24-2008 05:35 AM
Re: Errors attaching to Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2008 05:45 AM
тАО08-05-2008 05:45 AM
Re: Errors attaching to Database
The DBA seems to think this is an issue with system logicals since a reboot a couple of months ago. How can I check if this is the case?
The DBA says that this setup has worked fine in the past.
Thanks for you help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2008 06:26 AM
тАО08-05-2008 06:26 AM
Re: Errors attaching to Database
Wim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2008 07:13 AM
тАО08-05-2008 07:13 AM
SolutionIf multiversion (MV) Rdb has been installed, then the relevant command procedures are RDB$SETVER.COM and RDB$SHOVER.COM, both located in SYS$SHARE:.
(Rdb 6.0 is ancient, and might have a different filename for the version selection - I'd see what a DIRECTORY SYS$SHARE:*SETVER* showed what Rdb was using. The filenames of these tools changed once or twice, IIRC.)
As for the startup processing and its selection of the Rdb version default, that usually involves a SETVER in the startup or in a login-related procedure somewhere, or (if installed) the non-MV version will be selected.
The -RDB-F-WRONG_ODS and RDMS-F-ROOTMAJVER errors are "normal" and typical and regularly seen in these cases -- particularly when you're migrating older databases forward, and get mixed up on which Rdb is selected. This SHOVER and SETVER tools is a basic and core requirement for using Multiversion Rdb effectively, and for selecting the particular Rdb version.
You can do a one-line invocation with some parameters specified on the @SYS$SHARE:RDB$SETVER tool (good for use in login-related or in system startup command procedures) or you can let the tool prompt you for the version. (Details on the SETVER calling syntax are in the DCL procedure comments at the top of the tool.)
Stephen Hoffman
HoffmanLabs LLC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2008 07:20 AM
тАО08-05-2008 07:20 AM
Re: Errors attaching to Database
The SQL and Rdb tools all have version-specific incantations available when you're running the MV variants. The SETVER stuff sets the version for the default invocation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2008 10:35 AM
тАО08-05-2008 10:35 AM
Re: Errors attaching to Database
Directory SYS$COMMON:[SYSLIB]
DECRDB$SETVER.COM;4 RDB$SETVER.COM;3 RDBVMS_SETVER.COM;4 SQL$SETVER.COM;5
SQLSRV_SETVER.COM;2
Total of 5 files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-05-2008 10:40 AM
тАО08-05-2008 10:40 AM
Re: Errors attaching to Database
SQL> SH VER
Current version of SQL is: DEC SQL V6.0-1
SQL> SH TABLE
%SQL-F-ERRATTDEF, Could not use database file specified by SQL$DATABASE
-RDB-E-UNAVAILABLE2, Rdb/VMS is not available on your system
%LIB-E-ACTIMAGE, error activating image $3$DKB100:[SYS0.SYSCOMMON.][SYSLIB]RDMSH
RP60.EXE;1
%SYSTEM-W-SYSVERDIF, system version mismatch; please relink
Any idea how I can make this version work?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2008 09:39 AM
тАО08-11-2008 09:39 AM
Re: Errors attaching to Database
As for your immediate question:
@SYS$MANAGER:RDB$SETVER.COM
Here's some related material:
http://download.oracle.com/docs/html/A90407_01/ig_ch2.htm#1006345
http://download.oracle.com/docs/html/A90407_01/ig_ch3.htm