Recent content by darkman0101

Oh Yeah... DB Server is 9i R2 OEM Console is 9.2.0.1.0 Running Agent on the unix box: Ver 9.2.0.3.0

For the life of me I can't figure out how to do this. The set up is as follows: Database - Sitting on a unix box that has OS account oraxxx which belongs to the dba group. OEM Console - connected to a repository on a Windows PC. Logged on to Windows with a domain user that is not the same as the...

Hi there. I am oracle 8i OCP certified. I want to upgrade to 9i then probably to 10g. A couple of questions: 1) Is it only necessary to do a single "New Features" exam to upgrade? viz there is no practical component? 2) Info on the best study guide is pretty sketchy. Does anyone have any...

Hi there. I'm a bit stumped. I'm trying to create a Stored Proc that will create some temporary tables on the fly. The thing is that the data that populates those tables has selection criteria where one of the values comes from a parameter passed into the proc. For Example: Create Procedure...

Cool, thanks for that. I keep swaying between "This upgrade will go fine" and "I haven't a clue what I am doing". It would have been nice to have a dev box to have a crack on first. As it is I have 1/2 a weekend to upgrade the one live system that the whole company uses... nice. Another...

Hi there, I have been given the task of upgrading our only iSeries (which is a production machine) from v5r2 to v5r3. By the way Ihave only been working with AS400 for about 3 months. I an following the IBM upgrade/install manual but have a question. It talks about checking system values...

Hi there, I am trying to find a qry400 query on an iSeries running v5R2 that someone else wrote. Is there a system table that I can query that will show object names, user descriptions/text etc? Thanks in advance, Jason

Does anyone have the above guide? I have all the others barring this one if anyone cares to swap. Email me at darkman0101_at_hotmail.com

But aren't you really just using the 64 bit (or 32 bit for that matter) to read a file that is in an rman format and having rman rebuild that datafiles from that file? The fact that Rman is compiled for a 64 bit platform shouldn't matter should it? The errors we get are: ORA-19587: error...

Hey there, we wish to create a testing database from our production DB. We use rman without a recovery catalog to do daily hot backups. My question is... if I want to create the duplicate database on a different host do the platforms and Operation Systems need to be the same? Eg if the Prod...

Hey there, we wish to create a testing database from our production DB. We use rman without a recovery catalog to do daily hot backups. My question is... if I want to create the duplicate database on a different host do the platforms and Operation Systems need to be the same? Eg if the Prod...

I have taken for Oracle 8i DBA: Sql PL/Sql, Architecture & Administration and passed Backup & Recovery this afternoon. What should I study for next? Performance Tuning or Network Administration? Which one is more interesting/easier? I don't suppose it matters as I will have to take both but if...

I have been studying for the PL/SQL exam for 8i. Just about ready to sit the exam I think. I don't generally use SQLPlus much though as there are better products for writing queries/procedures. Will the Exam have any questions on formatting output/SQLPlus environment variables? Cheers in...

MSMINNICH, You wouldn't happen to have the URL handy would you? Damned if I can find where it is. Cheers.

I need the developr.hlp file for the crystal control for VB. Can't lay my hands on the CD at the moment. Could someone tell me where to get my hands on it online? Thanks in advance Jas