Oracle Listener Version Mismatch (10g / 11g) After 11g Upgrade?
Aug 9, 2012
I had two installations of Oracle on my server (10.2.0.4 and 11.2.0.1) under different linux users. The Databases used different listeners on different ports.
I upgraded my Oracle 11g to 11.2.0.3 successfully two weeks ago. However today I just checked that I couldnt reload my Oracle 10g Listener. On further analysis (lsnrctl status) I discovered that my 10g listener's version was "TNSLSNR for Linux: Version 11.2.0.3.0" . My Start Date from lsnrctl gives me the date when my Oracle 11g was upgraded.
Now I have tried to reload my 11g listener which works normally. I cannot reload my 10g listener (TNS-01190: The user is not authorized to execute the requested listener command). When i run ps command there is no process on my server for my 10g listener. I can only see my 11g listener process after running ps command. However everybody can ping my databases on Oracle 10g but i cannot identify or kill my listener process even on server level.
View 4 Replies
ADVERTISEMENT
Jul 1, 2011
I have installed oracle 10g version 10.2.0.4.0 on Windows 7 64 bit from the following link.
[URL].........
After login to SQL* plus, when i see the version, it shows as 10.2.0.3.0. Is this correct?
View 8 Replies
View Related
Apr 27, 2011
I want to upgrade my Oracle version from 10.2.0.1.0 to 10.2.0.4.0 but but i don't know what are the correct ways. i read the read me file in the patch set and fallowed the steps but its giving me error e.g. "Error in writing to file D:Oracleproduct10.2.0.2.0inoraevrus10.dll" every time. We have no RAC and Cluster Environment.
View 10 Replies
View Related
Jun 26, 2012
We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here [URL] .....) where the apparent mismatch between the oracle drivers are causing the errors.
Our db servers are using 10.2.0.4 and 10.2.0.5 drivers and the clients are using 10.2.0.1.
Firstly, are the drivers the same on the Express and Enterprise editions so that if I update a development server using Express version (I don't have the authority to upgrade the Enterprise version nor the time to commission that) and it is successful, can I reasonably expect an upgrade to the Enterprise client versions on other servers to be safe/error free, baring environmental factors of course ?
Secondly, can I upgrade to version 10.2.0.5 now or do I have to go to the 11g version only ?
View 2 Replies
View Related
Feb 8, 2012
what jobs will be created when we upgrade to oracle 11.1 version ?
View 4 Replies
View Related
Oct 4, 2010
I have one query regarding ORACLE 10g RAC.
I have installed 10gRAC [10.2.0.1] on VMware.
now I have requirement to upgarde it this existing RAC setup to 10.2.0.4.
options for me the steps or sequence I need to follow in upgrade path? like first needs to upgarde crs,then fro ASM and lastly for DB something like this.
View 5 Replies
View Related
Jun 24, 2012
I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in Linux 32 bit . I faced the version incompatibility error during patch set installation and hence ran the patchset installation with -ignoresysprereqs option.
Now during the patchset installation i encountered the below error in in the install logfile.
**************************************
INFO: Start output from spawned process:
INFO:
--------------------------------------------------------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/bin/genclntsh
INFO: genclntsh: genclntsh: Could not locate /u01/app/oracle/product/10.2.0/network/admin/shrept.lst
INFO: make:
INFO: *** [client_sharedlib] Error 1
INFO:
INFO: End output from spawned process.
INFO:
--------------------------------------------------------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/network/lib/ins_net_client.mk'. See '/u01/app/oracle/oraInventory/logs/installActions2012-06-24_11-45-11AM.log' for details.
Exception Severity: 1
***********************************************
Provide me the certified os and versions for oracle db 10gr2
View 2 Replies
View Related
Oct 1, 2010
I am testing upgrade from 11.1.0.6 to 11.2.0.2 patchset on linux X86-64 version. And facing the following component related issue.
The following components cannot be upgraded as the corresponding upgrade scripts are missing:
OLAP Analytic Workspace ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/apsdbmig.sql )
OLAP Catalog ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/amddbmig.sql )
Spatial ( /u01/app/oracle/product/11.2.0/dbhome_3/md/admin/sdodbmig.sql )
Oracle OLAP API ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/xoqdbmig.sql )
If you want to upgrade these components, you must first install them, using the OUI, and then re-run the Upgrade Assistant. Do you want to continue with upgrade? Note: If you continue, the above components will not be considered as part of the upgrade process.*
Following is the status of the specified components from 11.1.0.6
COMP_ID COMP_NAME VERSION STATUS
AMD OLAP Catalog 11.1.0.6.0 VALID
SDO Spatial 11.1.0.6.0 VALID
APS OLAP Analytic Workspace 11.1.0.6.0 VALID
Should I install these components while installing 11.2.0.2 patchset prior upgrading? I was unable to find any component installation on OUI.
Also DBUA pre-upgrade asked to remove existing UltraSearch from 11.1.0.6 prior upgrading. Though I removed it, but not sure is that going to hamper the upgraded DB, as I'm not sure of the usage of this component as well.
View 7 Replies
View Related
Feb 6, 2013
Mistakenly I have configure dataguard on different versions. Primary is 11.2.0.3.0 and Stand By is 11.2.0.1.0. Log shipping is perfectly working, but cannot put Stand By in read only mode.
View 3 Replies
View Related
Oct 31, 2012
We are upgrading 10.2.0.4 enterprise edition single instance to 11.2.0.3 enterprise edition single edition manually. What should the listener status while doing upgradation. This is my first upgradation project.
View 5 Replies
View Related
Feb 18, 2013
how to upgrade Oracle apex listener from 1.1.4 to 2.We are using Oracle apex listener with Glassfish 3.1.2.
View 0 Replies
View Related
Mar 30, 2012
I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?
View 4 Replies
View Related
Jun 6, 2012
Along with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory
Select * from dba_directories; (there are other commands to get this info as well).
I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?
Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.
View 4 Replies
View Related
Jun 14, 2012
Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?
View 1 Replies
View Related
Jul 19, 2013
I am going to upgrade database from 11.1.0.7 to 11.2.0.3
1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?
View 6 Replies
View Related
Mar 13, 2013
We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1
No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.
can we upgrade the oracle database from enterprise edition to latest standard edition?
View 3 Replies
View Related
Oct 15, 2010
We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.
if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.
Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.
View 3 Replies
View Related
Jun 3, 2010
I have a report of version 10g . I want to run this report in oracle reports 6i version.
View 1 Replies
View Related
Feb 21, 2013
I am trying to come up with a plan for an upgrade that is needed for a server I maintain. It is a Windows 2003 32bit running Oracle 10.2.0.3 on old Hardware. It also has two obscure 3rd party applications that are running on it that directly access the database. These applications are supported by off site consultants.
My initial plan was to Create a Windows 2008 R2 Virtual Server and install the same version of Oracle 10.2.0.3. Using Rman clone the database to the new server. Have the consultants come in and get the applications working. Once everything in the new environment seems to be working fine, run RMAN again and reclone the database to have all the latest data. Then at a later time upgrade the database to 11g 32bit. Virtually no downtime and we could spend all the time we needed getting the applications working and testing the new environment.
The plan is dead right of the bat though because I realize 10.2.0.3 is not supported by Windows 2008 R2. I really did not want to add an Oracle DB upgrade into the mix at the same time. Just because their are so many changes from the old environment to the new that I want to break this down into manageable chunks. And I can maybe get by with 1 day of down time.
So now I am looking at installing 11g on my Virtual Server, Clone the database, upgrade the database, have the consultants come in and get the applications working. All the while we are down. If we run into any problems, which you always do, it just completely blows the schedule.
View 1 Replies
View Related
Jun 29, 2012
I need to upgrade our current system 10.2.0.5 (non Asm) to 11.2.0.3(ASM) on the same host.
So a few options : install ASM on current 10.2.0.5, create volumes etc and shift DB into ASM
upgrade to 11.2.0.3 GI - standalone
upgrade DB to 11.2.0.3
install 11.2.0.3 GI, configure ASM and run against 10.2.0.5
DB upgrade DB to 11.2.0.3
The DB upgrade has to come last I've been told.
View 1 Replies
View Related
May 31, 2010
How to know the uses to oracl9i version ?
View 2 Replies
View Related
Jan 28, 2012
I have taken the export backup of a table using the following command
userid=system/manager@DBATEST
file=abc.dmp
log=abc.log
Tables=X.S_ORG_EXT_X
feedback=100000
buffer=10000000
[code]......
but on querying the table it shows the number of rows as
select count(*) from X.S_ORG_EXT_X;
COUNT(*)
----------
25656051
Explain why there is a mismatch in the count of the rows in the table.
View 1 Replies
View Related
May 5, 2011
I believe I have a problem with the ASM Kernel rpm that I downloaded from Oracle OTN
my Linux OS is
[root@UKEDXDTMTDBS01A u01]# uname -r
2.6.18-194.el5
So I downloaded the x3 ASM files required
[root@UKEDXDTMTDBS01A u01]# ls -ltr *.rpm
-rw-r--r-- 1 oracle oinstall 90858 Apr 12 14:18 oracleasm-support-2.1.4-1.el5.x86_64.rpm
-rw-r--r-- 1 oracle oinstall 14176 May 5 10:10 oracleasmlib-2.0.4-1.el5.x86_64.rpm
-rw-r--r-- 1 oracle oinstall 137486 May 5 10:29 oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm
As you can see the install worked fine
rpm -Uvh oracleasm*.rpm
warning: oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
warning: oracleasm-support-2.1.4-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
[code]...
So therefore it does not show any disks
[root@UKEDXDTMTDBS01A u01]# /usr/sbin/oracleasm listdisks
[root@UKEDXDTMTDBS01A u01]#
Am I doing something wrong -
View 5 Replies
View Related
May 28, 2008
difference between oracle version 10.2.0.3 and 10.2.03.I searched a lots of sites to get the details about these versions but unable to collect.
Oracle released both version or 10.2.0.3 and 10.2.03 are same versions treated by oracle.
View 2 Replies
View Related
Nov 9, 2010
I am trying to install Oracle 9i 32bit client on a windows 2008 server 64 bit OS. In the installation once I select the Oracle home directory and click on Next the whole pc just hangs. Nothing happens. When I checked the Application log I see an error with the following information.
the application (Oracle 9, from vendor Oracle) has the following problem. Oracle 9 is incompatible with this version or windows. For more information, contact Oracle.
View 13 Replies
View Related
Mar 21, 2011
In my test server ..When i'm going to check the oralce verion .which version this one ? im not seeing anything from oracle EE or standard edition & personal edition ...
SQL> select BANNER from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
View 2 Replies
View Related
Apr 18, 2013
My oracle version is 10g.I want to update a table which has 2 million rows and 20 columns. I want to update 3 columns in my table based on a query output.
Say:-
select decode(col1,'a',col2,col3) up_col1, decode(col5,'Y',20,30)* col6 up_col2, col7 up_col3 from base_tab a, update_tab b where a.key = b.key
I tried the simple update SQL, it hangs and never comeback even after 2 hrs.So I resort to PLSQL to complete my job using bulk collect with limits. Now I am stumbled upon with the Bulk update step.I referred to the BULK Update example given in [URL]...
I gone by 9i approach, I got invalid rowid error. Since the example doesn't uses a join.
I am little bit worried to go by 10g approach given in the example. I have to fetch entire row from my update table. My update table has 5 varchar(1000) fields. Anyway I am not going to affect them in my update. Whether it will occupy memory and again leads to hanging of my procedure.
View 2 Replies
View Related
Jun 11, 2013
In production server, already Oracle 10 and 11g sare installed. The new application designed to work on Entity Framework which nees ODP.Net 112030 Release 4 version.
As soon as ODP.Net Release got installed ont the server, the SQL Plus couldn't connect the Oracle databae. But the same setup is working all other lower environment
View 1 Replies
View Related
Nov 2, 2011
We have employee salary table which will have salary of an employee on daily basis (only working days). Below is the table structure:
CODEemp_salary
----------
emp_id NUMBER(15) NOT NULL
effective_date DATE NOT NULL
salary NUMBER(15) NOT NULL
Primary key - emp_id, effective_date..This table is yearly partitioned...I have to find out how long the salary is not changed for an employee from given date, and last salary. I am using below query to do this:
CODEWITH salary_tab AS
(SELECT effective_date, salary,
(CASE
WHEN (LAG (salary) OVER (PARTITION BY emp_id ORDER BY effective_date ASC) =
salary
[code]....
For emp_id 1, if we ran this query for 10/31/2011, then it has to compare the 10/31 salary with 10/29 and do the same until the salary mismatches. In this case, salary salary mismatch occurs on 10/20, so the stale salary period is from 10/31 to 10/21 which is 7 days.Below query will give that result:
CODE
WITH salary_tab AS
(SELECT effective_date, salary,
(CASE
WHEN (LAG (salary) OVER (PARTITION BY emp_id ORDER BY effective_date ASC) =
salary
[code]...
View 1 Replies
View Related
Nov 6, 2012
I've 2 identical tables of 300+ columns each,and each of table is having pk as combination of 2 fields.There are some fields where data is not matching. need a query which will use these two tables and return the following-
1. primary key columns
2. null value for fields where data is matching
3. data for columns where there is data mismatch.
View 4 Replies
View Related
