Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Exclamation Unanswered: Guidance and resources for posters

    Before you post:
    * Try using the Search button to see if a similar question has already been answered
    * Try reading the relevant parts of the Oracle documentation (see links below)
    * Try performing a Google search

    When you post:
    * Give your post a meaningful title, so that people have some idea what it will be about. Titles like "Please help!" and "Newbie query" aren't very useful.
    * Posts should contain OS name & version
    * Posts should contain Oracle software version number to 4 decimal places
    * Posts should contain cut & paste copies of actual inputs & output messages
    * Use vb Code tags to make your post more readable. The most important of these is the code tag, which makes both code and examples clearer by using a proportional font and maintaining spacing - e.g. instead of this:

    SQL> select *
    2 from emp
    3 where deptno = 10;

    EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
    ---------- ---------- --------- ---------- ----------- ---------- ---------- ----------
    7782 CLARK MANAGER 7839 09-JUN-1981 2450 10
    7934 MILLER CLERK 7782 23-JAN-1982 1300 10

    ...you get this:
    Code:
    SQL> select *
      2    from emp
      3   where deptno = 10;
    
         EMPNO ENAME      JOB              MGR HIREDATE           SAL       COMM     DEPTNO
    ---------- ---------- --------- ---------- ----------- ---------- ---------- ----------
          7782 CLARK      MANAGER         7839 09-JUN-1981       2450                    10
          7934 MILLER     CLERK           7782 23-JAN-1982       1300                    10
    Useful links:

    Oracle Online Documentation:
    Oracle 8.1.7
    Oracle 9.2
    Oracle 10.1
    Oracle 11.2

    Other Resources (thanks to Saravanan.R for many of these):
    http://www.orafaq.com/
    http://www.oracle-base.com/Index.php
    http://www.ixora.com.au/q+a/index.html
    http://www.llcsystems.com/FAQ.htm
    http://www.arikaplan.com/oracle.html
    http://www.csee.umbc.edu/help/
    http://www.ss64.com/index.html
    http://news.dcn-asu****/BOOKS/
    An Introduction to Oracle SQL Statement Tuning (Bill Magee)
    Introduction to Data Modelling (University of Texas)

    Other forums:
    Ask Tom
    Quest PL/SQL Pipeline
    comp.databases.oracle

    Please feel free to suggest other tips and links; I will update this post from time to time.
    Last edited by andrewst; 12-09-09 at 13:43. Reason: Link added

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    This link from Tom Kyte explains quite nicely what makes a good question:

    The Tom Kyte Blog: How to ask questions

  3. #3
    Join Date
    Oct 2010
    Posts
    35

    Exclamation Ora-00604

    Hie guys i am on Windows enterprise server 8 running two Virtual Machines, One is hosting Application R12.1. the other one is hosting Oracle database 11g.

    I am getting the error below when run command perl adcfgclone.pl appTier. Any ideas on how to solve the error

    Enter username/password: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found


    Database connection to jdbcracle:thin:@qadbase.safxodi-jv.local:1523BWMST failed ADD call failed with exit code 1

    Updating Server Security Authentication

    Enter username/password: ignoring @DBWMST specification, using DBC file
    java.sql.SQLException: Invalid number format for port number Database connection to jdbcracle:thin:@host_nameort_number:database failed Updating Server Security Authentication failed with exit code 1 adgendbc.cmd exiting with status 1

    ERRORCODE = 1 ERRORCODE_END
    .end std out.

  4. #4
    Join Date
    Oct 2013
    Posts
    1

    query regarding ERROR message

    hi..

    i am working on oracle 10g on ERP.
    trouled with 1 error-- frm 40735 when-new-form-instance trigger raised unhandled exception ORA-01652

    but issue is that .. on my pc erp module there is no issue (no error).. but get error in other pc n connected in lan..
    plz reply..
    abhijit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •