Tag Archives: dba

Batch Script – Reading parameter file into variables

Hi folks, quick tip on how to easily read a parameter file from a batch script. This is an idea I had to make the life easier when trying to troubleshoot connection issues from client to server and I had … Continue reading

Posted in Scripts | Tagged , , , , , , , , , , , | Leave a comment

Move RAC database from one diskgroup to another in ASM (Manually)

This approach is quite annoying because it has a lot of steps and things to consider, yet here goes a summary of how it could be done in a 3 node RAC as example: Scenario: Database is TSP, instances are … Continue reading

Posted in ORACLE Database | Tagged , , , , , , , , , , , , , | 2 Comments

Must have free tools for DBAs

This is not news to most DBAs, but I’ll list my favorite free tools anyway. Assuming you are using Windows on your laptop, here is a list of free tools that I really enjoy and personally consider a “must have” … Continue reading

Posted in ORACLE Database | Tagged , , , , , , , , , , , , , | Leave a comment

Errors while creating DBConsole

Problem: You receive one of the following errors while creating DBConsole ORA-24344, ORA-04063, PLS-00201

Posted in ORACLE Database | Tagged , , , , , , , , , , | Leave a comment

Reconfiguring the Oracle Enterprise Manager

For many reasons you may need to drop the OEM and create it again, for example, to move an instance from a server to another. Here are simple steps to reconfigure the OEM.

Posted in ORACLE Database | Tagged , , , , , , , | Leave a comment

Identify MSSQL Database ID

To identify the DB ID of the current database run the command: select db_id() go To identify the DB IDs of all your databases, run the command: use master select dbid,name from sysdatabases order by dbid asc go

Posted in SQL Server | Tagged , , , , , , , , , , , | Leave a comment

How to send message to single user in SAP

Sometimes you may need to send a message directly to a specific user… the function TH_POPUP is very handy in these cases, all you have to do is: Go to T-Code SE37 and execute the function TH_POPUP by pressing F8

Posted in SAP Basis | Tagged , , , , , , , , , , , | Leave a comment