Forum Replies Created
-
Posts
-
You can check the following OTN discussion for this:
Hi,
As you mentioned earlier, and that i missed….. You are using this on windows ..
The syntax which I have mentioned is not for windows but will work only for unix platforms only..
Hi,
Do not copy-paste the command from link as the character ` will change.
Please write the command manually and check again.
Hi,
You are using :
date ‘+%d%m%Y_%H%M%S’
but you have to put the ` sign before the “date” and end with the same after S’.
You can refer to following link for the details:
Cheers!!!
I am not aware of the installer you are talking about, but you can use service name to connect to the rac instance if the service name is mapped in the tnsnames.ora file.
If you have configured SCAN while setting up RAC then you should give the SCAN name to connect to DB.
What do you mean by following line:
“when my prod ask for db” ??
Have you taken the backup of archivelogs when you issued the rman backup?
If not, then switch the logfile and make backup of archivelogs with your datafile backups, and try the restore again.
The backup script should look like:
backup format ‘/u01/PROD/df_t%t_s%s_p%p’ database;
sql ‘alter system archive log current’;
backup format ‘/u01/PROD/al_t%t_s%s_p%p’ archivelog all;
Hi Pratheep,
Processes with status “D” cannot be killed at all. They are in “D” status because they are sleeping and waiting for a resource like “Kernel lock” etc. which they will never get.
If you are seeing these ospid in v$process they will not allow “shutdown immediate” or “shutdown abort”.
The only way to remove such processes is to “reboot” server.
These processes cannot be traced down.
Check If you can apply Dead Connection detection (DCD) to avoid such situations in future.
Cheers!!!
1. For errors “FAILED TO START ASM INSTANCE”:
Check your sqlnet.ora file, if there is any line like: SQLNET.AUTHENTICATION_SERVICES=(NTS)
Remove this line and try again.
2. For vip not getting started “CRS-1006: No more members to consider”:
It is very difficult error to sort out. You have to set tracing to know the exact reason for this.
I had this issue one time and eventually I had to recreate the entire system. But you can try to Remove the VIP resource and add it again and see what happens. Also what is the output of :
$srvctl config nodeapps -n <nodename> -a -g -s -l
Regards:
Saurabh Sood
What do you mean by installing ASM??
Are you trying to start ASM instance and getting these errors?
What is the command that you are using?
Is ASM and Oracle home are same?
Check the “STATE” of ASM resource using “$ crs_stat -t”
If it is UNKNOWN then use “crs_stop -f <resource_name>” to stop the resource and then try to start again.
– Saurabh Sood
Hi Alok,
Here is a very quick reply (The first very basic thing):
In 9i there is no EXCLUDE clause. To use EXCLUDE you have to use DATAPUMP.
In 9i :
1. Get the list of all tables by using :
select table_name from dba_tables where table_name not in (those 20 tables) ……and some more clauses here….
2. Now you have a list of all the tables that you want to import. Use TABLES= clause with imp : use $ imp help=y also
3. prepare a par file and do the import.
Cheers!!!
Saurabh Sood
Hi,
This error shows some issue with writing to files, but the file number and block number is not shown in the error.
Is there any ora-600 in the alert log of primary or standby database at the same time when this error occurred.?
– Saurabh Sood
Hi,
Try to put the following parameters in this pfile:
*.cluster_database=true
*.cluster_database_instances=2
*.instance_type=asm
Regards,
Saurabh Sood
Hi Juan Carlos,
With Oracle 8 there was no RAC. It was OPS at that time.
With Oracle 9 and 10 you can install RAC and using VMware will be handy.
It will depend how you will be using RAC in real time and then decide on using virtualization or real environment. If you decide to use virtualization then also check out the paravirtualization support for RAC.
Cheers!!!
Saurabh Sood
