oracle internet directory application developer’s guide — dbms_ldap_utl sample code doesn’t work
Hi, all I’m trying to set up Oracle Internet Directory Rel 9. I’m trying to use APIs provided in Application Developer’s Guide. I started by copying and trying to run the examples given in the guide. My procedure connects to LDAP, authenticates me, but won’t create a user. (Actually, it passes the create_user_heandle procedure, but [...]

Answer Question   |  November 10, 2010  1:31 PM
Application security, Biometrics, Database, Development, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Oracle, provisioning, Secure Coding, Security, Security tokens, Single sign-on, SQL

ora-1555 during data purge
We have a PL/SQL script that selects then purges data from a table row-by-row. We populated our Test environment with production data, ran it, and it worked fine. When we moved it to production and ran it against the same data, it failed with an ora-1555. We’ve set up a large rollback segment, and used [...]

Answer Question   |  July 21, 2004  10:51 AM
Oracle 8i

Database Replication
Hello, i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?

Answer Question   |  July 21, 2004  3:01 AM
Architecture/Design, Development, Installation/Upgrade, Oracle, Oracle 8i, Oracle 9i, SQL

Oracle 8.1.7.4 connectivity
Recently We installed Oracle 8i (8.1.7.4) Server on a Machine running Windows 2000 Professional SP 4, but we’re experiencing connectivity problems: 1 minute after the Listener started up it’s not possible to connect to the database any more . At this point, if the listener service is restarted then we can connect to the database [...]

Answer Question   |  July 19, 2004  3:39 PM
Administration, Installation/Upgrade, Oracle, Performance/Tuning

Error when tried to update the SSOledbGrid connected to with Sybase Server Database
I have a visual basic 6.0 application with connect to Sybase Server 11 with OBDC Driver ?Sybase System 11?. In VB application use ADO 2.8 for update a table with two fields (Integer, Varchar(10)), the SSOledbgrid return error ?16389? to update or add a register. Show error when I tried to update the varchar field. [...]

Answer Question   |  July 16, 2004  3:25 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic

Database Administration
Hi i am working with Ministry of communication & IT (INDIA).My question is i hav install oracle 9i at my home.When i go to command prompt & tries to connect it with sysdba, it is not able to connect….its says following error…(tns:unable to find host or service name).i have connectin it with following syntax: (connect [...]

Answer Question   |  July 16, 2004  1:03 AM
Oracle

Data Guard Implementation
Does anyone have any experience and/or issues with implementing a logical standby database for disaster recovery? We have enough disk for 1 standby database and the users want to query it as well as have it for disaster recovery.

Answer Question   |  July 15, 2004  10:38 AM
Oracle, Oracle 9i

RAID configuration for Oracle database
Presently we have a 9iOracle database sized at approximately 50MEG on an HP-UX 11.11 server on a SAN. Our software app vendor is telling us that we should have the database on RAID 10 for better performance. They have done benchmarking with DB sized at what ours will be in the future. (Multi terabyte). Their [...]

Answer Question   |  August 28, 2008  10:34 AM
DB2, Oracle 9i, Oracle database design, RAID configuration

Oracle 9.2.0.4 and gcc compiler
We just upgraded to Oracle 9.2.0.4. When we try to compile a program, we get the following error: ld: fatal: file /u100/app/oracle/product/9.2.0/lib//libclntsh.so: wrong ELF class: ELFCLASS64 error when trying to compile with GCC version 2.95.3. I was wondering if anyone had run across this, and, if so, is it telling us to upgrade gcc, or [...]

Answer Question   |  September 24, 2004  1:16 PM
C, Oracle, Oracle 9i

Uninstalling Oracle 9i products from a Window Server
Hello how is everyone today? When your removing all Oracle components and services from a Windows 2003 Server what method is used more. The manual method or using Universal Installer? Can you please provide me a link to white papers that take me through the process of using the Universal Installer to uninstalling all the [...]

Answer Question   |  June 15, 2004  12:03 PM
Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Standard Edition

Connecting to External DB from SAP BW
Dear All, We have installed SAP BW 3.1C on SQL Server Database. We need to connect to an external Oracle Database. Has anyone tried this scenario ? We are trying this thru DB Connect. We are able to connect to external DB. But after selecting the tables we got stuck. It is saying “selection of [...]

Answer Question   |  December 14, 2011  4:31 AM
Oracle, SAP

Passing array as output parameter through procdure/function
Any suggestions on implementing a procedure that passes an array as output parameter and using this as an input to a second procedure and manipulating it?

Answer Question   |  June 7, 2004  11:41 AM
Oracle 9i

Identifying all SQL generated by a specific session
I am trying to isolate all SQL generated by a specific user in a specific session. Short of using auditing can I tie specific session parameters like sid, serial#, username to SQL still available in the shared SQL area?

Answer Question   |  July 8, 2004  4:15 PM
Oracle

Support of Oracle 8 and 9i
We currently support several systems running Oracle 8 that are upgrading to 9i. From a support perspective, can someone help me identify any key differences that might need special attention the my Oracle 8 experience does not cover? Thank you.

Answer Question   |  June 3, 2004  2:48 PM
Oracle, Oracle 8i, Oracle 9i

RAC and parallel server
What is difference between RAC and parallel server?

Answer Question   |  May 28, 2004  4:56 PM
Oracle 10g, Oracle 8i, Oracle 9i

Peoplesoft DBA
I may have an opportunity for a Peoplesoft DBA job. I’ve done a wide gamut of Oracle DBA work at a major university for the last 10 years and am looking for a challenge. I don’t know what skills this kind of position would require or allow one to develop. This is my main concern. [...]

Answer Question   |  May 28, 2004  11:35 AM
Oracle

Tools for Oracle database admin, and also Design and Development
I was out of the Oracle world for three years (using 7.4?), and now knee deep in alligators with little time to review market offerings. I am using Oracle Enterprise Manager for 9i and very happy with it. An Embarcardero vendor has contacted me a couple of times, but I’ve had little time to investigate [...]

Answer Question   |  June 3, 2004  2:23 PM
Oracle 9i

ORA-01436 error
We are trying to use connect by ..prior feature of oracle. Having said that we had used this type of queries and now we are facing this loop error for connect by prior. Any suggestions.

Answer Question   |  June 1, 2004  3:59 PM
Oracle 9i

Adding column to an exiting primary key
We have a table which already has a primary key. We want to make this have a composite primary key with another column. Is there any other way to do this without dropping the primary key and recreating a composite PK. Thanks in advance.

Answer Question   |  May 26, 2004  3:55 PM
Oracle 9i

remotely managing database securly
If I want to work at one place and be able to manage the Oracle 8i database remotely and securly at another place, what should I do or set up? Thanks

Answer Question   |  May 26, 2004  4:48 PM
Database, DB2, Oracle, Oracle 8i