RE: dbshut script - shutdown or shutdown immediate

We do shutdown abort. But we do checkpoint before shutdown abort i.e, alter system checkpoint; shutdown abort; Then, while bringing up, we do startup restrict; shutdown immediate; startup Rao -Original Message- Sent: Wednesday, April 02, 2003 11:34 AM To: Multiple recipients of

RE: Configuring Oracle with RAID and OFA

Rich, How did you manage to take hot backups in 90 seconds for 6 GB db size? If you could shed light on the technique, it would be helpful to us. We might also consider your approach, if feasible on our systems. TIA, Rao -Original Message- Sent: Thursday, March 27, 2003 4:19 PM To:

Invalid column in table - how to access it?

I have a table - messages. I couldn't access one column in this table when I do Select name from messages; I get an error message - ORA-00904: invalid column name All the other columns I could select from this table. When I checked the table structure through OEM, I found this column has

RE: Invalid column in table - how to access it?

Hi All, Thanks for the replies. I tried to select the column with --- select NAME from messages; I am getting the ORA-904 error. I would try to recreate the table, import the data and let you know. Rao -Original Message- Sent: Friday, February 28, 2003 2:05 PM To: Multiple recipients

RE: Invalid column in table - how to access it? - SOLVED - Thanks

I recreated the table and loaded the data into it again. Thanks to Guang, Tom Mercadante, Dennis for the suggestions. Rao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 28, 2003 2:39 PM Hi All, Thanks for the replies. I

RE: Debate on rc commands Solaris and Oracle

Title: RE: Debate on rc commands Solaris and Oracle Paula, Shutdown abort is not recommended as the file checkpointing is not done during shutdown abort. If you need to perform shutdown abort, then, it is preferred to bring up the db with startup restrict (so that the users wouldn't

Limiting user connections with DBA Studio

Title: RE: Database Verification Some of our users installed OEM on their local PC's. They connect to the database through DBA Studio. Is there any way to prevent DBA Studio connections to the server? I am thinking of using on_logon trigger but no clue how to catch the connection. Any

RE: Limiting user connections with DBA Studio

Title: RE: Database Verification Todd, The previous DBA has granted them almost all the privileges except DBA privilege. Now, when we tried to take away this SELECT_CATALOG_ROLE, then, these specific users started raising alarms. So, what we are planning is to kill their session the