How to Check Bank Account, Aadhaar Linking Status with HP Gas Online

Generally we submit the documents to the HP gas agency for linking the bank account and Aadhaar. But it takes couple of days to update the gas account with the bank account etc. You can verify the details online with following steps. It is very easy to check the HP gas and bank link status.

How to Remove Duplicate lines from Unix vi Editor file

Sometimes we have the requirement for removing the duplicate lines from the text file. For that we can easily use vi to remove the duplicate lines instead of using any other scripts or tools. Here are the options to remove the duplicate lines from the vi file.

How to Copy Only Contacts, Notes and Messages from iTunes after iPhone Factory Restore?

Recently I had a requirement to restore the phone to the factory default and copy only Contacts, Notes and Messages because of the LowMemory issues with my phone. I have faced lot of issues after the iOs 7 upgrade and LowMemory issue was one the one of the major one. It used to crash at least one or twice because of the low memory issue and it used to log in diagnostic report. (Settings->General->About->Diagnostics&Usage->Diagnostics & Usage Data). To fix that issue I restored the phone to the factory default and restored only contact, message and notes.

Fix: iPhone Old Messages are not Indexing in the Spotlight search after the iOS 7 Upgrade

I have done the iOS 7.1.2 upgrade in my iPhone 4 recently. My iPhone was pretty stable with the iOS 6.0.1. Due to some mandatory requirement for the OS upgrade I have performed the iOS 7 upgrade. After upgrading my iPhone 4 to iOS 7, I feel there are lot of positives and negatives. The iOS 7 gives new look and feel to the phone but I lost my stability with the phone. Lot of performance issues started with the phone like it won’t respond to our touches as looks like the phone is quite busy. Sometimes the apps are getting crashes.

Database in READ WRITE Mode; desc dba_ gives error ;ORA-04043

Error Description:
The database was working perfectly and there was no major changes done in the database. Database is in Open mode (read write); But still the describe the data dictionary views like DBA_tables gives following error.
SQL> desc dba_tables
ORA-04043: object dba_tables does not exist
Solution Description

Solve ORA-39170: Schema expression 'OPS' does not correspond to any schemas

Error Description:
Data pump expdp failed with following error message.
$ expdp directory=exp_dir schemas=ops$jobs dumpfile=exp.dmp logfile=exp.log
Export: Release - Production on Thu Sep 4 07:30:24 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Release - 64bit Production
ORA-39001: invalid argument value
ORA-39170: Schema expression 'OPS' does not correspond to any schemas.

How to Find out / Check SGA and PGA size of Oracle Database?

SGA Size
Generally SGA_TARGET shows the value of SGA. It can be increased up to sga_max_size.
But if you have enabled automatic memory management the (non-zero values for Memory_ parameters) the value for the memory_target will be consisderred for the SGA.
In below mentioned example automatic memory management is enabled and its value is 10G.


dba topics. Copyright 2011-15 All Rights Reserved | Site Map | Contact | Disclaimer | Google