• 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...

    Dwaltr900 pointsBadges:
  • 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...

    IRFANB1465 pointsBadges:
  • 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!

    Idooracle5 pointsBadges:
  • 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.

    Wynn5 pointsBadges:
  • 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?

    SatyaDBA0 pointsBadges:
  • 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 the...

    Twincalicos0 pointsBadges:
  • 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....

    Sukaina10 pointsBadges:
  • 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...

    Nanditha0 pointsBadges:
  • Lotus Domino Database Structure

    Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler

    Mirkia0 pointsBadges:
  • Oracle sql statement log

    Hi, We're currently trying to debug an application that is running queries thru jdbc/oci against our oracle 9.2 DB. While we have no way of finding out what is going on in the application we would like to trace all the sql statements that are run against our database (including 'select'...

    Pingsc0 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • problem in installing the second oracle home

    Hi all, Iam having problem in installing the second Oracle_Home to install my SAP Test server , iam already having one Oracle_Home configured which is for my development server on the same box which should not be disturbed. In the Oracle Universal Installer iam giving the Oralce_Home and the path...

    Basis50 pointsBadges:
  • ORACLE NOT RECOGNIZING NEW RAM

    We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size...

    Emersokl0 pointsBadges:
  • cannot drop the user

    Hi, I cannot drop the user. dorp user "USERA" cascade; ORA-01940: cannot drop a user that is currently connected But when I check v$session table. I do not see any USERA. This happens on me several times and every time when I face this, I need to restart my database. Is there any better method to...

    Cassidy6o60 pointsBadges:
  • Running a script at specified runtime

    I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

    Columbus0 pointsBadges:
  • Error on installing Oracle 10 software where Oracle 9i software already exists

    Folks, I am working on a Solaris Sparc server trying to install Oracle Enterprise Edition Software. This server already had Oracle 9i software installed. I am setting the ORACLE_HOME by writing on the command line: export $ORACLE_HOME=/oracle/10g. When I echo $ORACLE_HOME I get a return of...

    Wbuker0 pointsBadges:
  • inserts through a database link

    Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to...

    carlosdl65,110 pointsBadges:
  • Using optimizer hints in Forms

    Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...

    carlosdl65,110 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following