Oracle Tag Directory

Browse Alphabetically:

Featured Oracle Questions

  • Getting a ORA-12514 error message: TNS:listener does not currently know of service requested in connect descriptor

    I have an application that's running locally (through Oracle 11g) for the past week and it's been working fine. However, I'm now getting this: ORA-12514 TNS:listener does not currently know of service requested in connect descriptor error. I've already tested the connection with TNSPing which...

    ITKE347,945 pointsBadges:
  • Getting ORA-011033 error message: Oracle initialization or shutdown in progress

    I've been trying to connect to an Oracle user through TOAD or Oracle Enterprise Manager but I keep getting this error: ORA-011033: ORACLE initialization or shutdown in progress What should I do here?

    ITKE347,945 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE347,945 pointsBadges:
  • Oracle: How to string to date with milliseconds

    I'm trying to convert the following string to date in Oracle: 2004-09-30 23:53:48,140000000 I've already using this: to_date('#', 'YYYY-MM-DD HH24:MI:SS,FF9') But I keep getting this error message: ORA-01821: date format not recognized. Would anybody have a suggestion on what I should do here?

    ITKE347,945 pointsBadges:
  • How can I resolve the ORA-30926 error in Oracle?

    In Oracle, I keep getting this error message every single time I run a query: ORA-30926: unable to get a stable set of rows in the source tables Here's the query as well: MERGE INTO table_1 a USING (SELECT a.ROWID row_id, 'Y' FROM table_1 a ,table_2 b ,table_3 c WHERE a.mbr = c.mbr AND b.head =...

    ITKE347,945 pointsBadges:
  • Receiving ORA-00918 error when running SQL query

    In Oracle, I keep getting this ORA-00918 error: Column ambiguously defined when I'm running this SQL query: SELECT * FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER JOIN people ON people.id = coaches.person_id INNER JOIN users ON coaches.person_id =...

    ITKE347,945 pointsBadges:
  • Getting ORA-01882 error when accessing Oracle database through a Java application

    I've been trying to access an Oracle database through a Java application but when I try to run the app, I keep getting this error: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Anyone have an idea on what I should do here?

    ITKE347,945 pointsBadges:
  • Receiving ORA-01033 error message on Oracle 11g

    I recently installed Oracle 11g on Windows 7 and everything has been working great. But now I keep getting this error message: ORA-01033: ORACLE initialization or shutdown in progress. I've tried to figure it out but I'm still getting the error. I tried connecting as "SQLplus sys/sys as sysdba" but...

    ITKE347,945 pointsBadges:
  • Error installing linux on Dell Poweredge 2950

    I'm trying to install Novell Linux OS on a  Dell Poweredge 2950 server. 64-bit with raid and sas drives but i am getting a "no hard disk found" error

    ITKE347,945 pointsBadges:
  • ORA-01722 invalid number where clause in update statement. I want to log this error in error log table

    Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number. UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid ='aaa' LOG ERRORS INTO SARVESH_ERR_LOGS_TB ('Error while...

    sarvesh02025 pointsBadges:
  • Oracle 9i Designer

    Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.

    Pegasusdba0 pointsBadges:
  • Numeric value error

    How to solve this Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

    avk86510 pointsBadges:
  • Parameter Manipulation – Turning ‘abc’ type string into a number

    I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ' - ' || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN...

    tmbdnelson70 pointsBadges:
  • Career in Java

    I have done Core Java and J2EE courses. But got job in other platform. Here I am working on report generation using OBIEE tool. I am thinking to change over to Java platform. Is my decision is good? If good, suggest me how to change, i mean how and what  shoul I study?

    Prcvjr220 pointsBadges:
  • How to prepare for OCA 10g

    Can anyone provide me the exam pattern/dumps for OCA(Oracle Certified Assocaite) 10g

    Srinus5 pointsBadges:
  • What next for an Oracle professional?

    I am now working at a pharmaceuticals company as an assistant officer , IT after completing Oracle Certified Associates(OCA) and Oracle Certified Professional (OCP). I also completed MSc in Chemistry.I want to build my carrier in IT (Global).So, I want to go for addmition in BSc in Computer Science...

    Akbarmscjnu20 pointsBadges:
  • OCA 10g certification dumps

    Hi [Br _extended="true" />i am preparing for the 10g OCA certification Exam , can anybody pls help me in finding the dumps and assignments for OCA fundamentals and Admin I exams. [Br _extended="true" />

    Sweety17195 pointsBadges:
  • Best practices of RAID configuration of StorEdge HDS 9960 and Oracle 10g R2

    Hello, What are the best practices of RAID configuration of HDS 9960 storage and Oracle. Currently we are using now Mirroring RIAD 1+0 with 4 disks (2+2). will the second option of Mirroring 4+4 give us better performance than 2+2 disks? Thanks in advance. P.S. the Oracle instance is OLTP.

    Donpatrona5 pointsBadges:
  • How can i connect database from sql explore

    Hi all, My OS is Windows 7, I install Oracle 10g Express Edition then i install Oracle 10g client. Installation is Sucessful then i config ODBC setting.ODBC is Connection Sucessful.But SQL Explorer is Not Connected.How can i solve this Problem?Kindly Help.

    Yes115 pointsBadges:
  • How to prepare for OCA

    I want to become a DBA .can you please advice me how should i proceed ?Should i start with giving certification exams?

    Poojamalik5 pointsBadges:

Browse Alphabetically:

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