issue : ASE user connection

issue:

ASE user connection

Use cases:

 1. If it is ASE installation

 2. If App+DB are on same host or it is a Business Suite Installation.

how to verify:


"1. Switch to syb<SID> and check the log in the file below:
/sybase/<SID>/ASE16-0/install/<SID>.log

2. Error will be in below format:
Number of connections exceeded"


Solution:

"1. Switch to syb<SID>

2. login to isql:
isql -Usapsa -S<SID> -X
go

2. Change user connections:
sp_configure ""number of user connections"",375
go
"

Default user groups assigned for adm user

Reference system
Host1 :~ # id ta1adm
uid=54588(ta1adm) gid=1002(sapsys)groups=1002(sapsys),58045(ta1shm),1025(sapinst),1008(sdba)

Affected system
host2:/ # id CCPadm
uid=100001603(ccpadm) gid=1002(sapsys) groups=1002(sapsys),1025(sapinst),1008(sdba)

How to check the HDB present status

1. su - <sid>adm
2. cd /usr/sap/hostctrl/exe/ 
3. ./sapcontrol -nr 02 -function GetProcessList

08.01.2020 05:49:11
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, GREEN, Running, 2020 01 08 05:22:16, 0:26:55, 84174
hdbcompileserver, HDB Compileserver, GREEN, Running, 2020 01 08 05:22:22, 0:26:49, 84370
hdbindexserver, HDB Indexserver, GREEN, Running, 2020 01 08 05:22:25, 0:26:46, 84418
hdbnameserver, HDB Nameserver, GREEN, Running, 2020 01 08 05:22:17, 0:26:54, 84197
hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2020 01 08 05:22:22, 0:26:49, 84372
hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2020 01 08 05:22:39, 0:26:32, 84877
hdbxsengine, HDB XSEngine, GREEN, Running, 2020 01 08

2EETW152 Cannot open file "trans.log". : Permission denied R3trans finished (0012).

<hostname>:vo0adm 24> R3trans -d
This is R3trans version 6.26 (release 749 - 23.04.19 - 20:19:01).
unicode enabled version
2EETW152 Cannot open file "trans.log".
: Permission denied
R3trans finished (0012).



solution:

<hostname>:/usr/sap/hostctrl/exe # su - vo0adm
<hostname>:vo0adm 17> pwd
/usr/sap/VO0/home
<hostname>:vo0adm 18> ll
total 4
-rw-r--r-- 1 vo0adm sapsys 642 Jan  7 15:18 trans.log
<hostname>:vo0adm 19> chmod 777 *
<hostname>:vo0adm 20> ll
total 4
-rwxrwxrwx 1 vo0adm sapsys 642 Jan  7 15:18 trans.log

How to stop , Start and drop tenant Database in HANA database

1. open one putty session.
2. $ su  - <SID>adm
3. make sure that the present word directory ($ pwd) is /usr/sap/hana/HDB<XX>
4. issue the below command:

                               hdbsql -U system -p <password>  -n vh<xxx><xxx><db>:3<XX>13

       Note: issue the below OS command to make sure the sid

df -h in the DB host, which will give DB<sid>

df -h in the application host,which will give Application <sid>

   5. To check for list of tenant databases available:

                     select * from M_DATABASES
   6.To stop the tenant DB issue the below command:

                 alter system stop database <SID>                     Note: choose one <sid> from step 5 query


   7.To start the tenant DB issue the below command:

                                        alter system start database <sid>

   8. To delete the tenant database permanently along with data in it, issue the below command:
        Make sure of your Tenant DB sid, which executing the below command, As it will delete every thing.

                                  

                                                drop database <SID>