Lost Passwords in Oracle
I have joined a company very recently who deploy their product on both Oracle and SQL Server platforms. Theyt seem to have no clue about their dba access passwords for Oracle. How do I get to these passwords? Is there a backdoor or utility which can help me get the passwords on these databases? This [...]

Answer Question   |  March 7, 2005  4:45 PM
Oracle, Security

oracle performance tunning
Anyone who can share an experince with session_cached_cursosrs: conditions to use, value & desired results – will get a virtual drink. TIA!

Answer Question   |  March 3, 2005  12:08 PM
Oracle

CLOB – Fetch out of sequence
I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE where SESSION_ID [...]

Answer Question   |  March 3, 2005  10:48 AM
Database Management Systems, Development, J2EE, Java, Lifecycle development, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, SQL, XML

PMP transitioning from tech oriented projects to business oriented projects
I am a PMP with 10+ years experience in implementation oriented projects (rollouts, user moves, infrastructure, NetOps, etc.) for internal clients. I want to transition to business oriented projects (SAP, PeopleSoft, SOX, SW development, etc.) for external clients. I am fully familiar with PMI methodologies but have no experience and little familiarity in any of [...]

Answer Question   |  March 11, 2005  10:08 AM
Business/IT alignment, Customer relationship management applications, Data analysis, Development, ERP, Financial services applications, Human resource applications, Lifecycle development, Microsoft Windows, Oracle, PeopleSoft, Projects, Salesforce.com, SalesLogix, SAP, Sarbanes-Oxley Act, Siebel, Software Quality Assurance

Data Architect career path
I currently work as a data analyst creating reports within an access environment, and in addition have Oracle SQL and Business objects reporting skills. However I am keen to change my career path towards becoming a data architect, and would like to know what training courses to take in order to achieve this. I would [...]

Answer Question   |  March 1, 2005  4:02 PM
Data analysis, Data warehousing applications, DataCenter, ERP, Microsoft Windows, Oracle

Unix ODBC Drivers
I am looking for an inexpensive way to do a pull of Sqlserver data into Oracle using Native Oracle Sql Statements to select the data from Sqlserver. This request would be easy to fulfill if there were an ODBC driver for Unix. I have found such drivers but they are expensive ($4000 per CPU on [...]

Answer Question   |  February 21, 2005  11:25 AM
Hardware, Oracle 9i, SQL Server

SAPDBA not working in ORACLE database
Dear BASIS Experts, SAPDBA is not working in one of my Server . When I run it gives the error The environment variable NLS_LANG =american_america.we8dec differs form DB value AMERICAN_AMERICA.WE8DEC. Adjust the environment according to DB value !. SAPDBA terminates because data corruption would be likely while working with wrong charcter set. I am not [...]

Answer Question   |  March 11, 2005  9:06 AM
Basis, Oracle, SAP

Database and Web Server Technology Choices for Small Database Application
Hello, We are developing a small web-based database application that will need to be accessed by all department staff and managers (maximum 100 clients). Internet access to the database from outside the Agency is not required. It is not desirable to install any client software other than MS-Windows 2000 on individual PCs. The department PCs [...]

Answer Question   |  February 20, 2005  9:50 AM
Database, DB2, Development, Oracle, Web development tools

Oracle Application Remote Administration
Hello Sir/Madam/Mrs/Ms, i’m not sure whether is this the right platform asking my type of questions, but just go ahead. I have an Oracle database server and application server at Premise A. Right now i’m in Premise B which is geographically apart from Premise A about 365km. I want to access Oracle and only Oracle [...]

Answer Question   |  February 18, 2005  4:37 AM
Administration, Architecture/Design, Implementation, Migration, Oracle, Oracle 9i, Oracle Application Server, Servers

looking for oracle database benchmark tool on AIX
I am looking for a benchmark program (freeware would be ideal) to benchmark the oracle database on AIX5L and Linux RHAS3. Thanks for your help!

Answer Question   |  March 27, 2012  12:55 PM
Oracle

error on instaling grid on XP
i have a oracle database 10g in windows XP, but when i try to install the grid control always give me this error: invalid version: to be used for management repository, the database must be version9.2.0.4.0, version 10.1.03.0, or a patch release for one of those versions.

Answer Question   |  February 11, 2005  11:27 AM
Oracle, Oracle 10g

Oracle 10g Standard on Win 2003 Server Standard – Shutdown database thereafter cannot Startup, require restart
Hi there On server side + SQL*Plus tool! connect sys/pwd @sid as sysdba shutdown immediate or abort startup mount ORA-12528: TNS:listener: all appropriate instances are blocking new connection Use lsnrctl status – blockage – stop service + restart same error message. Other steps –> listerner.ora –> dynamic to static Result, most backup strategies cannot be [...]

Answer Question   |  March 23, 2005  6:11 AM
Oracle

creating a user in oracle 8
Hello I am doing a project and i want to practice or test a different senerios in my project which is in d2k and oracle 8, here my problem is , problem 1) in my system oracle is installed and i want to create a new user but it is not allowing me to enter [...]

