11g On Suse Linux
Aug 14, 2012
Recently, We moved our production environment from Solaris - oracle 11g RAC to Suse linux - Oracle 11g RAC. After this migration, We are facing the poor performance issues where the simple select query joining 4-5 tables was almost running for more than 10 hrs without any result. Finally, We had to kill the session and restart.Actions which we have taken so far :
1) We analyzed the tables involved. ( No improvements)
2) Rebuild the indexes. ( No improvements)
3) Rebuild the table - This resolves the issue and job completed in the expected time without any issue.
But again some other jobs are having the same problem but my guess would be rebuild all the tables is not the permanent solution. There could be some issue in the background like Datablock corruption etc.
View 4 Replies
ADVERTISEMENT
Oct 8, 2012
We are planning Database Migration From Windows to Linux Using RMAN..We required Oracle database 10.2.0.4 for Linux 64 bit.
View 3 Replies
View Related
Mar 31, 2008
Where to get the Metalink Doc-ID for Migration from windows 2000 to Linux.
View 14 Replies
View Related
Jan 20, 2011
I 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?
View 5 Replies
View Related
May 4, 2013
First of all, I'm not a DBA, and when I try to import the dmp file generated on AIX with Oracle 10G on a RHEL6 11G machine I got a lot of issues, how to do this?
View 3 Replies
View Related
Sep 29, 2010
i am new to linux os . the step by step process of oracle database 10gR2 and oracle 10g client installation in linux os
View 6 Replies
View Related
Sep 16, 2011
After querying the view v$db_transportable_platform, I can not see any information about Solaris SPARC, but only about Solaris x86. Can I migrate database to Solaris SPARC? What can I do to performing RMAN CONVERT?
View 1 Replies
View Related
Feb 25, 2012
how to install oracle on Linux.
View 2 Replies
View Related
Jul 25, 2012
SQL>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
View 1 Replies
View Related
Sep 29, 2010
I am new to linux OS i don't know how to install forms in linux.
the step step process of installation of forms 10g in linux OS.
View 1 Replies
View Related
Nov 18, 2012
share 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 Related
Jul 18, 2013
link where can i get oracle 9i for Linux OS??Is 9i available for 64 bit ?
View 4 Replies
View Related
Oct 22, 2012
I 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?
View 5 Replies
View Related
Mar 3, 2012
I need to migrate a 500 GB 10.2 database from windows to linux. Of course I found Alejandro Vargas paper on how to do that ("Database Migration From Windows to Linux Using RMAN"). My problem is that the source database will be up again for 7 days and I need to apply all changes made to the source database to the migrated linux database.
Can I just take all redo log files generated from the source database and apply those to the destination database? I might have a problem with a) file conversion and that the redo log are not in sync with the target database (different check points?).I just found that on an exotic website: "The contents of a redo log file depend on a combination of Oracle version, operating system and server architecture. In general redo logs written on one architecture cannot be read on another. There are a few exceptions to this rule. For example, in Oracle 10.2 a redo log written in Linux can be read by a Windows database."
So if this is true, does it also work the other way AND will the database migration from window to linux create a perfect clone of the database where those redo log files actually can be applied to?
View 1 Replies
View Related
Aug 27, 2013
we are busy updating one databasee from a windows platform 2003 oracle 10G to a linux and oracle 11r2
We exported/imported the data and it looks ok Explain plans look the same . but our heavy batches are twice slower than on the windows box ,the two top events are disk related, sequential and scattered reads there are 90% of the time of the batch job , i read some white paper and found that using ASM can be bad in some cases the same with the linux for this particular kind of scattered reads , i was just wondering if just changing the SGA to 10GB instead of 4GB to get more cache and speedup the things .
View 3 Replies
View Related
Jun 16, 2013
while using top command it shows multiple processes usage.Actually we have 3 databases in the same server.how to find out which database process and user session hogging the cpu resources
View 2 Replies
View Related
Sep 12, 2011
We are planning to migate Oracle database from Linux 10gR2 (non-ASM) to Solaris (ASM) and then Oracle upgrade that database from 10gR2 to 11gR2 on Solaris.
View 4 Replies
View Related
Nov 20, 2006
I 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
View 1 Replies
View Related
Jul 26, 2011
How I can maintain a replication scheme from a production database and a standby. I was watching the advanced replication methods of Oracle, but what I want is in the evening to run a process and modify the database incrementally and thus leave until the next night.
And the server I want to allocate to the standby database, also implements other processes, so my settings would be:
Production: Oracle Database 11g Linux 5.5
Standby: Windows 2003 Database 11g
Maybe that data is important, let me make clear that what I want is that the database is updated incrementally.
View 1 Replies
View Related
Jun 15, 2011
During 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 Related
Oct 3, 2007
Every time when i open terminal, I have to set ORAENV variable in linux. I tried to find out .bash_profile but i can't find where it resides.
View 11 Replies
View Related
May 23, 2010
I am trying to install OEM but the GUI asks for weblogic server home.i checked many documents in net but none has weblogic installation procedure. Is it the sequence of installation ?
View 2 Replies
View Related
Jan 19, 2010
We have a product in Oracle forms 10g running in Windows XP OS, we want to migrate this into Linux OS.
View 4 Replies
View Related
Mar 9, 2011
provide me the online material or some links where i can follow the instructions step by step to configure 10G RAC on LINUX 5.0 machine.
I have 3 separate machines having Linux 5.0 . I want to do this for R&D purpose.
View 1 Replies
View Related
Apr 1, 2011
What I wanted to know was the steps to place a RAC cluster onto a brand new Linux server.
Step 1 - Install Cluster Software , CRS & Voting Disks
Step 2 - VIPCA - VIP Config (VIP, GSD, ONS) Resouce Apps
Step 3 - Create ASM Instance
Step 4 - Install Grid Infrastructure
Step 5 - Install RAC
Step 6 - Create Cluster DB - using DBCA with Enterprise Manager
This will be a 2 node RAC cluster going onto a Redhat 5 Linux box
View 2 Replies
View Related
Oct 27, 2010
My database as well as application on linux. I want to execute this command on linux. I need equivalent code.
host('cmd /c E:data empITC1'.bat');
code of ITC1.bat is
echo off
sqlldr userid=user_name/pass@database control=E:data empITC1.ctl log=E:data emplogITC1.log
echo ........
control file as well as bat file exist in respective folders.
View 9 Replies
View Related
May 18, 2010
I am running forms 6i in Linux Mint environment. I used Go_Item('emp_cod') after commit on save button.
Code is as under:
IF NVL(:BAL_QTY,0) > 0 THEN
GO_ITEM('EMP_COD');
ELSE
GO_ITEM('OP_ID');
END IF;
Control moves in relevant item but there is no cursor indication and no data can be entered in this field. When I press TAB or ENTER key the code written on Key-Next-Item executes properly. It means that control moves to that item but nothing could be written in this. This form is working properly in Windows environment.
View 3 Replies
View Related
Jun 7, 2011
What is the best pl sql editor for Linux OS?
View 10 Replies
View Related
Nov 1, 2013
I was trying to execute below query inside a sql script which is called from a shell script on linux environment. EXECUTE IMMEDIATE 'alter session set events ''10176 trace name context forever'' ';
This thing works at our test environment. But giving error "SP2-0670: Internal number conversion failed" when tried on live(production) environment. What could be the reason? I found another way of writing such queries on net as follows, will it be useful? EXECUTE IMMEDIATE q'|alter session set events '10176 trace name context forever'|
View 1 Replies
View Related
Jul 19, 2012
Looking 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 ....
View 15 Replies
View Related
