Log in GaussDB database of NCE.

Hello, everyone!

Today, I'd like to share a case with you about how to log in GaussDB database of NCE.

Background

After NCE  V1R18C10 change to GaussDB, there is some difference in linking with the database.

1. The database node is switched from the NM node to the DB node.

2. Obtain database user name and password:

Solution Description

1. Check database port and bound IP address

          login DB node OS with ossadm;

          cd /opt/zenith/data

          find ./ -name TNOTNDB

          cat /opt/zenith/data/nmsdbsvr-0-1048/cfg/zengine.ini | grep LSNR_PORT

          cat /opt/zenith/data/nmsdbsvr-0-1048/cfg/zengine.ini | grep LSNR_ADDR

     2.log in database:

         cd /opt/zenith/app/bin/

         ./zsql TNOTNDB/Changeme_123@127.0.0.1:32083

Welcome to leave a message below.

We study together.

Thank you!