Oracle 10g

10G Database Restore to New Server from Backup

I am a Sr. SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a brand new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g database. I am having allot of...

PL/SQL performance tuning...

I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied...

Difference between length and vsize functions

Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik

Configuring isql *plus

Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik

DATABASE RECOVERY , WINDOWS 2000 , ORACLE 10G

Hi Brian, I am a student at West Virgibia University, and manage a database with tables. My problem is that my system has crashed, I can get it up and running but on a different partition, so that my files are intact on the original partition, but my database wont run, because it was installed on...

what is the best STORAGE solution for ORACLE db - SAN or NAS ?

one of my project is very critical for the client . the application will run in 10 different sites . the infrastructure of each site will be : 4 linux servers (2 for ORACLE DB , 2 for websphere) + 1 linux/win server for backup software + DB oracle (~100GB) + storage. i have a very good experience...

Erros starting SQLPLUS after a no problems installation (oracle)

I'm running Fedora Core 3 In my terminal I $ sqlplus and I'm prompted for my username and password. No matter what I type in, I get these error messages ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist It makes me think I've got my uname and password wrong but I...

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

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.

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

RAC and parallel server

What is difference between RAC and parallel server?

Novell EDirectory synching with Oracle Internet Directory 10G using Novell IDM2 (previously DirXML)

Any of you guys have any experience on this? Any tips or probably a step-by-step guideline to follow going about this?

Oracle 10g ASM

Can you create ASM instance without creating a database? If yes, how?

upgrade to 10g

Looking for some input about upgrading/migrating to 10g from 8i databases. I have successfully migrated to 9i from 8i and even 7 version databases, but have not had the opportunity to work with 10g. Thank you, tuple9i