[Amit Bansal]

Hi,

Could you actually let us know what exact command you used to shutdown the database. Also give us the full alert log content after you issued shutdown.

ORA-1013 would normally arise when you press Ctrl + C after issuing a command at sqlplus prompt..

-Amit

[Amit Bansal]

I have seen dbca taking time when all options like JVM,XML , OLAP are chosen. By default all these are checked in and you have to uncheck them if you do not want it. Did you see the place where DBCA was taking more time? was it during data dictionary creation phase?

-Amit

[Amit Bansal]

Hi,

Just to add to Suarabh’s reply. You can audit select’s in database using schema level auditing. e.g audit select on employees will log selects on the employee table.

In case of FGA ,we can do fine grained auditing i.e we can define filters and also do auditing at column level.

[Amit Bansal]

1) Yes, you need to use only one ASM and CRS version.

2) Yes, in this case it will support 10.2 and 10.1 databases

3) Yes it can support. But again if there is any feature which is available in newer release , you will not be able to use it with lower release database. Starting from 11g, you have COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes which specify the compatibility settings for Oracle ASM and database instances. Check following for more detail

http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#CHDDIGBJ

[Amit Bansal]

Rinku,

As we cannot run database with lower CRS/ASM version, so I would suggest that you upgrade the existing 10.2.0.2 CRS and ASM to 10.2.0.4 and then create new database in new DB home. So your configuration will look like

CRS running on 10.2.0.4

ASM running on 10.2.0.4

DB1 running on 10.2.0.2 from ORACLE_HOME1

DB2 running on 10.2.0.4 from ORACLE_HOME2

[Amit Bansal]

Rinku,

You can use the same Oracle home for creating database (use DBCA to create database). You do not require multiple homes for running multiple databases.

Even if you require two different Database Oracle homes, you can just install oracle database software in new home and use the same CRS for Clusterware.

[Amit Bansal]

Cool!! Do update ASM alert log entry also in case issue does not resolve..

[Amit Bansal]

Cool!! Do update ASM alert log entry also in case issue does not resolve..

[Amit Bansal]

Hi Satya,

Looking at description for error ORA-2970 we see following

<br />
oerr ora 29760<br />
29760, 00000, "instance_number parameter not specified"<br />
// *Cause: The init.ora file did not contain a value for the instance_number<br />
//         which is required to identify this instance to other instances of<br />
//         the database running on the same cluster<br />
// *Action: Assign a value to the instance_number parameter in the init.ora<br />
//          parameter file<br />

So it looks like the instance_number parameter is not specified. Or it could be that instance is not able to access the correct spfile. Is your ASM spfile on OCFS? If yes, can you check if it can access it.

Cheers

Amit

[Amit Bansal]

Hi,

I have not encountered this error earlier. Did you try searching metalink.

Also what happens when you use schema name to identify the table. e.g

CREATE SNAPSHOT snapshot1

REFRESH FAST START WITH SYSDATE NEXT SYSDATE+1/24

AS

select * from scott.table1;

Cheers

Amit

[Author]

Posts