Oracle Recovery without a good control file
How do I recover without a good Controlfile

Answer Question   |  November 8, 2010  7:24 PM
Oracle, Oracle 10.2.0.4, Oracle control file, Oracle Recovery Manager

Oracle RAC, Error message “CRS-0184: Cannot communicate with the CRS daemon” in ERP app
In an Erp application CRS-0184: Cannot communicate with the CRS daemon when we ware trying to execute ‘crs_stat -t’   version of databse is 10.2.0.4    64bit it is an 12i application on redhat enterprise linux 5 crsctl check crs gives can not communicate to ocr —this is on node 2 in node1 everything is [...]

Answer Question   |  October 18, 2010  11:53 AM
ERP, Oracle 10.2.0.4, Oracle RAC, Red Hat Linux

ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g
I was trying to create a table with primary key based on two columns. Here is the create table statement: CREATE TABLE SECURITY_PASSWORD ( USER_NAME VARCHAR2 (25 BYTE) NOT NULL, USER_PASSWORD VARCHAR2 (25 BYTE) NOT NULL, CREATED_DATE DATE NOT NULL, CONSTRAINT security_password_pk PRIMARY_KEY (user_name,user_password) ); Unfortunately I keep getting error message: ORA-00902 invalid datatype.This is [...]

Answer Question   |  June 26, 2010  5:12 PM
CREATE TABLE statement, Database issues, Oracle 10.2.0.4, Oracle 10g error messages, Oracle Table

I would like to install Oracle database on OS X MacBook
I have looked in the Oracle Technet site for a version of Oracle suitable for OS X.  I downloaded Oracle 10.2.0.4.0 because it said that it was compatible with Mac OS X.  However, when I attempted to install the application, nothing happened.  Upon closer look, the documentation seem to point to Max OS X server.  [...]

Answer Question   |  April 20, 2010  6:23 PM
Mac OS X, Oracle 10, Oracle 10.2.0.4, Oracle Database Versions

Permissions for user Pro C – Oracle
Hi Does anybody know what permission the user need to compile a program with Pro C? If I execute with oracle user it works. If I execute with other user it doesn´t work. I made a test and gave chmod -R 755 under ORACLE_HOME and it works with any user. But I wouldn´t like to give [...]

Answer Question   |  January 20, 2010  7:05 PM
IBM AIX, IBM AIX 5L, Oracle 10.2.0.4

Patrol Compatibility with Oracle 10.2.0.4
Upgraded Patrol repository from 10.2.0.3 to 10.2.0.4. Data loads into repository tables stopped and no errors. How to verify compatibility? And troubleshoot problem?

Answer Question   |  August 21, 2009  9:40 PM
BMC Patrol, Oracle 10.2.0.4, Oracle 10g, Oracle Compatibility