ORA-01033 : Oracle startup or shutdown in progress
We are getting this error while accessing the Database. Tried restarting the server and “the alter database open” command throws error: ORA-01122: database file 6 failed verification check ORA-01110: data file 6: ‘G:ORACLE102DBCITI10DATAQCSITEADMIN’ ORA-01251: Unknown File Header Version read for file number 6   Please help  

Answer Question   |  December 7, 2009  9:31 AM
ORA-01033, Oracle Database Migration, Oracle Error Codes, Oracle error messages, Quality Center

Updating a test database without disrupting production?
We have an Oracle 9i (9.2.0.3) database and we need to update my test database many times a day. What is the best manner to update my test database without stopping my production database?

Answer Question   |  December 4, 2009  9:05 PM
Oracle 9i, Oracle Database, Oracle database testing, Production environments

Oracle bi-directionals streams propagates source to target but not target to source
Creating Oracle bi-directional streams.  The data will propagate from source to target.  The instatiation was created on the target using datapump.  The target to source does not propagate.  See a trace file that contains the error: instantiate scn is invalid commit scn is valid. Instantiate the source as follows: DECLARE[/pre]   iscn  NUMBER;         BEGIN[/pre]   [...]

Answer Question   |  December 3, 2009  5:55 PM
Data Pump, Oracle Streams, Solaris

oracle 9i installation on Windows Server 2008
i am getting the following error message jrew.exe has stopped error message  when i try to install oracle 9i on windows server 2008

Answer Question   |  December 3, 2009  4:27 PM
Oracle 9i, Oracle 9i installation, Windows Server 2008

Color coding of Toad for Oracle-
Hello all, I am working with Toad, please help me in understanding colors used fo display in SQL Editor of Toad for Oracle. Like what color is used to represent a variable, table, conditions ….. – Thanks

Answer Question   |  December 2, 2009  9:28 AM
Oracle, SQL Editor, TOAD

VB6.0 Connectivity to Oracle
How to connect oracle 9i to vb6.0 using active X data objects? please mention the code.. Thnx …  Saurabh

Answer Question   |  May 20, 2011  5:18 AM
ActiveX, Activex connectivity, ODBC, Oracle 9i, VB6.0, Visual Basic

The most-watched IT questions this week: Dec. 1, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get certified. XENOPHON22, Schmidtw and KevinBeaver all chimed in [...]

Answer Question   |  December 11, 2009  6:21 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

email from developer 6i
can any body help me how to send email through developer 6i reports

Answer Question   |  November 30, 2009  8:39 AM
Oracle Developer, Oracle Developer 6i

connect to Oracle XE using Forms 6i
I can’t make Forms 6i connect to an XE database. Is that even possible? I’m not getting an error message; the Form bulider just closes.  

Answer Question   |  November 30, 2009  7:55 PM
Oracle Forms 6i, Oracle XE

Automatically maximizing screen – JDE
Is there any way to have your screens automatically maximize upon opening them.

Answer Question   |  November 25, 2009  10:29 PM
JD Edwards EnterpriseOne, JDE

The most-watched IT questions this week: Nov. 24, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy software was asked by JuSi [...]

Answer Question   |  December 1, 2009  4:28 PM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Delete and Update in Query Magager
How can I use delete and update statments in Query Manager (QMQ) in OS/400. I can able to create QM Queries for Select Statment but not able to update tables using Delete and Update statment. Please help, a production project in pending for this.

Answer Question   |  November 24, 2009  2:00 PM
iSeries, OS/400, Query Manager

Oracle database access problem over WAN
We are using ERP applications where application serve is at one location and database server at different location. both locations are connected through a 2 MBPS MPLS link ( latency 4-5 ms). problem is that sometimes i can login to the application and sometimes i get TNS packet writer failure error, this happens particularly when [...]

Answer Question   |  November 23, 2009  1:12 PM
Oracle 10g, Oracle Database, Oracle Database 10g, WAN

Display Report Preview on full screen
When a report is executed the output is not displayed in full screen. the end user has to use the maximize button to do so. I would like to have the report displayed on full screen

Answer Question   |  March 30, 2010  12:35 PM
Oracle 10g, Oracle Reports, Oracle Reports 6i

The IT Blog Top 10: Nov. 19, 2009
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for users of Sun’s VirtualBox. 8. Success [...]

Answer Question   |  November 19, 2009  6:46 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

MS SQL Server to Oracle Applications
We have MS SQL Server Data and need to get into Oracle Applications. Data Source – MS SQL database – Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p] Data to be loaded initially to STG table and then to GL journal interface table and concurrent request [...]

Answer Question   |  November 18, 2009  9:16 PM
Oracle applications, Oracle migration, SQL Server

Upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?
How does one upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?

Answer Question   |  November 18, 2009  3:42 PM
Oracle, Oracle 10i, Oracle 8.1.5, Oracle upgrades, QTP Automation

Extract data from dmp-file without Oracle
I need to extract data from a large ORACLE dmp-file (many users, many tables). My idea is to get in TXT or CSV. However, NXTract could not manage this because of the size (buffer overflow error). Is there any other tool out there that can help me…?

Answer Question   |  July 21, 2011  3:08 PM
DMP Importing, NXTract, Oracle

Difference between JDE one world and JDE Eone 9.0 for procurement
I was asked by client for the question. Does anyone can provide some input for me?

Answer Question   |  November 17, 2009  11:28 AM
JDE E1 9.0, JDE One World

Getting error while insert in forms 6i application
hi, i have a database block on my form. the table to which it belongs is having one field naming – ‘RETURN’ . so at the time of insertion it is giving error as Oracle error-Unable to insert record’ and the error is unique constraint violated, but at the same time the record is getting [...]

Answer Question   |  November 13, 2009  11:01 AM
Oracle Forms, Oracle Forms 6i, Oracle Forms Error Messages