Oracle Enterprise Manager login password error
We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on “google”, solution was “ocijdbc10 file has to be placed in [...]

Answer Question   |  January 16, 2009  5:05 AM
Oracle 11g, Oracle 11g error messages, Oracle 11g security, Oracle administration, Oracle Enterprise Manager, Oracle security, SQLPlus, Windows Server 2003

oracle log for table update infimation
I am a system Administrator, I am having Oracle 10g database server on windows 2000 server in my office LAN network front end is forms & reports 6i. in last 10days 1 user connected to oracle database other than regular forms 6i program and modified one table record column value by update. How can i [...]

Answer Question   |  January 12, 2009  1:22 PM
Oracle 10g, Oracle administration, Oracle security, Windows 2000 Server

How to insert an image file into an Oracle 8i database?
Hi Experts, I am using forms&reports6i with the oracle 8i database. Now i want to insert a image file into the database and i want to access that in reports. I tried the insert statement but i couldn’t. can anyone help me for inserting.

Answer Question   |  June 15, 2010  9:34 AM
BLOB, Oracle 8i, Oracle 8i image storage, Oracle administration, Oracle Forms, Oracle Forms 6i, Oracle Forms and Reports 6i, Oracle image storage, Oracle Reports, Oracle Reports 6i

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 [...]

Answer Question   |  December 4, 2008  8:26 PM
Oracle 9, Oracle 9.2.0.7, Oracle administration, Oracle Database, Oracle performance, Oracle Statspack

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?

Answer Question   |  November 18, 2008  4:09 AM
Oracle administration, Oracle queries, Oracle SQL

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

Answer Question   |  November 3, 2008  2:29 PM
Oracle administration, Oracle backup, Oracle Flashback

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 sure and would [...]

Answer Question   |  November 9, 2008  3:32 PM
Itanium Servers, Oracle administration, Unix, unix to Windows Database Migration, Windows Server 2003

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)?

Answer Question   |  April 7, 2010  6:17 PM
dba_objects, Oracle 10g, Oracle 11i, Oracle 9i, Oracle administration, Sarbanes-Oxley Act, SOX

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

Answer Question   |  September 13, 2008  2:07 AM
Oracle administration, Oracle import/export, Oracle installation

different ways to load data files in oracle database tables
other than SQL Loader

Answer Question   |  August 25, 2008  8:25 AM
Oracle administration, SQL*Loader

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

Answer Question   |  September 12, 2008  3:19 AM
Oracle administration, Oracle DBA

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 subsequently backed out of the changes, everything starts to work [...]

Answer Question   |  May 30, 2008  2:46 PM
Domain management, ORA-01034, ORA-27101, Oracle 9, Oracle administration, Oracle error messages, Windows Server 2003

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?

Answer Question   |  November 13, 2011  2:21 PM
Oracle 10g, Oracle administration

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

Answer Question   |  December 24, 2008  7:44 PM
Oracle administration, Oracle RAC

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 [...]

Answer Question   |  April 14, 2008  2:39 PM
ASM, GMON, Oracle 10, Oracle administration, Red Hat Enterprise Linux

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 [...]

Answer Question   |  February 21, 2008  10:12 AM
Debian, Oracle 10g, Oracle administration

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!

Answer Question   |  January 25, 2008  11:06 PM
Oracle 9i, Oracle administration

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.

Answer Question   |  December 4, 2007  12:29 AM
Oracle, Oracle administration

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 with this.if possible please give [...]

Answer Question   |  June 23, 2010  6:37 AM
Oracle, Oracle 10g, Oracle administration

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?

Answer Question   |  October 10, 2007  2:22 PM
Oracle administration