Answer Question   |  February 10, 2005  11:23 AM
Oracle

Windows 2000 server and multiple SQL Server instances
We have Windows Advanced Server with 8 GB RAM. After booting the system, how much memory will be available for user applications? I want to install three SQL server instance with each allocated 1.3 GB RAM on that one server. Will all instance have its on memory space of 1.3 GB?

Answer Question   |  November 14, 2010  6:55 PM
Microsoft Windows, Oracle

SQL generated by 4GLs vs. Oracle stored procedures
We are attempting to adopt programming standards which would mandate the use of stored procedures in our Oracle 8i and 9i databases for data access. Application developers prefer to take advantage of the SQL generation capabilities of IBM’s WenSphere and Compuware’s Uniface. DBAs feel the security, performance, maintainability, visibility and sharability of procedures stored in [...]

Answer Question   |  January 30, 2005  10:24 AM
COBOL, Information risk management, Oracle, SQL, VBA

relocation – IT manager in West Africa
Dear All, I have been selected for a position of IT Director of manufacturing company in a West Africa country (my home country). the organisation operation cocoa bussiness with farms; disstribution; factories in the country. The IT environment is multi site with AS/400 (my knowledge is fair since 1999) JD edwards (no knowledge but experience [...]

Answer Question   |  January 30, 2005  8:46 AM
Career development, Development, ERP, PeopleSoft, PeopleSoft Enterprise, PeopleSoft EnterpriseOne, PeopleSoftWorld

Technical: Query Plan Problem in Oracle DB 9i
I have a set of PL/SQL functions building a 7M row table. The last function adds around 0.5M rows by gathering data from two existing tables (0.3M rows each) and from rows already placed in the table being built. The rows are added by a cursor which constructs the new row and writes one at [...]

Answer Question   |  January 23, 2005  10:13 AM
Oracle, SQL

New way of handling RAID 5?
As an Oracle DBA, I have heard and read a lot about RAID 5 and what it can do to database write performance. Now I understand RAID 5 has been improved to the point that all of the things that caused the overhead are now being handled in disk cache, and write times are now [...]

Answer Question   |  August 28, 2008  4:37 PM
Oracle DBA, RAID, RAID 5

Developing a Java application(a batch)that transfers data from SAP to Oracle DB and vise versa. HELP ME PLEASE!
Hello, I’m a student and a newbie. I wanna learn Java in relation to SAP-BAPIs. My Test db is Oralce and I wanna develope a small application(call it a batch) that stores SAP Jobs(e.g meta data) in to my test Oracle db. The application should also be able to do bidirectional transaction(from SAP to the [...]

Answer Question   |  January 13, 2005  10:59 AM
Development, Lifecycle development, Oracle

Wireless University
I work at a large, urban university. We are looking to upgrade our whole IT infrastructure. We hired a consultant group and they feel it will take a quarter of a billion dollars to accomplish it. I want to find cheap, faster, better ways to upgrade. Also, I want to serve students, faculty and admin., [...]

Answer Question   |  December 30, 2004  5:00 PM
802.11 networking equipment, Data analysis, ERP, Human resource applications, Networking, Training, Wireless standards