MaxDB not running
We just installed a new MaxDB(7.9.08.01) on a linux machine. We wanted to use the tool SAP MaxDB Database Studio to manage our databases. However, we cannot create a new database: It says "-813 Cannot connect to host localhost:7210[Connection refused], -813."
And then we tried dbmcli(Database Manager CLI). However, we cannot do anything with any database although we can create. When we run the command db_state, it outputs :
-24936, ERR_DBNORUN: Database instance is not running
19, Error while using the file ID 'RunDirectory'.
-24979, ERR_XPNOTFOUND:Parameter RunDirectoryPath not found
-24748, ERR_FILEOPEN: Error opening file MAXDB50
" (maxdb50 is the db instance)
Any help is high appreciated,
Thank you very much in advance,
Yashwanth Kethineedi replied
The error: 813 Cannot connect to host localhost:7210[Connection refused], -813."
Before you add the server to the Database Studio to manage, you need to make sure that the x_server and the globallistener are started.
Run the following command as administrator and let me know the ouput- Comand: "sdbregview -l"
Run the dbmcli commands as a user in the sdb group or the root/administrator user - because other users will not have access to the Database Runtime folders.
Adjust the database instance parameter RunDirectoryPath. You must adjust the value of the parameter RunDirectoryPath accordingly. You can convert the parameter using the following command:
dbmcli -d <SID> -u control,<passwd> param_put RunDirectoryPath