Oracle Error Reference
Contents |
Verb errors are positive integers. A Verb returns either 0 (successful execution) or an error number. The following sections provide reference tables for these types of errors: EM CLI oracle error codes list infrastructure OMS connection File-fed option Built-in verb 6.1 EM CLI Infrastructure Errors Any execution
Oracle Error Codes List With Description
of the EM CLI client could result in the following errors. Table 6-1 Infrastructure Errors Error Code Description 242 A Verb
Oracle Error Sqlcode
has encountered a problem with a dependency specific to the implementation of the Verb (INSIDE of its abstraction barrier) unrelated to the Verb's semantics. 248 Configuration files are corrupt or inaccessible. 253 The command
Oracle Sqlcode List
name is not recognized. 254 Internal system error. 6.2 OMS Connection Errors Verbs that execute at the OMS return these error codes as indicated in the listing for each applicable verb. Table 6-2 OMS Connection Errors Error Code Description 243 License has not been accepted by the current user. 249 Cannot connect to the OMS. 250 Wrong credentials for log in to the OMS. 6.3 File-fed Option Errors Verbs that oracle sqlcode values allow for file-fed options (rather than options where the values are explicitly defined on the command line) can return the following error codes. Table 6-3 File-Fed Option Errors Error Code Description 244 Cannot find an option value file. 245 Cannot read in an option value file. 246 An option value file is too big. 6.4 Built-in Verb Errors The following error codes are returned by each verb (not including EM CLI infrastructure errors that apply to all verbs). Table 6-4 Built-In Verb Errors Verb Error Code add_beacon 0—Beacon added successfully. 129— Syntax Error. The displayed message indicates which argument is syntactically incorrect. 170—Service does not exist. 173—Beacon does not exist. 201—Beacon is already in the monitoring beacons list. 230—Insufficient privileges. 255—Back-end error. Verb failed. add_group_to_mpa 2—I/O error occurred while writing to the MPA file. 3—The specified MP already exists in the MPA. 4—The group name is empty or not specified. 223—The supplied options are syntactically incorrect. add_mp_to_mpa 1—File does not exist, is unreadable, or an I/O error occurred. 2—I/O error occurred while writing to the MPA file. 3—The specified MP already exists in the MPA. 4—The target-type definition file cannot be parsed. 5—The MPA filename is not between 1 and 255 characters. 6 —A file of
Code Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle oracle error codes and solution User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code oracle error codes table Search News and Events Sponsors Page Submit Code Contact Us We have over 18,000 Oracle oracle sqlcode 942 Error Codes currently indexed for searching, including error codes for SQL*Loader, RMAN, NNL, TNS, DRG, IMG, PCC, LPX, LSX, and many others. Type the Oracle Error code into the Search box to find https://docs.oracle.com/cd/E63000_01/EMCLI/cli_error_ref.htm the associated error: Or, browse the Oracle Error list below: ORA-00000: Normal, successful completion ORA-00001: Unique constraint (string.string) violated ORA-00017: Session requested to set trace event ORA-00018: Maximum number of sessions exceeded ORA-00019: Maximum number of session licenses exceeded ORA-00020: Maximum number of processes (string) exceeded ORA-00021: Session attached to some other process; cannot ... ORA-00022: Invalid session ID; access denied ORA-00023: Session references http://psoug.org/oraerror.htm process private memory; cann... ORA-00024: Logins from more than one process not allowed i... ORA-00025: Failed to allocate string ORA-00026: Missing or invalid session ID ORA-00027: Cannot kill current session ORA-00028: Your session has been killed ORA-00029: Session is not a user session ORA-00030: User session ID does not exist. ORA-00031: Session marked for kill ORA-00032: Invalid session migration password ORA-00033: Current session has empty migration password ORA-00034: Cannot string in current PL/SQL session ORA-00036: Maximum number of recursive SQL levels (string)... ORA-00037: Cannot switch to a session belonging to a diffe... ORA-00038: Cannot create session: server group belongs to ... ORA-00040: Active time limit exceeded - call aborted ORA-00041: Active time limit exceeded - session terminated ORA-00042: Unknown Service name string ORA-00050: Operating system error occurred while obtaining... ORA-00051: Timeout occurred while waiting for a resource ORA-00052: Maximum number of enqueue resources (string) ex... ORA-00053: Maximum number of enqueues exceeded ORA-00054: Resource busy and acquire with NOWAIT specified ORA-00055: Maximum number of DML locks exceeded ORA-00056: DDL lock on object "string.string" is already h... ORA-00057: Maximum number of temporary table locks exceeded ORA-00058: DB_BLOCK_SIZE must be string to mount this data... ORA-00059: Maximum number of DB_FILES exceeded ORA-0
here for a quick overview of the site Help Center Detailed answers to any questions you http://stackoverflow.com/questions/28590155/receiving-ora-06531-reference-to-uninitialized-collection-error might have Meta Discuss the workings and policies of this site http://stackoverflow.com/questions/13529546/oracle-error-ora-04093-unable-reference-long-data-type About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of oracle error 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Receiving ORA-06531 Reference to uninitialized collection error up vote 0 down vote favorite I am running a function that imports a file and I am receiving the following Oracle error: ORA-06531: Reference to uninitialized collection ORA-06512: at oracle error codes "BANINST1.SZKPERT", line 186 I have read on other answers that I need to initialize a collection to avoid this error. However, I am unsure what collection I need to initialize and what syntax should I use. Below is the function: function f_get_pert_examinees (p_filename varchar2) return baninst1.scf_pert_test_examinee_nt pipelined is lv_filename CONSTANT varchar2(50) := p_filename; lv_examinee_tab lt_download_tab_type; lv_remote_data clob; lv_char varchar2(1); lv_eol boolean := false; lv_tablen binary_integer; lv_list szkftpx.t_string_table; type lt_field_tab_type is table of varchar2(50) index by binary_integer; lv_field_tab lt_field_tab_type; type lt_remote_data_tab_type is table of clob index by binary_integer; lv_remote_data_tab lt_remote_data_tab_type; begin begin -- Connect to FTP site and get data from file. lv_connection := szkftpx.login(lv_site, lv_port, lv_user, lv_pass); szkftpx.ascii(p_conn => lv_connection); -- Get a list of files. szkftpx.nlst(p_conn => lv_connection, p_dir => './' || substr(lv_filename,1,20) || '*', p_list => lv_list); -- Loop through the files. for file_index in 1..lv_list.count loop begin lv_remote_data_tab (file_index) := szkftpx.get_remote_ascii_data ( p_conn => lv_connection, p_file => lv_list(file_index)); exception when others then null; end; end loop; szkftpx.logout(lv_connection); exce
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle Error ORA-04093, unable reference long data type up vote 2 down vote favorite I am trying to create a trigger on addcomments table, which contains a long coloumn CREATE OR REPLACE TRIGGER careventCommentssysc AFTER INSERT ON addcomments FOR EACH ROW DECLARE BEGIN cargetcomments(:NEW.addcode, :NEW.addcomment, 'INSERTING'); END careventCommentssysc; when i try to compile this i am getting following error. ORA-04093, references to column of type LONG are not allowed in triggers. But i cant change the table column type to other than long. Please help me if anyone handled this problem earlier. oracle plsql oracle11gr2 share|improve this question asked Nov 23 '12 at 12:50 Maddy 1,65942544 :We cannot refer long data type in Oracle Trigger,so You can change the data type of the column to CLOB –Gaurav Soni Nov 23 '12 at 12:56 2 I found a work around ,but its better to convert the column to CLOB rather than implementing this .Pls find the link https://forums.oracle.com/forums/thread.jspa?messageID=3260953 –Gaurav Soni Nov 23 '12 at 13:12 @GauravSoni, I have tried this. But i am getting exception ora-02109 (Connection description for remote database not found) –Maddy Nov 23 '12 at 14:05 1 : Fill the Host,Port ,SID CREATE DATABASE LINK LOOPBACK USING '(DESCRIPTION =(ADDRESS =(COMMUNITY = world)(PROTOCOL = TCP)(Host = 10.176.13.21)(Port = 1547))(CONNECT_DATA = (SID = isld)(SERVER = DEDICATED)))' –Gaurav S