Oracle Administration

Oracle Statspack

I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I'd turn is off at 5pm the next day. I did not turn it off...

How do you display the number of rows selected if there are only 4 or 5 rows there?

when i have 6 values for any column, in select statement i get display of 6 rows selected while if i have 5 values for one column i don't get display of 5 rows selected, how to get that display?

What are the know issues with Oracle Flash back recovery area?

What are the know issues with Oracle Flash back recovery area?

Moving from Unix to Windows

We are contemplating moving our databases from the Unix platform to a Windows platform. The Windows servers we are thinking of purchasing are Itanium. We have been told that we can just copy the datafiles from the Unix platform to the Windows platform and everything should work fine. I am not so...

Monitoring Object changes in Oracle

I have to find out who modified objects in dba_objects each week for those changed during that week for SOX perspective. Right now i check with deveplopers for each one, which they don't like. I question is how to find out who modified an object in 9i or 10g (and 11i)?

Items in Pending Transactions of Inventory Module

Hi, We have items in Pending transactions of Inventory Module, they cannot be progressed because The Sales order is already cancelled. The problem is our item reservable is decreased because some of the items were stuck in pending transactions. I tried to use this but it did not work : i2471362.sql

different ways to load data files in oracle database tables

other than SQL Loader

Most common oracle DBA tool.

which tool is most common for database(oracle) administration , instead of OEM?

Moving Oracle from one windows domain to another

We are using Oracle 9 running on Windows 2003 R2. We moved the server into a different domain which is also within an AD environment. We then received the following error codes. RdConnection: Error # -2147467259 OpenConnection Description ORA-01034 ORACLE not available ORA-27101 When we...

Is it possible to install multiple Oracle 10g instances from one installation?

I would like to know if it is possible to install multiple Oracle 10g instances from one installation, or if we have to run the installer every time to create a new instance. If it is possible, how is it done?

ORACLE REAL APPLICATION CLUSTER

Hi to all In Oracle RAC what is menat by split brain syndrome ? What happens when it happens? I mean to say RAC database hangs or crashes ? thanks in advance

ASM State in GMON Trace File

Oracle 10.2.0.3 RAC using ASM: Red Hat Enterprise 2.6.9.44 (RHEL 4.4) I have having problems bringing up a diskgroup in ASM. When I try to mount it, ASM hangs. When I review the GMON trace file, it shows the diskgroup trying to mount and is says "Member state = 4". What's a member state and what...

Database problem of Stop working

We are working in Oracle 10g on Linux Debian 32 bit, A week back we had a problem that i was unable to access any tool of oracle in the morning, Everything was fine previously . when i try to write any command server was too slow and when i use sqlplus it is unable to run no reply then i use top...

Tablespace transporting back to older version of Oracle?

Would anyone know if its possible to successfully transport a tablespace from Oracle 10gR2 back to a version in 9i? Thanks!

Oracle sys and system passwords

I have a database that was created by a person who is no longer with the company. They changed the sys and system passwords but told no one. Is there a way to change (find) the sys and system passwords.

Connecting oracle forms 6i with oracle 10g XE

Hi everybody; my question is that i have installed oracle 10g XE after that i installed forms 6i but when i used to connect it wid oracle it gives out the error message "ORA-12203 TNS:Unable to connect to the destination".Please help me out i am really worried what to do...

hash Bucket--hash Partititioning

What is the hash bucket /hash function in hash partitioning and how can we set the value for hash bucket.Could you please give me brief idea abt this?

Standard Oracle Login and Password for "ADP PC Payroll For Windows"

Hi, I am mirgrating an old ADP Oracle system, and the new DBA does not know the Oracle login and password to the ADP system. Has anyone worked with this system, and do you know the stanadrd Oracle login and password to this ADP version? ADP has not been helpful since the customer left them (but...

media recovery

Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

convert query results to excel format

Hi, I am trying to query users with more than 4 transactions in the past quarter and bring up their address so the marketing department may send out osme mail to them. I am however told that our publishing hose wants these address in excel format. How do I convert/store the query relts into excel...