Oracle DBA and RAC DBA Expert

Excellent post very useful http://chandu208.blogs...

2012-05-02T12:33:46.639-07:00

Excellent post very useful

http://chandu208.blogspot.com/
Regards,
Chandra

hola , hace dias llevo con un problema respecto a ...

2012-04-28T12:11:57.490-07:00

hola , hace dias llevo con un problema respecto a los servicios de oracle 11g em. pues no logro levantar el servicio oracleDBconsoleorcl. hey buscado tanto que ya siento agotar. siempre halle información de set oracle_hosname, set oracle_sid. pero no me resulto ami. tengo instalado el oracle en xp sp2. espero que me puedas ayudar. te lo agredeceria por favor.

Hi Satish: Thanks for your reply. Here is the outp...

2012-04-20T08:08:36.033-07:00

Hi Satish:
Thanks for your reply.
Here is the output -
$ srvctl status service -d rac
$

Still I dont see any output after executing the above command. Do I need to do any changes in the configuration of the database?

Thanks for your help.

Vencer, Run the below commands to find the prefer...

2012-04-19T16:52:28.759-07:00

Vencer,

Run the below commands to find the preferred node and available node info, which service configured on which node.
$srvctl config service -d database_name
$ srvctl status service -d database_name

Hope this helps

Run below command to find the status of the servic...

2012-04-19T16:19:00.529-07:00

Run below command to find the status of the service and provide theo output.
$ srvctl status service -d rac

Hi Satish: Thanks for this nice article. I am tr...

2012-04-19T04:20:12.716-07:00

Hi Satish:
Thanks for this nice article.
I am trying to execute the below command to find the Preferred nodes but it dont show any output . No Error also. Just after executing the command the prompt appear -
[oracle@rac1 cssd]$ srvctl config service -d rac
[oracle@rac1 cssd]$

Appreciate for your early reply.

Thanks
Ram

Hi Expert! Very nice post. Thanks! Mahir M. Qulu...

2012-04-17T21:51:31.308-07:00

Hi Expert!

Very nice post. Thanks!

Mahir M. Quluzade
www.mahir-quluzade.com

Can you provide the output of below SQL and also p...

2012-04-17T17:40:20.924-07:00

Can you provide the output of below SQL and also provide the expdp log

SQL> select tablespace_name,file_name from dba_data_files where tablespace_name like '%EXPTBS%';

SESSION_STAMP is a timestamp of the session of a R...

2012-04-17T16:29:52.903-07:00

SESSION_STAMP is a timestamp of the session of a RMAN Job

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com

Very good Article... I had a very similar situatio...

2012-04-17T12:23:48.911-07:00

Very good Article... I had a very similar situation with Undo tablespace and this link helped me a lot...

Hi thanks a lot for very useful info but here what...

2012-04-17T09:08:38.211-07:00

Hi thanks a lot for very useful info but here what is SESSION_STAMP # in v$RMAN_OUTPUT ?

thanks
chandu
http://www.chandu208.blogspot.com/

Dear Satish Sir, while exporting tablespace iam ge...

2012-04-13T00:23:39.563-07:00

Dear Satish Sir,
while exporting tablespace iam getting following errors
ORA-39167 : tablespace exptbs was not found
ora- 31655 : no data or metadata obejects selected for job
however i have created the tablespace exptbs before exporting this tablespace also for avoiding privilege issue i am using system/manager login

expdp system/manager dumpfile=exptbs.dmp directory=export tablespaces=exptbs logfile=tbs.log

Please help me sir

Regards

Shabab Rafi

Thanks for u r nice article

2012-04-03T23:44:55.254-07:00

Thanks for u r nice article

Thanks a lot for posting this write-up. It gave me...

2012-03-06T09:15:55.663-08:00

Thanks a lot for posting this write-up. It gave me a good start with the RMAN new features. I am a big fan of this tool and just enjoy deployint it at any project I get where backups are still done the 'old way'.

Hi, can u explain how to identify which service i...

2012-03-03T21:39:11.954-08:00

Hi,

can u explain how to identify which service is configured on which node and ways to identify them and relocate to the correct node.
please explain preferred current available nodes in RAC

Hi, I have uploaded the Article, please check now...

2012-02-22T15:24:14.004-08:00

Hi,

I have uploaded the Article, please check now.

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com

You can also follow below steps to recover oracle database tablespace.

1. Set undo_management to MANUAL
2. Startup pfile
3. Drop undo tablespace (If it was created wrongly without undo keyword)
4. Create undo tablespace undotbs datafile '??????' size 1M reuse;
5. Shutdown database.
6. Set undo_management to AUTO-
7. Startup

Regards,
Mark

Hello Satishbabu, Thank you for sharing this info...

2012-01-15T21:50:48.251-08:00

Hello Satishbabu,

Thank you for sharing this information. It will help database administrator to resolve problems.

Regards,
Mark Willium
http://oraclerecovery.blogspot.com/

Hi, I liked your article but subscription is paid....

2012-01-15T12:22:33.427-08:00

Hi, I liked your article but subscription is paid. So the PDF can´t be reached.

Regards

You can able to access technical articles like . I...

2012-01-13T13:45:37.185-08:00

You can able to access technical articles like
. IOUG select Journal
. Best Practice Tip book
. Best Practices and Solutions
. Webinars on latest technologies ...etc

Registration is free, join IOUG using below URL and enjoy the benefits.

https://www.ioug.org/JoinIOUG/tabid/71/Default.aspx

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com

hi Satishbabu Gunukula my name hs gabriel simon sa...

2012-01-13T00:40:31.025-08:00

hi Satishbabu Gunukula
my name hs gabriel simon sarr OCA oracle and im till now learning to try to improve my oracle skills and i'd like to know what are the advantage of IOUG group member as your are already inside i see that they give interesting things i'd know more about the subscription!

thanks

kind regards

Due to copyright issue, I am not able to send a co...

2012-01-11T10:01:22.359-08:00

Due to copyright issue, I am not able to send a copy. Please register in http://www.ioug.org/ and you should be able to download the took kit.

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com

hai sathish, i gain so much knowledge from this bl...

2012-01-10T23:10:05.791-08:00

hai sathish, i gain so much knowledge from this blog, thanku for that , just now i saw ur RMAN tool kit , iam planning to download that , but it's not working , if ur free plz forward to my email : ravichand.mca2009@gmail.com

Yes, you can send email with multiple attachments....

2012-01-09T10:48:56.523-08:00

Yes, you can send email with multiple attachments.

Regards
Satish

Hi , is it possible to send email with multiple at...

2012-01-08T22:02:15.315-08:00

Hi , is it possible to send email with multiple attachments ?