OPSCenter 7.7.1 - dbisqlc - "Database server not found"

Is the database server online?

run

opsadmin -monitor

Yes, I can login to webgui. OPSC is runnig properly.

Command returns (Windows :-) ):

c:\Program Files\Symantec\OpsCenter\server\bin>opsadmin.bat -monitor
Invalid arguments
"HELP:opsadmin.bat [ start | stop ]"

Database server service is running:

c:\Program Files\Symantec\OpsCenter\server\bin>sc query SQLANYs_VERITAS_OPSCENTE
R

SERVICE_NAME: SQLANYs_VERITAS_OPSCENTER
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 4  RUNNING
                                (STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0

Regards

Madej

If you're trying to connect remotely, check your database's server.conf file (C:\Program Files\Symantec\OpsCenter\server\db\CONF\server.conf) and see if it still has the LocalOnly=NO

If I remember correctly, when I did this upgrade my conf file got reset and I had to recover it. 

If thats not the case, run C:\Program Files\Symantec\OpsCenter\server\db\WIN64\dblocate.exe and make sure it lists your DB. Also, tell us where are you running dbisqlc from?

server.conf file contains:

  -n OPSCENTER_OPSCENTER -x tcpip(LocalOnly=YES;ServerPort=13786) -gd DBA -gk DBA -gl DBA -gp 4096 -ti 0 -c 256M -ch 1024M -cl 256M -zl -os 1M -m  -o "C:\Program Files\Symantec\OpsCenter\server\db\log\server.log" -m

This is default.

But I run dbisqlc localy, so this shouldn't matter.

And dblocate found my database as I expected:

c:\Program Files\Symantec\OpsCenter\server\db\WIN64>dblocate.exe
SQL Anywhere Server Enumeration Utility Version 16.0.0.2095
Server Name           Address
-----------           -------
opscenter_opscenter   opscenter:13786

1 server found

It is strange.

Regards

Madej

Post exactly what you're entering, screenshot please.

Two screenshots attached.

Regards

Madej

Put the server name in there too

c:\Program Files\Symantec\OpsCenter\server\db\WIN64>hostname
opscenter

Port 13786 is opened, I can telnet on it.

Before upgrade I could connect without problems in the same way.

Maybe the problem is that I have tested the backup/restore of database using dbbackup command. But I don't think so. Few times I was doing this and always was ok after that.

Regards

Madej

:-))))

You're wright. I feel so stupid.

But I am pretty sure I have tested this way.

Thanks and sorry for wasted time.

Regards

Madej