Operating System - OpenVMS
1751695 Members
4713 Online
108781 Solutions
New Discussion юеВ

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

 
SOLVED
Go to solution
Rebecca Goodwin
New Member

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

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.


5 REPLIES 5
John Koska
Advisor
Solution

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

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
Rebecca Goodwin
New Member

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

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!
Rebecca Goodwin
New Member

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

close based on above information
James Cristofero
Occasional Advisor

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

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
Rebecca Goodwin
New Member

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

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.