Oracle Error Messages

Oracle Financials

When logging in and getting the account locked after three attempts, it does not give me a message. Please does anyone know how I can set the message to prompt that the accoun is locked after three attempts

Validation error in Oracle10g

If I try creating additional listener. It will opt for my OS credential(system username and password) and each time I enter it, it will give me this error"Validation error" and followed by another error message "oracle executable manager stopped working and was closed". please what will I do? How...

Oracle 9i: jrew.exe

while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows vista)

ora-01033 oracle initialization or shutdown in progress

ora-01033 oracle initialization or shutdown in progress what is solution

Invalid objects after upgrade from 8.1.7.4 to 10G

for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; ...

Oracle Forms 6i trying to read a list of numbers separated by a comma

Hello, I have an Oracle Forms 6i form with a text field that I want users to be able to put in a list of numbers seperated by commas, eg 12345,67890,34567 etc. From this list, I want to be able to use the list of numbers in an IN statement such as: CURSOR c_policy IS SELECT...

Solution for ORA-6413 error showing connection not open

vb.net,oracle 10g

Oracle + iSQL*Plus - PLS-00103: Encountered the symbol "GRANT"

Hi, i am trying to create some new csdba users and assign some roles to them however i keep getting the following error message - 7/22 PLS-00103: Encountered the symbol "GRANT" when expecting one of the following: * & | - + / at mod remainder rem => .. <an expo nent (**)> || multiset ...

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

What am I doing wrong. Please Help

An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As...

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??

PL/SQL error

Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

ORA-03113: end-of-file on communication channel

I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am...

PL/SQL Insert

Hi Experts, I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction and my first insert is successful while doing the insert on second table which is completely carry same set of attibutes and values of 1st table + 1 additional static value attribute,it gives ORA :01400...

Oracle migration error - help me to solve ORA-06544

I migrating data from one database server connection to other server connection using database link from 10g to 11g. I am not able to understand the cause of this error and how to solve it... On compiling the code I am getting the error Error(1): ORA-04052: error occurred when looking up remote...

I am getting ORA-01422: Exact fetch returns more than requested number of rows

Hi Experts, I am gettting this error when i run my test case for my PL/SQL procedure ,which hav select and Insert statement only ,not clear where i wud hav went wrong,please guide me where should i check exactly its poping this error message which i catched in exception piece after Insert statement

PLS-00103: Encountered the symbol "E_PROD_REQ_ID_NOT_FOUND" when expecting one of the following:

how can i resolve that error? when i compile the store proc....it compiled without any errors....but in a package its throwing error

Oracle9i Release 1.0.2.2.2a Application Server Install - Enterprise Edition

I am installing the Forms and Reports Server component only first. But it hangs when it get to 100% and it is saying "Installing Oracle9i Application Server 1.0.2.2.2a" It hangs after prompting a blank command line and it seems it is trying to run something. Here is the last line on the...

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

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