• Upgrade from Oracle 10g2 to Oracle 10g4 on Linux

    I'm a newbie to Oracle database administration and I've been recently tasked to upgrade our databases in our development environment from 10g2 to 10g4. The databases are housed on SUN servers (there are several database servers), running with RedHat Linux 4.5 operating system. Additionally, the...

    Daboogie5 pointsBadges:
  • Get the following error when logging into SQLPlus – ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist

    When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 10g Personal Edition Also getting the following error when trying to connect to an oracle database via VS2008 ORA-12514: TNS:listener does...

    Oracle20005 pointsBadges:
  • Developing standalone Apps with Oracle Developer 10g

    hai, i am new to oracle 10g development. can i build an application using oracle forms developer 10g and run it without deploying in the application server.(i.e without using oracle 10g Application Server) thanks np

    Nareshpriya5 pointsBadges:
  • OracleClient

    I am new to VB.Net, I am using VB.Net 2003 and Oracle 10g Express. In coding I enter Imports System.Data.OracleClient The system did not support. Why??

    Dax70 pointsBadges:
  • ProC under Oracle 10g

    Hi! I have a piece of code in Pro-C that's been running under Oracle 9i for several years. I recently compiled it using the ProC of Oracle 10g and the code complied without any problems. However, when I run it on an Oralce 10g database, queries that returned thousands of records in 9i return empty...

    Ilank10 pointsBadges:
  • Searching using Oracle Forms

    Hi to all.I am tauqeer.I am using oracle 10g forms developer I want to search some data in the tabular form style in the form based on a query on a text item.I want when i press enter button which is under that text item the data will be displayed in the tabular saction.the text item and enter...

    Raza15 pointsBadges:
  • Oracle Data Dictionary

    I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this...

    OracleATE190 pointsBadges:
  • CPU UTILIZATION IS SHOWING 0 IN SAR REPORT

    Hi all I am facing problem on oracle 10g We have oracle 10g on solaries 5.9 We have database in RAC envinment with 2 nodes We have 10g AS as a front end application. My problem is when user fired user name and passwd the application page are coming very slow it is taking very much time mean while...

    Oracle dba115 pointsBadges:
  • Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)

    CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); PROCEDURE tab1_statement_change; END trigger_api; / CREATE OR REPLACE PACKAGE BODY trigger_api AS TYPE t_change_rec is record (...

    APB10 pointsBadges:
  • oracle sync index job log file

    Hi, I am using windows 2003 server with oracle database 10g enterprise edition. I created a procedure and scheduled job to do sync text indexes. I am using parallel 2 for my sync index job. the proble is: After i enable the log file option, ctx_output.start_log('SYNC_INDEXES_JOB.TXT');...

    Iconect10 pointsBadges:
  • oracle 10G Enterprise Manager

    I have a oracle 10g database running on unix 64 bit. For some reason the enterprise manager GUI console suddenly stopped working. Trying to finout the reason behind it and bring it back up. I have looked at the log files (emoms). the agent is up and running. Can someone let me know how to...

    Oradba310 pointsBadges:
  • Oracle 10g Reports not running

    Hi Gurus, We are trying to migrate from form and reports 4.5 to 10g and while migrating them we were able to find the way to work with forms 10g but not with reports 10g from within forms. can any one give me the procedure to make reports 10g to work within forms . with example please.

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

    Mbv30 pointsBadges:
  • Clustering

    I am using Oracle 10g on Windows I would like create clustes for faster reterival. How can I create it(syntax) can you help me with an example. How does it effect the performance

    Vishwanathavn5 pointsBadges:
  • Oracle 10g

    What's the best of breadth backup/recovery policy using RMAN 10g?

    Want2KnowOracle10 pointsBadges:
  • VC++: int keyword gives different results in Oracle 9i and 10g

    In my code i am using a structure with integer variable and this variable is used to accept values from generic VC++ 6.0 functions, the value which got filled to the variable is from a table field whose datatype is NUMBER(10), in oracle 10g it runs fine but in oracle 9i it always returns 0, any...

    SANS35 pointsBadges:
  • oraoledb non working WHERE clause character comparison

    Are there WHERE clause character comparisons that do not work when using oraoledb? I have a SQL query that is well formed and works with both Oracle 9 and Oracle 10g client, but will not execute when parsed via oraoledb.

    Jsl255 pointsBadges:
  • VB6 Oracle 10 Stored procedures with parameters

    I have a vb6 - RDO code that works ok with Oracle8, recently there was an upgrade to Oracle 10g enterprise. Now I get the error 40041 -> Object Collection: Couldn't find item indicated by text. 1110 lstrSQL = "{call Pyramid.Load_Tables(?, ?, 0)}" 1120 Set lrdoQ =...

    Hermes6835 pointsBadges:
  • can we install oracle10g client version and oracle 10g server on the same machine? will it work fine?

    can we install oracle10g client version and oracle 10g server on the same machine? will it work fine? If there will any problem so what will the problem? Please any one explain me. Thanks in advance. It's urgent please

    Rajesh00825 pointsBadges:
  • Oracle 10g Instance not starting Up

    Oracle 10g startup command from SQL Plus gives the following error: ORA-01034 : ORacle not available ORA-27101: shared memory realm does not exist

    Raj66615 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