Oracle DBA

U.S. government sues Oracle for tens of millions of dollars June 18, 2010

Filed under: Oracle — gaphydba @ 4:37 am

The U.S. government is suing Oracle Corp. for denying it significant discounts on software purchases the vendor routinely gave to its commercial customers. The government is claiming damages as high as $169 million in the Oracle lawsuit.Go and read it


SOME Errors in Oracle and their solutions June 10, 2010

Filed under: Errors,IT,Oracle — gaphydba @ 4:20 pm

SQL> ORA 12545 Connect failed because target host or object does not exist

Cause: The address specified is not valid, or the program being connected to does not exist.
Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps “oracle” is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.

SQL> ORA-12541: TNS no listener

Cause: Listener for the source repository has not been started.

Action: Start the Listener on the machine where the source repository resides.

manually u cant do by  $ORACLE_HOME/bin/lsnrctl start FOR UNIX IN CASE  ON WINDOWS goto control panel / services
u can see the listenerservice for the sid u have created.
start it!

ORA-01665: controlfile is not a standby controlfile

Then ‘copy’ standby control file to other host and be sure its being used.

1) use an unusual name when you create it
2) verify it is transferred successfully
3) verify it is going in the right location by examining spfilE

4. verify that you are using the control file that you think you created in the alter database command. use the TO ‘c:\somwhere\stdby.ctl’ option of the command.