Oracle 9i For Linux Environment (64 Bit)?
Jul 18, 2013link where can i get oracle 9i for Linux OS??Is 9i available for 64 bit ?
View 4 Replies
ADVERTISEMENT
Backup & Recovery :: Moving From One Windows Environment To Another Linux Environment?
Jun 19, 2012I'm trying to move my backup sets from windows database environment, to OEL 5.7 environment on another server.
I've found a manual [URL] by which I am trying to do it.I took backup sets from last night's backup using RMAN,and the current parameter(initSID.ora) file from the running live database.Now i need to configure control files in the pfile accordingly.
1. can i take current control files from the running system, to restore and recover backup sets from last night, to the state the database was at backup time?
2. how can i find out if control files are backed up and know by RMAN? "list backup completed after '2012-JUN-19';" >> gives me Archive redo logs, datafiles, but don't see the control files(or don't reconize them).
Add 3rd Node To 11gr2 Grid With 11.2.0.2 And 10.2.0.4 Homes In Linux Environment?
Feb 23, 2011We have 2 node cluster with 10.2.0.4 home and 11.2.0.2 home under 11gr2 grid infrastructure with ASM in LINUX environment. We are planning to add 3rd node to this cluster. Is there any issues to add 3rd node to existing environment or running fine.
View 2 Replies View RelatedReports & Discoverer :: Rupees Symbol On Linux Environment In 6i
Nov 30, 2011I have one problem related to run Report 6i on Linux Environment.I have created new report with New Rupees Symbol(Rupee foradian) for Windows Operating System it is working properly appears new rupees symbol sign properly.
But i compile same report in linux environment and after that run through browser new rupees symbol not show properly instead of rupees symbol `(entitled sign)appears on my report.
Upgrade :: Upgrade 11.2.0.2 To 11.2.0.3 On Linux Environment?
Mar 23, 2013I try to upgrade 11.2.0.2 to 11.2.0.3 on Linux environment. I have to apply patch P1253900 before the upgrade per oracle doc.
however I got following conflict:
Verifying environment and performing prerequisite checks...
Checking skip_duplicate
Checking skip_subset
Conflicts/Supersets for each patch are:
Patch : 12539000
Conflict with 12827726
Conflict details:
/u01/app/grid/product/11.2.0/grid/lib/libserver11.a:/ksxp.o
Following patches have conflicts: [ 12827726 12539000 ] Refer to My Oracle Support Note 1299688.1 for instructions on resolving patch conflicts.
I checked above oracle note, and did not say any resolution.
How To Put Same Oracle Environment On Two Machines
Aug 23, 2012we are planing to put the same oracle environment on two machines.
what is the best way to realize that.installation on each machine or installation on one machine and copy the environment to the second?
Upgrade From Oracle 11.2.0.2 To 11.2.0.3 In A Test Environment
Aug 29, 2012recently i have tried to upgrrade from oracle 11.2.0.2 to 11.2.0.3 in a test environment (virtual machine).
there i have mentioned the SID as ORCL, but when we took the same snapshot to other machine (VM). iam unable to connect to the VM, unless i gave the local net service configuration as ORCL but it is unable to connect. but when i ran the query "select * from GLOBAL_NAME" output was ORCL. domain. com again i have configured in LNSC as ORCL.DOMAIN.COM it is working.
but i have given the sid as ORCL..
Oracle Clustered Production Environment
May 26, 2013I have a requirement to upgrade Oracle Data Integrator(ODI) from 10.1.3.5 to 11.1.1.6.3 We have a Clustered production environment where N1 will be up when N2 be down and viceversa.
Here N1 and N2 are the ODI servers as well as DB(11g Release 2) servers. They both access the SHARED CLUSTERED database. From ODI we will generally point the Oracle clustered IP(Virtual IP) which will internally point either N1 or N2 whichever is active. ODI application wise we are clear about the procedure.
Having some issues on DB related activities.
1. Should I break the cluster definitely? Cant I do the activity without breaking the cluster?
2. Do I need to point N1, N2, Clustered IP (Virtual IP) while doing the activities?
3. Since its a clustered database, do I need to db related activities once or twice? (Twice means, manually on both the servers)
4. As they are using same file structures (RAC), If the Virtual IP points N1 by default, assume that I create two new users a
Queueing :: How To Configure Oracle AQ For Distributed Environment
Sep 23, 2013I have a scenario In which I have say 4 AQ in which I will post the message.Also i have say 2 database.I am planning to create an MDB which will poll on these AQ's, so whenever I post message the MDB will read it and perform a specific action.I believe I can create only one MDB per queue, if it is so then I have to create 8 MDB.
As there 2 datasource and 4 MDB. Is there any other way to handle this I mean without creating 8 MDB as the Data sources can increase to 10 to 20 so the number of MDB will be 20 to 40.I guess this will affect the application performance. Can I make some changes in application so that only few MDB's are required?
Moving Oracle 11g UNIX Sun Solaries To Oracle 11g Linux Readhat OS
Aug 8, 2012We would be moving oracle 11g unix sun solaries to oracle 11g Linux readhat OS. what would be the disadvantage and what are the item needs to be verified. Basically advantage of oracle 11g Linux readhat OS.
View 2 Replies View RelatedBring Down The Databases In Oracle Fail Safe Environment?
Jun 28, 2013How can we bring down the databases in oracle fail safe environment?
We have one database X in two server�s windows A & B with oracle fail safe environment.
What procedure should we fallow to bring down the database X.
Today I was strangling to bring down the database because database was automatically coming up once brought down the database. what procedure should we follow to bring down the database in OFS environment.
Installation :: Environment Variable Path Failed In Oracle 11g?
Dec 13, 2012i am reinstalling oracel 11g in my window 7 64 bit machine after i uninstalled it. however, i got an issue that is environment variable path failed in the installation process. this didn't happen when i firstly successfully installed oracle.
View 7 Replies View RelatedPrecompilers, OCI & OCCI :: Oracle 8i Environment - Segmentation Fault?
Jul 15, 2008I am running a job that is using Pro C code. I am running it on an Oracle 10g database with an Oracle 9 client on a UNIX platform. The code compiled fine. The job runs fine sometimes but other times it fails with a Segmentation Fault error.
I have the same job running in an Oracle 8i environment with no problems.
Data Guard :: Change Non-SYS Password On Oracle 11g Environment?
Jul 26, 2012how to change non - SYS oracle users' password in data guard envirnment. We all know that for SYS password change in data guard. DBA has to change in primary database by either "alter user SYS identified by xxxx" or create password file with orapwd.
Then scp password file to standby database. However, if I want to change SYSTEM or DBSNMP passwords, I change on primary with " alter user ....." SQL, then new passwords will be login dictionary. But this new SYSTEM pqssword will be shipped with redo log to standby and SYSTEM password on standby will be updated? I need technical answer on this question
Backup & Recovery :: Process Of Setting Up DR Environment For SAP And Oracle Database
Feb 7, 2012We are in the process of setting up a DR environment for our SAP and Oracle databases . The netapp and our architects came up with solution as follows .
1.Standby databases are built for all production databases.
2.The SAP file systems are replicated to the secondary site
3.The Oracle logfiles and controlfiles are replicated by netapp snap mirror every 10 mins interval
4.The database is recovered through recover standby database every 15 mins at standby site
5.Please note there is no data guard involved .
6.To test the failover , the mirror is broken .The standby controlfile is replaced with Production controlfile and Redo logs files.
7.The standby database issued a startup comnmand and it worked .
Would like to know whether the step 6 is a correct approach ? I tried to convince the architects that this will result in a very disastrous situation for us but none is listened to .
Application Express :: Access Oracle EBS Environment With Developer-level?
Jan 12, 2013how to integrate Application Express with Oracle EBS. Any companies that offer hosted EBS environment with APEX and allow developer-level access (ie database, application server, front-end responsibilities)?
View 1 Replies View RelatedPL/SQL :: Overcome Prompt User ID And Password To Connect Oracle DB From Unix Environment?
Mar 23, 2013How to overcome the prompt user id & password to connect oracle DB from Unix environment.
View 2 Replies View RelatedReal Application Clusters :: Oracle 11GR2 - Test All Applications On Dev Environment
Jun 13, 2012I've just patched a development oracle environment (RAC 11GR2) with temporary patch 8730312. I would like to do same thing on Production RAC. Is it necessary to test all applications on dev environment with this kind of patch before deploy it on Production ?
View 2 Replies View RelatedOracle 11g EM Not Working (Linux OS)
Jan 20, 2011I am unable to configure EM(Oracle 11.2g) on Redhat Linux 5 Enterprise edition(32 bit). Environment variables are set to correct SID. If I try to run dbca the wizard does not display the Enterprise manager configuration screen. I have tried to create repository by using emca -config dbcontrol -db config.
But it throws exception that database instance is unavailable?
How To Install Oracle On Linux
Feb 25, 2012how to install oracle on Linux.
View 2 Replies View RelatedOracle 11g R2 Installation On Linux 5.5 - Non-RAC / Non-ASM
Jul 25, 2012SQL>startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initora11g.ora'
Unfortunately I can not find initora11g.ora
[oracle@localhost db_1] cd dbs
[oracle@localhost dbs] ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora
so create pfile from spfile='/home//oracle/product/11.2.0/db_1/dbs/spfileora11.ora will not work
[oracle@localhost dbs]$ ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora
I don't see initora11g.ora file - as shown above in oratab also - it showed sid as orcl but I changed into
I have set oracle_sid = ora11g in .bash_profile as well
Oracle 11g Client Linux 32 Bit
Nov 18, 2012share with me a linnk of oracle 11g client on RHEL 5 32 bit due to i search in oracle web site and found only 64 bit URL.....share with me a link of installation guide of this client?
View 4 Replies View RelatedOracle Linux Account
Oct 22, 2012I have installed oracle enterprise linux 6.2 on my laptop, and I installed the database 11gR2 on it, know the user account I used to log in with (os level) is not accessible any more :
[URL].........
if I remove the account and recreate it does it will cause problems to the database?
Oracle Error In Linux Fedora
Nov 20, 2006I get this error when trying to log in to SQLPlus in Oracle
ERROR:
ORA-12516: TNS:listener could not find available handler with matching protocol stack
Oracle RAC 11g R1 On Linux Using VMware Server
Jun 15, 2011During installation of Oracle RAC 11g r1 on Linux using VMware server for Two Nodes, all the pre cluster installation test was successful, and execution of root.sh on node 1 was successful too, but whenever I run the root.sh script on the second node I get error message "Failure at final check of oracle CRS stack. 10"
View 3 Replies View RelatedInstall Oracle 10g And 11g In Same Linux Server?
Jul 19, 2012Looking to install oracle 10g in same server where i have installed already oracle 11g,
: i have looked at how to install oracle 11g and 10g on same linux server.but didn't quite get it ....
PL/SQL :: Oracle 11g On Linux - Collapsing Rows
Jan 28, 2013Oracle 11g on Linux. Previously submitted as Matching Rows.
I have the following table.
create table p
(pid varchar2(10),
first_name varchar2(10),
last_name varchar2(10),
type_code varchar2(5)
);
[Code]....
I used SELECT *
FROM (SELECT pid,
first_name,
last_name,
type_code,
COUNT (*) OVER (PARTITION BY first_name, last_name, type_code)
cnt
FROM p)
WHERE cnt > 1;
to get only the rows 1A and 3A
PID FIRST_NAME LAST_NAME TYPE_CODE
1A DENNIS ALRIDGE G5
3A DENNIS ALRIDGE G5
but, a new requirement is to get it in the format:
PID1 FIRST_NAME1 LAST_NAME1 TYPE_CODE1 PID2 FIRST_NAME2 LAST_NAME2 TYPE_CODE2
1A DENNIS ALRIDGE G5 3A DENNIS ALRIDGE G5
I tried mod(rownum,2) != 0 to separate the row numbers, but the output is offset with null like:
PID1 FIRST_NAME1 LAST_NAME1 TYPE_CODE1 PID2 FIRST_NAME2 LAST_NAME2 TYPE_CODE2
1A DENNIS ALRIDGE G5
3A DENNIS ALRIDGE G5
How do I collapse the rows?
XE :: Where To Download Oracle Database For X86 Linux
Jun 5, 2012URL.....Where can I download Oracle database express edition for x86 Linux? I can only see Windows and x64 Linux in Oracle's download page URL....
View 2 Replies View RelatedXE :: How To Install Oracle XE 11g On Linux 6 (x86_32)
Aug 9, 2012Can I install Oracle XE 11g on Oracle linux 6 (x86_32). Where can I download XE rpm?
View 3 Replies View RelatedHow To Install Oracle EM Remote Agent In Linux
Nov 14, 2006When I was installing the oracle DB and instance in my linux server, I chose not to use oracle EM to administer it. I want to add the EM now, may I know what is the procedure?
If I want to use oracle EM installed in another server (for example oracle windows server) to administer it. May I know how to install just the EM remote agent in the local linux server ? what is the procedure?