Most common oracle DBA tool.
which tool is most common for database(oracle) administration , instead of OEM?
View Answer
| Jun 20 2008 3:19 AM GMT
| asked by
Aqmemondba
Oracle DBA, Oracle administration
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 # -2147467259OpenConnection Description ORA-01034ORACLE not available ORA-27101When we subsequently...
View Answer
| May 27 2008 2:46 PM GMT
| asked by
Xxxxxxxxxxxxxx
Oracle administration, Windows Server 2003, Domain management
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?
View Answer
| Apr 28 2008 2:21 PM GMT
| asked by
OracleATE
Oracle 10g, Oracle administration
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 are...
Answer Question
| Apr 14 2008 2:39 PM GMT
| asked by
Dwaltr
Oracle administration, ASM, 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 to run no reply then i use top...
Answer Question
| Feb 21 2008 10:12 AM GMT
| asked by
IRFANB146
Oracle administration, Oracle 10g, Debian
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!
View Answer
| Jan 24 2008 11:06 PM GMT
| asked by
Idooracle
Oracle administration, Oracle 9i
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.
View Answer
| Nov 30 2007 0:29 AM GMT
| asked by
Wynn
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...
View Answer
| Oct 15 2007 6:37 AM GMT
| asked by
Adil
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
| Oct 10 2007 2:22 PM GMT
| asked by
SatyaDBA
Oracle administration
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...
Answer Question
| Sep 26 2007 5:08 PM GMT
| asked by
Twincalicos
Oracle administration
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...
View Answer
| Apr 7 2007 5:04 AM GMT
| asked by
sukaina
Oracle, Database, DB2
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...
View Answer
| Mar 19 2007 11:50 AM GMT
| asked by
nanditha
Oracle, Windows, Oracle administration
Lotus Domino Database Structure
HiI 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 advanceMirkia Sadler
View Answer
| Feb 22 2007 12:56 AM GMT
| asked by
mirkia
Database, Oracle, DB2
Exchange 2000 server and ms outlook 2000 installation,configuration
Hi,I am going to deply MS Exchange 2000 server in my organisation, Before that we have no message system, Now we have 200 systems of windows XP/Windows 98 with MS Windows 2000 Advanced Server. Pls guide me how to Install and Configure MS Echange 2000 Server and MS Outlook 2000.What r the parameters...
View Answer
| Jan 8 2007 11:09 PM GMT
| asked by
chinmoymohanty
Exchange security, Hardware, Cabling
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' statements)....
View Answer
| Dec 4 2006 4:13 AM GMT
| asked by
pingsc
Oracle, Oracle administration
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...
View Answer
| Oct 24 2006 11:28 AM GMT
| asked by
108108
Database, Oracle, DB2
Urgent Help
I have some doubts related to oracle database..... I am in ECC 5 implementation project (OS: Windows, DB: Oracle) My Question....... After Installing ECC 5 the default database size is around 50 GB, some 300 GB HDD is allotted to database , the client is saying to utilize the remaining 250 GB (300...
View Answer
| Oct 16 2006 6:44 AM GMT
| asked by
abtest
Oracle administration, Availability, Backup & recovery
sql update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Please I need an sql command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype.My oracle database is on windows 2003 environment.Eg: The row in question reads '063150987' and I want to replace the fourth...
View Answer
| Oct 6 2006 11:26 AM GMT
| asked by
IdongesitDaniel
Oracle, Database, DB2
error in connection between oracle8i&developer2000
I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...
View Answer
| Sep 18 2006 4:46 AM GMT
| asked by
POWERINIT
Database, Oracle, DB2
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 to...
View Answer
| Aug 30 2006 9:32 AM GMT
| asked by
basis5
Oracle, Oracle administration, Installation
