Yvonne Murphy. Oracle Certified Master. VMware Certified Professional, Member of the Office of the Chief Technical Ambassador VMware.
My role in VMware is to support customers running any Oracle product in a VM. But in all honestly Oracle do a great job of this so that doesn’t keep me busy.
There’s a lot of opportunities for a DBA to make herself useful in GSS though. I’m like a ninga. I go into those black boxes and I do some tricks in the database. Most of the blogs here are those scripts I use.
Do remember a bunny dies everytime you make a chance on one of these databases. so backup first!
The best option for the password is to lower security so it’s not required to enter a password when you log into postgres
Continue reading “disable password protection”
Day to day we have to delete duplicate data from the database.
An upgrade requires Primary key where one didn’t exist before or a db let it guard down and didn’t enforce the PK’s (yeah looking at you postgres!)
Or if an upgrade can’t create a new pk then this is useful. The SQL Server commands to find this are there too.
Continue reading “Removing duplicate rows for all databases”
The easiest way to see the interactions that are going from vc to the database then you can increase logging to see these sql statements.
Continue reading “increase VC logging”
If a vm is being highlighted in the vpxd logs and the reason for vc to crash then it’s always useful to remove this vm from the database to see if it will allow vc to startup.
Continue reading “remove vm from inventory”
On the VCSA you may want to switch to the postgres user to run some postgres commands it may be locked out. The commands below show how to make this user available
Continue reading “switch to postgres user in linux”
If postgres replication is broken you may as well reset it up as opposed to trying to manually move the logs. Here’s how to do it
Continue reading “VRA Postgres Replication”
su – postgres /opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433