• Blog
    • Oracle EBS ERP
      • DBA
      • Developer
      • Application
    • Db2 Database
    • MySQL
  • About Me
  • Skills
  • Education
  • Employment
  • Contact

Kapil

  • Home
  • Kapil
Backup of Database Online & Offline through Shell Script

Database backup can take through below shell script which is more easier then enter manually command. Note : Modify location of backup & email address as per requirement in script....

/ Posted by Kapil
SQL1117N – ROLL-FORWARD PENDING Error – after restore the database

After restore the database sometimes face error during the connect the database. SQL1117N A connection to or activation of database   "<DBNAME>" cannot be made because of         ...

/ Posted by Kapil
Compare two databases / schema

Some application need multiple databases for different module to vary purpose so DBA created multiple database on same server and it's very difficult to identify difference between the databases because...

/ Posted by Kapil
Generate execution plan of script

Developer develop script for db2 which is sometimes take huge load so need to take necessary action which is tuned the script. For tuning purpose DBA has to generate the...

/ Posted by Kapil
Backup & Restore Database Online & Offline Manual Steps

In DB2 offline database backup can be taken through below command  $db2 backup database <database name> Backup successful. The timestamp for this backup image is : <snapshot id> In DB2...

/ Posted by Kapil
Concurrent request completed with Error msg: Record is currently being worked on by another user

Sometimes concurrent request completed with below error message :  Message :Record is currently being worked on by another user,Please try to update it later.no. of OE messages :1Error msg: Record...

/ Posted by Kapil
APP-PER-50022: Oracle Human Resources could not retrieve a value for the User Type profile option

APP-PAY-50022 error occur in HRMS module so need to take given necessary action to resolve this error. (Doc ID 177301.1) Follow the below steps to resolve the error : Switch...

/ Posted by Kapil
APP-PAY-06346: This person does not have a current period of service or period of placement

APP-PAY-06346 error is common in HRMS module so need to take given necessary action to resolve this error. Follow the below steps to resolve the error : Find the person...

/ Posted by Kapil
1 2 3 4 5 6 7
Categories
  • Application
  • Db2 Database
  • DBA
  • Developer
  • MySQL
  • Oracle EBS ERP
o
  • Extract & restore single mysql table from backup of databaseSaturday - September 04, 2021
© 2019 KS is proudly powered by Kapil Savaliya.