• switching between instances without down time

    I am installing a new warehouse. I will be running two instances on the same physical server. I plan to load data into one instance while the other is being used for reporting. At the completion of the load process, I need to point the new user connections to the just loaded instance and allow the...

    Lfelder0 pointsBadges:
  • Best IDE for building JSP pages

    This is just for educational purposes. I want to build some JSP pages for a university project, and I'm looking for a J2EE IDE (better if free), but I'm, not sure which is best or easiest to use. I have taken a look to Net Beans 3.6 and I like it, but it's too heavy for my computer. Also I tried...

    carlosdl69,510 pointsBadges:
  • Upgrading Oracle on Windows 2000

    I am preparing an Oracle upgrade from to on a Windows 2000 environment. The server has 3 instances on it, and the possibility of upgrading them one at a time is a real one. My question is, is it OK to just run the upgrade assistant against each database one at a time, and let it...

    Mljsher0 pointsBadges:
  • C# sample code for copying a table from oracle to ms sql with ODP.NET needed

    I want to copy a table from an oracle database to a sql server using the odp.net provider. Because I just have the .NET Framework SDK and the Eclipse C#-PlugIn it is very difficult for me to figure out how I can code this in detail. I successfully read from an oracle table with a datareader object...

    Mt690 pointsBadges:
  • Db2 to Oracle porting

    I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu

    Dpd08090 pointsBadges:
  • ORA-01033 Oracle Initialization or Shutdown in progress & cannot log into sqlplus.

    My Database is in limbo at the moment and i'm trying to get it shut down properly and restarted. I'm getting the ORA-01033 and from I understand from reading posts..i'm to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges....

    Jonnyopera0 pointsBadges:
  • Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?

    We are replacing an old NT 4.0 server with a new Windows Server 2003, the new hardware (a Compaq ProLiant) equipped with Intel Xeon CPU. The old server was running a couple of database instances in Oracle 8i Standard Edition, which we want/need to replace with the 9i version. The installation files...

    Onilke95 pointsBadges:
  • Oracle and gcc compiler

    We just upgraded to Oracle When we try to compile a program, we get the following error: ld: fatal: file /u100/app/oracle/product/9.2.0/lib//libclntsh.so: wrong ELF class: ELFCLASS64 error when trying to compile with GCC version 2.95.3. I was wondering if anyone had run across this, and,...

    Mljsher0 pointsBadges:
  • OBJECTIVE comparison (with independant references) between MS SQL and Oracle 10g

    Morning all, I'm looking for links or actual documents comparing these two RDBMS's that do a good job of keeping their points "personal preferance bias-free". Gartner often is expensive and was hoping for other avenues of comparison. The focus I'm looking towards are comaprisons between:...

    Scorn2420 pointsBadges:
  • ORA-03113: end-of-file on communication channel, ORA-07445: exception encountered:

    hi I got this message when i restarted the database after a abrupt shutdown and the alert log error is below THe database is no archive log mode we had to fix the problem by using logical dumps I still have a test case which i would like to fix oracle error ----------------- SVRMGR> connect...

    lokeshrana0 pointsBadges:
  • Alternate way to stop Oracle Services on Win 2K Server

    Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

    carlosdl69,510 pointsBadges:
  • Alternate way to stop Oracle Services on Win 2K Server-2

    Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

    carlosdl69,510 pointsBadges:
  • Database Replication

    Hello, i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?

    Mysterky0 pointsBadges:
  • ora-1555 during data purge

    We have a PL/SQL script that selects then purges data from a table row-by-row. We populated our Test environment with production data, ran it, and it worked fine. When we moved it to production and ran it against the same data, it failed with an ora-1555. We've set up a large rollback segment, and...

    Mljsher0 pointsBadges:
  • Oracle connectivity

    Recently We installed Oracle 8i ( Server on a Machine running Windows 2000 Professional SP 4, but we're experiencing connectivity problems: 1 minute after the Listener started up it's not possible to connect to the database any more . At this point, if the listener service is restarted then...

    carlosdl69,510 pointsBadges:
  • Error when tried to update the SSOledbGrid connected to with Sybase Server Database

    I have a visual basic 6.0 application with connect to Sybase Server 11 with OBDC Driver ?Sybase System 11?. In VB application use ADO 2.8 for update a table with two fields (Integer, Varchar(10)), the SSOledbgrid return error ?16389? to update or add a register. Show error when I tried to update...

    Icaro20 pointsBadges:
  • Database Administration

    Hi i am working with Ministry of communication & IT (INDIA).My question is i hav install oracle 9i at my home.When i go to command prompt & tries to connect it with sysdba, it is not able to connect....its says following error...(tns:unable to find host or service name).i have connectin it with...

    Technomeinung0 pointsBadges:
  • Data Guard Implementation

    Does anyone have any experience and/or issues with implementing a logical standby database for disaster recovery? We have enough disk for 1 standby database and the users want to query it as well as have it for disaster recovery.

    PeppermintP0 pointsBadges:
  • Identifying all SQL generated by a specific session

    I am trying to isolate all SQL generated by a specific user in a specific session. Short of using auditing can I tie specific session parameters like sid, serial#, username to SQL still available in the shared SQL area?

    Jrmills0 pointsBadges:
  • Uninstalling Oracle 9i products from a Window Server

    Hello how is everyone today? When your removing all Oracle components and services from a Windows 2003 Server what method is used more. The manual method or using Universal Installer? Can you please provide me a link to white papers that take me through the process of using the Universal Installer...

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