• Oracle Application Freezing up

    Oracle alert log has below error occurring frequently. How to troubleshoot message? Fatal NI connect error 12170. VERSION INFORMATION: TNS for 32-bit Windows: Version 11.1.0.6.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production Windows NT TCP/IP NT...

    Cathyhaskins384115 pointsBadges:
  • Getting the number of days between two dates in Oracle 11g

    I've been trying to find the number of days between two different dates in Oracle 11g. Here's what I have so far: select sysdate - to_date('2009-10-01', 'yyyy-mm-dd') from dual But it keeps returning an interval and I can't cast it to an integer too. Any idea what I should do here?

    ITKE350,945 pointsBadges:
  • Where to download Oracle 11g Express Edition for Windows 64-bit

    When I registered on Oracle's website to download Oracle 11g Express edition database, it only gave me links to only download Windows 32-bit and Linux 64-bit. Is there somewhere where I can download a 64-bit Windows version? Or is it just that 64-bit versions are available for paid Oracle DBs?

    ITKE350,945 pointsBadges:
  • How to create a database in Oracle 11g Expressed Edition?

    I recently installed Oracle 11g Expressed Edition onto my Windows 7 PC, along with SQL Developer. I'm trying to create a database with two tables and then use the Developer to insert and query the data. But when I go into Developer, it asks me to create a new connection, meaning that it thinks the...

    ITKE350,945 pointsBadges:
  • 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...

    ITKE350,945 pointsBadges:
  • How can I create a user in Oracle 11g?

    I need some help! I'm trying to create a user in Oracle 11g and only grant them the ability to execute one stored procedure, along with the tables in the procedure. Is that possible? If so, what's the process to do it?

    ITKE350,945 pointsBadges:
  • How can I get the last row of a table in an Oracle database?

    I have an Oracle 11g Express database and I'm having trouble getting the last row in one of my tables. Can anybody help me with this? Thanks so much.

    ITKE350,945 pointsBadges:
  • How to turn off password expiration permanently in Oracle 11g

    I've been using Oracle for my development testing. But now the password for my bootstrap account that I always use to rebuild my database has expired. Is there a way to turn off the password expiration for users permanently? I'm currently using Oracle 11g. Thanks so much.

    ITKE350,945 pointsBadges:
  • DBMS_CRYPTO package to encrypt & decrypt in Oracle 11g

    ORA-06521: PL/SQL: Error mapping function > >ORA-06512: at "SYSTEM.DBMS_CRYPTO_FFI", line 3 > >ORA-06512: at "SYSTEM.DBMS_CRYPTO", line 13 > >ORA-06512: at "SYSTEM.ENC_DEC", line 21

    Mohanasundharam5 pointsBadges:
  • Benefits of Oracle database 10g vs. 11g editions?

    What are the benefits of Oracle 11 g edition over Oracle 10 g express edition?

    MUKUNDSAWANT55 pointsBadges:
  • How can I install Oracle 11g client?

    I've been trying to install Oracle 11g (client) but I keep getting this error: Environment variable: "PATH" - This test checks whether the length of the environment variable "PATH" does not exceed the recommended length. Expected Value: 1023 Actual Value : 1028 List of errors: - PRVF-3929 : Adding...

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

    ITKE350,945 pointsBadges:
  • Can I use an Oracle 11g client on a Oracle 10g server?

    For the past few months, I've recently created a .NET program that uses ODP.NET, specifically with Oracle 11g. But our Oracle server has been running 10g and I can't make a change. Can I run an Oracle 11g client on a 10g server? Or am I in big trouble?

    ITKE350,945 pointsBadges:
  • What’s the difference between Oracle 9i, 10g, 11g?

    And also what's the difference between oracle9i/10g/11g. Or if not wrong they are different versions only.

    Pooni20 pointsBadges:
  • Cannot create Oracle 11g database

    SQL> @createdb.sql create database sam * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-01501: CREATE DATABASE failed ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 5 ORA-00604: error occurred at recursive SQL level 1 ORA-30012:...

    sumeetmalani29180 pointsBadges:
  • Event ID 34 Application Event log message

    Application freezing up for users. Informational message in application event log: The description for Event ID ( 34 ) in Source ( Oracle.xxxx ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You...

    Cathyhaskins384115 pointsBadges:
  • How to uninstall Oracle 11g

    I am a beginner with oracle I just installed it, but after 1 day it's SQL plus window starts showing an error "an initialization or shutdown in progress" I already ran some commands like "database pluggable all open" and "instant startup or shutdown", shown on your site yet not working, so I wanted...

    sameeksha5 pointsBadges:
  • Error using SAP Crystal Reports

    When I deploy my ASP.NET website on Windows 7 with Oracle 11g database in back end. I am using SAP Crystal Report version 13.0.2000.0 It gives error as: Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.Description: An unhandled exception occurred...

    Ashutoshpatilak10 pointsBadges:
  • How to connect Visual Basic 6 to Oracle 11g

    What are the steps to connect VB 6.0 to Oracle11g? Thanks!

    Rupeshit5 pointsBadges:
  • Execution of Oracle 11g wrapped procedure gives ora-00900 error

    Hi, I have a procedure which I wrapped using the oracle 11g wrap utility. If I execute the wrapped procedure using JDBC I am getting an error of 0RA-00900 invalid SQL statement. The procedure is having basic SQL statements only. The same procedure if i wrap using Oracle 9i and execute using JDBC it...

    askmsc15 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