1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Oracle

Oracle Gets Restarted every 60 minutes

Monday, 25 September 2017 18:36

During one of the critical upgrade cut-over activities, we got into a situation where ORACLE instance was getting restarted in a periodic interval (every 60 minutes), that too during the R3load import.

Background :

Read more...

ORA-01075: you are currently logged on

Monday, 25 September 2017 18:36

Below error message is thrown when the database was not stopped properly / when it has shared memory problems.

Error Message :  ORA-01075: you are currently logged on -

Read more...

R3trans could not connect to database after upgrading to Oracle 11g

Monday, 25 September 2017 18:36

 

Symptom:

 

After upgrading the SRM system database to Oracle 11G (11.2.0.3), R3trans could not connect to database with the error message mentioned below. Even after changing the schema and system password, the issue did not get resolved.

 

Read more...

Tablespace Monitoring and Alerting Script

Monday, 25 September 2017 18:36

 

Script to Monitor Oracle Tablespace

Here is the script that can help you monitor the tablespace and alert when the threshold value is reached, it involves three different (Oracle, MS-DOS and VBScript) development techniques. Once you are done with the creation of the script, you may use the windows scheduler to run the script at a pre-defined interval. Make sure that you are able to connect to the database from the pc/server where you are planning to run all these scripts.

 

Read more...

Oracle