• About Me

    Maxwell Miranda
    Oracle DBA Consultant.
  • Category

  • Archives

  • My Blog Calendar

    November 2009
    M T W T F S S
    « Oct   Jan »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    30  
  • RSS Oracle Feeds

    • Rman not deleting obsolete backups
      Hi all I am trying tgo maintain my RMAN Catalog. My RMAN retention policy is set to recovery window of 28 days. RMAN> report obsolete; Report of obsolete backups and copies ( Shows a bunch of obsolete backups and copies dated from 18-JAN-15 to 22-JAN-15) I run the following command to delete the obsolete backups reported by RMAN. RMAN> delete obsolete; […]
    • Hate to be that guy but..
      Hi everyone, my name is Jack and I am new to the forums here. I have gone through and read through the "how to ask a question" thread a bit, and still find myself a bit confused on a few things: *Background:* After searching through this site as well as other DBA forums, I am still a bit unclear as to the specific approach to take with my education […]
    • Partitions?? I haven't a clue what there asking for? where would I look?
      The following tables have partitions without any rows (NUM_ROWS). Partitions with blocks assigned are wasting space unless they will be reused. The Attached report details partition ids and whether partitions were found to contain rows (ROW_COUNT), the timing of stats collection can cause a difference. . Can you review : . - Whether partitions are being left […]
    • How to skip constraints validation for a transaction permanently
      Below is the techinical issue that I am trying to see if there is a way out: (I simplified the issue as much as I could to give you overall idea. ) Platform: Oracle Version: 11.2.0.4 OS: CentOS 6.4 There are two schemas named SCH01 and SCH02 on databases DB01 and DB02 respectively. The schemas are totally identical and their definition match. The data in the […]
    • Data getting deleted from Table Unexpectedly every Wednesday Morning
      Team, I have a peculiar situation where Data from a Oracle Table is getting deleted unexpectedly every wednesday morning. Now, we checked if there is any deleted script scheduled to run on that 'table' but found that there were none. Can you please provide some pointers for us to explore more? Regards, Vikram
    • ksh: ./install.sh: not found
      Hi, Im trying to install application in a database. But install.sh was unable to run. *oracle@xx09:/rpm/application # ./install.sh ksh: ./install.sh: not found.* *oracle@xx09:/rpm/application # ls -lrt total 240 -rw-r--r-- 1 oracle dba 23388 Dec 30 2011 antinstall-config.xml -rw-r--r-- 1 oracle dba 2314 Dec 30 2011 ant.install.properties.sample -rwxrwxr-x 1 […]
    • 12c EM Cloud Control Installation Fail
      I am trying install 12c Enterprise Manager Cloud Control on a lenovo IdeaPad Laptop. Windows 8. (Intel® Core i5-3210M CPU (2.5 GHz) X 2, 6 GB RAM, can't find swapfile size, but it passed the pre-req.s check, 454 GB free disk space) I created a repository database for oem purposes.. What happens in the Installer , is that I get past all prerequisites , a […]
    • when users are trying to access any task from Fusion application home page, they are
      We have installed HCM and CRM modules on Fusion Application 11.1.7 version. This is 2 node architecture ie IDM components installed in one node and Fusion components installed in another node. We are able to start the IDM components and Fusion components successfully, but when users are trying to access any task from Fusion application home page, they are ge […]
    • IEPostStringrequest
      Hi While saving an image in an application which is captured using a webcam we get an error message IEPostStringrequest.image upload failed while saving the image to an oracle database. Has anyone seen this issue before? any suggestions to troubleshoot?

A little additional info on hc_ files:

“Q1: What is the $ORACLE_HOME/dbs/hc_.dat file?
A1: The $ORACLE_HOME/dbs/hc_.dat is created for the instance health check monitoring. It contains information used to monitor the instance health and to determine why it went down if the instance isn’t up. The file will be recreated at every instance startup.

Q2: What happens if the $ORACLE_HOME/dbs/hc_.dat file is deleted?
A2: Per Bug 4645405 UNABLE TO START DB – ORA-7445 [KSIHSMRINI()+152] [SIGBUS],
if you replace the file with an empty “dummy” copy, you will get an ORA-7445 error. Therefore, if the file gets deleted on the fly while the database is up, or if the file is replaced with a 0 byte file, simply delete the file and restart the database. The file will be correctly recreated at the next database startup.”

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: