topic Re: %MDMS-E-NODBACC, no access to database server in Operating System - OpenVMS

%MDMS-E-NODBACC, no access to database server

Rebecca Goodwin — Wed, 16 May 2007 10:34:34 GMT

First things first:

OpenVms 8.3. with all eco's installed
ABSV4.4(900)

After installing ABS I get an mdms error when creating the database file:

$ mdms create node vms /DECNET_PLUS_FULLNAME=LOCAL:.VMS:: /TCPIP_FULLNAME=vms

%MDMS-E-NODBACC, no access to database server

Actually, all mdms commands I have tried return the same error.

No errors noted during the intallation.
I have uninstalled and installed ABS/MDMS several times.

What would cause these errors?

Any help would be greatly appreciated.

Re: %MDMS-E-NODBACC, no access to database server

John Koska — Wed, 16 May 2007 12:33:47 GMT

Perhaps the database files have not been created yet, if this is a fresh new installation of ABS/MDMS?

I believe MDMS$CREATE_DB_FILES.COM in the [MDMS.SYSTEM} sub-directory creates the assorted empty database files.

You should have the database logical defined and the database files present before modifying them.

ie:

ALAXP4_itjck01> sh log mdms$data*

(LNM$PROCESS_TABLE)

(LNM$JOB_82937B80)

(LNM$GROUP_000001)

(LNM$SYSTEM_TABLE)

"MDMS$DATABASE_LOCATION" = "MDMS$ROOT:[DATABASE]"
"MDMS$DATABASE_SERVERS" = "ALAXP4::"

(LNM$SYSCLUSTER_TABLE)

(DECW$LOGICAL_NAMES)
ALAXP4_itjck01> set def MDMS$ROOT:[DATABASE]
ALAXP4_itjck01> dir *.dat

Directory MDMS$ROOT:[DATABASE]

HOLIDAYS.DAT;1 MDMS$ARCHIVE_DB.DAT;1
MDMS$DOMAIN_DB.DAT;1 MDMS$DRIVE_DB.DAT;1
MDMS$ENVIRONMENT_DB.DAT;1 MDMS$GROUP_DB.DAT;1
MDMS$JUKEBOX_DB.DAT;1 MDMS$LOCATION_DB.DAT;1
MDMS$MAGAZINE_DB.DAT;1 MDMS$MEDIA_DB.DAT;1 MDMS$NODE_DB.DAT;1
MDMS$POOL_DB.DAT;1 MDMS$REPORT_DB.DAT;1
MDMS$RESTORE_DB.DAT;1 MDMS$SAVE_DB.DAT;1
MDMS$SCHEDULE_DB.DAT;1 MDMS$SELECTION_DB.DAT;1
MDMS$VOLUME_DB.DAT;1

Total of 18 files.
ALAXP4_itjck01>

:) jck

Re: %MDMS-E-NODBACC, no access to database server

Rebecca Goodwin — Wed, 16 May 2007 13:52:15 GMT

Absolutely perfect answer to my question! Although the files were there, I deleted and recreated them using the above method. It is now working.

Thank you!

Re: %MDMS-E-NODBACC, no access to database server

Rebecca Goodwin — Wed, 16 May 2007 13:53:05 GMT

close based on above information

Re: %MDMS-E-NODBACC, no access to database server

James Cristofero — Wed, 16 May 2007 14:03:05 GMT

As stated you did note state whether this is an install or upgrade.

Also DECNET Phase IV or DECNET-Plus.

The install should define all these fields.

You may also need to confirm your Decnet-Plus configuration. This may be the result of the error.

Check your NCL Scripts and
MC NCL SHOW NODE 0 all char
MC NCL SHOW NODE 0 all attr

Look for what transports are running

Re: %MDMS-E-NODBACC, no access to database server

Rebecca Goodwin — Wed, 16 May 2007 14:28:05 GMT

Sorry about that. This is a new installation of ABS. Using Decnet Plus and it is configured correctly.

I'm not sure what happened to these files during the installation, but once I deleted them and recreated them using the process you suggested it worked.