Right click on the machine
Power OFF Virtual machine.
Edit settings of VM
Compatibility ->Upgrade
linux coredump path
Check the coredump path:
/var/lib/systemd/coredump/
Verify the output of below command is unlimited:
#ulimit -c
unlimited
How to add windows NFS server share to ESX NFS datastore
1.Enable role "Server NFS " on windows server.
Add roles “File and Storage Services“ -> ‘Server for NFS’ role
2.Create a Folder in c:\ as "NFS1"
3.Right click on the folder and select properties ->NFS sharing ->Manage NFS sharing
Check "Share the folder"
Click "Permisions" -> give read-write permision for the "All Machines"
4.Right click ESXI and Storage->Create Datastore
select NFS option
provide Datastore name" NFS1
Folder as :/NFS1
Server: IP of the windows machine.
NFS datastore creation is completed:
MSSQL AAG Replica secondary showing disconnected error
Error:
You will see the secondary replica is disconnected error as:
Solution:
In this case go to SQL server and check the ERROR log and see the exact error:
Error Log location:
C:\Program Files\Microsoft SQL Server\<MSSQL15.MSSQLSERVER>\MSSQL\Log
I am able to see the error as :
There is no user and permisions.
On Node2 from SQL query run:
GO
CREATE LOGIN [RAN\SQL-AG-VM-Node1$] FROM WINDOWS
GO
GRANT CONNECT ON ENDPOINT::hadr_endpoint TO [RAN\SQL-AG-VM-Node1$];
GO
On Node2 run SQL query
GO
CREATE LOGIN [RAN\SQL-AG-VM-Node2$] FROM WINDOWS
GO
GRANT CONNECT ON ENDPOINT::hadr_endpoint TO [RAN\SQL-AG-VM-Node2$];
GO
Now try a failover and you will see both in CONNECTED
MSSQL Error log location
the error log is located at
C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.
crontab job for running every minute | overwrite file
1. create a bash script in linux :
vi /data/1
*************************
#!/bin/bash
mkdir /data
echo "test file for ">orig
for i in {000..010}
do
yes| cp orig file$i
done
*************************
2.provide executable permisions
chmod +x /data/1
3.Add to cron:
run: "crontab -e " and enter below content:
* * * * * (cd /data && /bin/bash /data/1)
and save the file
4.verify the cron entries
crontab -l
5.restart the crond service:
systemctl restart crond
verify the scrip run everyminute.
Subscribe to:
Posts (Atom)