Oracle bash: dbca: command not found redhat V5 64 bits

I have installed Oracle 11g 11.1.0.6.0 on a hp dc7800p, Core 2 duo E8400@3.00GHz, 1,95 GB RAM, apparently the installation was successful.Inventory contents of (saica02.minpal.gob.ve/127.0.0.1):Oracle Database 11g 11.1.0.6.0Oracle Enterprise Edition Options 11g 11.1.0.6.0Oracle Net Services 11g 11.1 ...

Oracle filesystemio_options in HP-UX

I have a question regarding DirectIO on HP/UX and Oracle 10.2.Apparently my disks are mounted with following options: mincache=direct,convosync=directBut datebase init parameter filesystemio_options is set to async (which seems to be the default setting).Now my question is... Do I need to set the da ...

Oracle HP & VCS / FILESYSTEMIO_OPTIONS ??

I just upgraded from Oracle 9.2.0.6 to Oracle 10.2.0.2.We are using HP-UX and the disks are on Veritas Clusters.The disks are mounted with the options:mincache=directconvosync=directOn 9.2.0.6 the parameters disk_asynch_io & FILESYSTEMIO_OPTIONS were not explicitly set, so they were set to defau ...

Oracle filesystemio_options, RAID settings

I am confused about filesystemio_options parameters and RAID settings. I am using Oracle 11.2 64bit on RHEL 5.4. The hardware is IBM x3500 M2 with RAID 10 (controller equipped with battery with) consisting of 4 disks. The model of controller is IBM ServerRaid-MR10iThe Virtual Drive (of RAID controll ...

Oracle Changing filesystemio_options value to setall from asynch, makes db hung

Folks,We are running Oracle 10gr2 on Solaris 10 operating system with ZFS file system.Changing the filesystemio_options parameter value from asynch to setall, makes the database hung at the time of starting the database after changing the parameter value.The alert log shows the following message :Th ...

Oracle Database won´t startup after I altered the filesystemio_options

OS: RHEL3Oracle ver: 10.2.0.2This is test box, but still urgent!. I tried to play with the IO, according to one of the paper on IBM AIX mentioning this parameter. Since this RHEL box show none on the value, so altered it to SETALL - "alter system set filesystemio_option=SETALL scope=spfile; " But af ...

Oracle DISK_ASYNCH_IO and FILESYSTEMIO_OPTIONS

Can anybody please help me to calrify the DISK_ASYNCH_IO and FILESYSTEMIO_OPTIONS database parameters.1. Which parameter takes precedence when setting both disk_async_io and filesystemio_options, and under what situations (eg use of a RAW or cooked filesystem) is this the case?2. Is this the same (t ...

Oracle FILESYSTEMIO_OPTIONS=setall always safe?

I'm quite confused with the parameter FILESYSTEMIO_OPTIONS.I need to know if setting the FILESYSTEMIO_OPTIONS=setall is ALWAYS working correctly regardless of the type of used storage?Is there any situation where setting FILESYSTEMIO_OPTIONS=setall may fail or may leave the database in some inconsis ...

Oracle FILESYSTEMIO_OPTIONS parametre

Good afternoon,Is it a good idea to mount filesystem without the os directio option and to set the FILESYSTEMIO_OPTIONS oracle parameter to async.Will performance be better ? ...

Oracle solaris ufs and filesystemio_options with setall

I have a quick question about direct i/o and the filesystemio_options parameter, in particular on ufs and Solaris. My understanding is that if we set this to setall (or directio), Oracle will, at its discretion, use direct i/o for file access. However, in the couple of machines I've looked at where ...

Oracle filesystemio_options=setall or directio doesn't affect caching

i wanted to avoid double caching but if i set filesystemio_options=setall or directio, io gets cached anyway.filesystem mounted with defaults option. os: linux, kernel version = 2.6.18-8oracle v 10.1.0.5fs: ext3.does anyone have the same issue? is there anything else should be done to avoid filesyst ...

Oracle Direct IO Benchmark - filesystemio_options = setall

Good day everybody, i just setup my AIX filesystems to direct IO and set the parameterfilesystemio_options = setall, in a development enviroment.how can i benchmark this change versus the Production one that is in asynch and without DIO.???Any suggestion is welcome. ...

Oracle DirectIO on Solaris : filesystemio_options v forcedirectio

The database instance parameter filesystemio_options set to "directio" or "setall" should automatically enable DirectIO on datafiles, regardless of whether theunderlying filesystem are mounted with the forcedirectio option.However, per Bug#6270440, this may not be working. There has been noupdate to ...

Oracle about filesystemio_options init parameter

Platform: Sun Solaris 5.9 (64bits)DB: 10.2.0.3Is it recommended to set the filesystemio_options to "setall"?What is the default value if the parameter is not set? Will oracle choose the best value for it if not set? Kindly advise as i wish to know more about it. ...

Oracle FILESYSTEMIO_OPTIONS

What would be the effect of switching from FILESYSTEMIO_OPTIONS = ASYNCH to:FILESYSTEMIO_OPTIONS = SETALL In regards to Oracle Text indexing performance, would it be faster, slower, or no difference in the time it takes to index? ...

Oracle Init.ora filesystemio_options and disk_asynch_io on Red Hat EL 5 10.2.0.4

Running 2 instances 64 bit 10g 10.2.0.4 with an app that does a lot of row updates and uses BLOBs heavily.Our storage (RAID 10) is presented through a single mount point.We have a DELL 8 CPU 5460 3.16Ghz Xeon with Dell Open Manage RAID 10 array Oracle 10g 10.2.0.4 on RedHat EL 5 withfilesystemio_opt ...

Migrating Oracle 10gR2 32bit to Oracle 11g 64bit options

I have an Oracle 10gR2 32 bit that needs to be upgraded to Oracle 11g 64bit:What are some of the options for upgrading Oracle database 10gr2 32bit to Oracle 11g 64bit?Can I export 10gR2 32bit and import it to 64bit Oracle 11g? ...

Migrating Oracle 10gR2 32bit to Oracle 11g 64bit options

I have an Oracle 10gR2 32 bit that needs to be upgraded to Oracle 11g 64bit:What are some of the options for upgrading Oracle database 10gr2 32bit to Oracle 11g 64bit?Can I export 10gR2 32bit and import it to 64bit Oracle 11g? ...

Oracle 8i to 11g upgrade options

What are the best options availbile for oracle 8i to 11g upgrade? ...

Oracle Options Upgrade 8.1.7.2 to 11g R1

I would appreciate some advice on upgrade path for 8.1.7.2 to 11g R1. The current 8.1.7.2 is running AIX v4.3.3 and we plan to run 11gR1 on AIX v5.3.Our database is currently at 80GB or so for datafiles but the additional on top of this brings it to 2500GB which is logs, codetree, application relate ...

Oracle 11g Cannot Disable Options

running 11.1.0.6 on Windows XP.Using DBCA I cannot check or uncheck the options installed.Remember on 10g there was no problem on doing thatAnyone got solution? ...

Oracle Universal Installer options in 11g

Sorry in case the following question has already been answered many times, so I would imagine, but I have not been able to find the answer so far.If I remember correctly, the Oracle Universal Installer in Oracle 9i and 10g was able to detect existing installations and allowed to install or remove or ...

Oracle OAM 11g - Options

I had installed OAM 11g, OHS 11g and Webgate 11g for OHS. In OAM Admin Console (http://<hostname>:7001/oamconsole), under policy configuration i have the option of Authentication Schema to configure.I have created a new Authentication Schema for FORM based authentication. But i am not able to ...

Oracle RESULT_CACHE_MODE option definition missing (11g doc)

Definition of RESULT_CACHE_MODE,[url=http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams207.htm#REFRN10270]Oracle® Database Reference11g Release 1 (11.1)Part Number B28320-01[/url]Only two values are describe : MANUAL and FORCE.But AUTO is allowed :Connected to:Oracle Database ...

Oracle OCA 10G or 11G

I recently wrote the OCA (Iz0-042) exam for 10G and failed due to having scored 66%.My study material: OCA 10g from SYBEX by BOB BYRLA and others (primary).oracle 10G product documentation (occasional reference).I can't afford OU's prep kit at USD 1500.Preparation time: 4 months (but evenings mostly ...

Oracle New WM features in 11g?

Anything to look forward to with respect to workspace manager in 11g?I'd especially like to see a backup/restore tool that is workspace aware so that there are more options than the full-only backup/restore method.Bryan ...

Oracle I can't create a new database user in 11g,what's wrong?

I wanted to create a new user,but it allways failed and I don't know why.Here is the message I copied from the terminal: [oracle@rht db]$ ORACLE_HOME=/u01/app/oracle/product/11.1.0/db[oracle@rht db]$ ORACLE_SID=oca[oracle@rht db]$ export ORACLE_HOME ORACLE_SID[oracle@rht db]$ bin/sqlplus sys as sysd ...

Oracle Better Materialized View support in 11g?

We are using materialized views as a work-around to improve performance on versioned tables with spatial data and would like to know if there will be improved support in 11g.Currently we have to do a complete refresh but would like to use options like "fast refresh" or "on commit". ...

Oracle Changing options as reported in V$OPTION

How do I change options that are reported in the V$OPTION view? For example, I want to enable partitioning. So somehow I need to set the Partitioning option to TRUE. I cannot find anything in the documentation that tells me how to do that.I'm only using Oracle XE because I run SUSE LInux Enterprise ...

Oracle 11g DBMS_FLASHBACK.TRANSACTION_BACKOUT

Has anyone tried this new feature on 11g? I would like to see an example of it working. I tried to call this apiDBMS_FLASHBACK.TRANSACTION_BACKOUTnumberofxids NUMBER,xids XID_ARRAY,options NUMBER default NOCASCADE, timeHint TIMESTAMP default MINTIME);using following code and it gives me error...DECL ...

Oracle Apex on 10gR2 -- Use 11g or 10g HTTP Server?

We're just starting an Apex development effort, and have a couple of environmental limitations to respect in our production and test environments...i) 10gR2 databaseii) Separation of database and web tiersGiven these constraints we'll be using the Oracle HTTP Server on a different host to the 10gR2 ...

Oracle 10g connecting to 11g

I am trying to connect Oracle 10g client (installed on WinXP) to Oracle 11g database (installed on WinXP). The connection failes with the error No Listener returned.Below are the details.On the database side (ip: 217.164.80.21 hostname:winxp ):I removed the listener service, restarted the machine, a ...

Oracle result_cache does not work in 11g

-bash-3.00$ uname -aSunOS tssoldb01 5.10 Generic sun4u sparc SUNW,Sun-Fire-V210-bash-3.00$ sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 29 11:37:14 2008Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to:Oracle Database 11g Enterprise Edition Release 11.1.0 ...

Please Help !! - Problems installing Oracle 10g, and 11g on Red Hat Enter

All - First off, thank you for taking time to read my question. I am having problems installing Oracle 10g (R2) onto RHEL4. I am running a VMWare workstation ontop of Windows XP Pro. The virtual machine has 1.5GB memory allocated. Two Virtual disks, one with 60GB of space, the other with 20GB of spa ...

Oracle Physical standby database Version 11g Creation over grid control 10g

We are useing oracale 11g enterprise edition and want to create a physical standby database on another machine:On primary host we've installed "standard database" and turned on archive log mode over em.On the standby host we've installed only oracle without a database and without a listener.On a thi ...

Oracle 11g Installation on MSW XP SP2 ora-19870

I downloaded the 11g .zip for MSW 32-bit twice onto two separate WSs running XP SP2.I installed the loopback adapter with fixed IP 10.10 ....Ping works fineWhen doing the 11g default installation (w/o netconfig ***.) I get the same error on both WSs:ORA-19624: operation failed, retry possibleORA-198 ...

Oracle Cannot login to ILM 1.2/11g DB using ADMIN but can login as ADMIN w/APEX 3

Lillian,I downloaded and installed ILM 1.2 on a 11gR1 enterprise database(Solaris64).I was able to install and access the APEX 3.0.1 application.I am using the Enabled Gateway method.I did enable the Network Services for 11g as required.I set the port within APEX to 8080 using the exec command in th ...

Oracle An inheritance & indexes in 11g

HelloNow I'm using 11gHere is my sample. I took the sample from "Oracle XML DB Developer's Guide, 11g Release 1 (11.1)" and added an inheritance. This is the schema:DECLARE doc VARCHAR2(3000) := '<schema xmlns="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.oracle.co ...

PL/SQL Gateway performance problem on Oracle 11g

HiI have an installation of Oracle 11g using the embedded PL/SQL gateway with APEX 3.1.1.00.09.The web server takes along time to respond at random times during the day, the server is dedicated to Oracle and has no other services negatively affecting performance, CPU usage is normally around 1% and ...

Oracle KUPW$WORKER.UNLOAD_METADATA Errors with EXPDP 11G

I'm trying to do an expdp on a fairly new install of 11g. This DB has been up and running fine for about 2 weeks. It was a fresh install of 11g and then I impdp the data from our old 10R2 DB. That all went fine. Now I'm doing another fresh install of another 11g DB on another server. So I'm trying t ...

Oracle emca on 11g hanging when dropping/recreating repos

Configuration: Windows XP SP3 32-Bit (3.2GB memory available to OS)Oracle Database 10g 10.2.0.3.0Oracle Database 11g 11.1.0.6.0Oracle Developer Suite 10g 10.1.2.0.2I've noticed a few posts about emca and I'm sorry if I've missed the solution to the issue I have. I hope someone can help or point me i ...

Oracle how to enable advanced compression option in 11g?

Does anyone know how to enable use of the new advanced compression option in an 11g Enterprise Edition installation?During the Oracle installation I choose the Enterprise Edition and there isnt any "Advanced Compression" option shown. I also have tried to install using a Custom install and it doesn' ...

Oracle ASM 11g Install not discovering all disks

Doing an 11g ASM Installation, and not all raw disks are being offered as options when creating the ASM Disk Group.System details: 2xHP-UX (Itanium) servers, clustered, (Oracle Clusterware installed without error), including Raw devices being used for OCR and Voting disks.4 raw devices should be ava ...

Oracle 11G After install - database creation - TNS error

I am a newbie to Oracle and after many hours I managed to get 11g installed but to do so I had to uncheck the create database option so now I am trying to use the database configuration assistant to install the database. As near as I can tell the install looks ok and the listener configured successf ...

Oracle ORA:600 11g

We have installed oracle 11g (version: 11.1.0.6) and then we have noticed following error messages in our alert and trace files. Please help us resolve this problem as this is happening on our production database.**Following error message in alert.log file:**Fri Jan 09 19:57:00 2009ARC2 started with ...

Oracle DB upgrade 10g to 11g cross platform (Solaris to Linux)

I'm thinking about the best way to implement an Oracle upgrade cross-platform: I have a 10g DB on Solaris 10, and my target is an 11g DB on RedHat Linux.Oracle supports the same-platform upgrade (step 1 would be an upgrade from 10g Solaris to 11g Solaris), and RMAN offers the possibility to transfer ...

Oracle 10g to 11g import prob.

i have taken a dump of a table using 10g export utility from oracle 10.2 database where character set AL32UTF8 and trying to import it in oracle database 11.1 (character set is WE8ISO8859P15) using 10g import utility. all rows are successfully imported, but oracle is not able to create indexes and f ...

Oracle Imp on 9i Dump file of 11g

I need move data of my database 11g to other database but 9iFirst I make a dmp whit the export client 9i:nodo1-> export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252nodo1-> exp <user>/<pass>@orcl11 file=client.dmp log=client.log owner=AExport: Release 9.2.0.8.0 - Production on Fri Apr 24 ...

Oracle CONNECT BY QUERY returns different count of rown in 10g resp. 11g databases

Folks,I just spot a bellow issue in our databases. 1.) 10g database:Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production With the Partitioning, OLAP and Data Mining options   SQL> select * from global_name;   SQL> SELECT ROWNUM 2 FROM dual 3 CONNECT BY ...

Oracle Why is DataPump in 11g not smarter

I am trying to run several data pump jobs in my 3 node rac env. On node 1 I have 2 impdp jobs running, and I would like to run 1 or 2 more on nodes 2 and nodes 3.so here its$ impdp user/****** parfile=USER.parImport: Release 11.1.0.7.0 - 64bit Production on Friday, 29 May, 2009 8:36:50Copyright (c) ...