• 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

    • correct my script shell to backup with rman
      Hi EVERYBODY, hope you are doing well, i am not an expert on linux i try to create script shell to backup with rman i did some configuiration regarding some parameter below my script Code: --------- #!/bin/sh export ORACLE_SID=bss export ORACLE_HOME=/home/oracle/10.2.0/db/ cd /home/oracle/10.2.0/db/bin ./rman exit connect target sys/bss { run backup incremen […]
    • Ora 12547 tns lost contact
      Hi My technical envitement mintLinux_18.1_64 bits serena Oracle Data Base 11 Enterprise edition i run the command dbca. the consequence of the database configuration went well until i had arrived to a step where i faced a problem ORA 12547 TNS LOST CONTACT and ih the termnal l found root_mint@mintlinux-oraccle ~/app/root_mint/product/11.2.0/dbhome_1/bin $ db […]
    • Dynamic SQL in a stored procedure
      I am trying to rewrite a Procedure to use dynamic SQL I have attached my procedure. When I try to compile it I get this error: •Project: C:\Users\murray.OLF\AppData\Roaming\SQL Developer\system4.2.0.16.356.1154\o.sqldeveloper.12.2.1.16.356.1154\projects\IdeConnections#Oracle12c+-+D19.jpr •Oracle12c - D19 •Error(405,5): PL/SQL: Statement ignored •Error(406,13 […]
    • Logic in store procedure
      Hi group, I have a requirement for a customer as follow. I have a table with 9 columns and one more with the combination id where we can have 3 columns with double values (1X, 12, X1, X2, 21, 2X) and two triples (two columns of a row with triple value) are allowed by row (1X2). Si I have 72 records with different values (72 rows is an example here) just to e […]
    • Listener trouble
      I am having an issue across all databases on 3 separate environments. Database, listener, application on same local machine Basic simple listener.ora, tnsnames.ora with one SID/ service name used DBCA to create database years ago and netca to configure listener etc. This has been running seemingly without tons of issues till recently there has been many conn […]

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.”

Advertisements

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

%d bloggers like this: