Downgrade Oracle Database 10g Release 10.2.0.2.0 To 10.2.0.1.0?
Nov 29, 2011
am trying to downgrade my oracle database 10g release 10.2.0.2.0 to 10.2.0.1.0the reason for this is that i had to copy /oracle_home/bin utilities from 10.2.0.1 to 10.2.0.2 because of this most utilities like rman,dbca were not working.
i think i need to downgrade my oracle database 10g release to 10.2.0.1.0 right?i read some oracle documentations of database downgrade instruciting me to
>take full backup of oracle DB
>ORACLE_HOME/bin/emctl stop dbconsole
SQL> STARTUP DOWNGRADE
DROP USER sysman CASCADE;
>SQL> SPOOL downgrade.log
[code]....
View 1 Replies
ADVERTISEMENT
Mar 13, 2013
Is Oracle Database 11g Release 2 (11.2.0.3.0) available for IBM AIX on POWER Systems (64-bit), Or do we need to upgrade 11.2.0.1 to 11.2.0.3.0.
View 4 Replies
View Related
Oct 16, 2012
how to mask data in oracle 11g database release 1
my environment is
Database: 11g release 1
os: AIX 6 (64 bit)
GC:10g release 1
View 12 Replies
View Related
Dec 27, 2012
how many users we can create in oracle 11g release 2 database. Is there any specific limit or parameter for that.
View 1 Replies
View Related
May 11, 2013
which is really a HA zone clustered in VCS(not important for installation of the database).
What parameters do I need to set or change in the Solaris zone, there seems to be no /etc/system file.
View 3 Replies
View Related
Apr 14, 2011
I am running oracle 11.2.0.2 on AIX 5.3 and when I issue the rman command below to a target DB running 10.2.0.4 I get this error.
$ rman catalog=rman/rman@prod target=sys/sys@prod
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Apr 14 17:38:24 2011
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Recovery Manager incompatible with TARGET database: RMAN 8.0.4.0 to 10.2.0.4 required
RMAN-00571: ========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06429: TARGET database is not compatible with this version of RMAN
What I was trying to do is duplicate my 10.2.0.4 DB and overwrite my 11.2.0.2 DB. Is there a way to downgrade my 11.2.0.2 DB. my 11Gr2 DB I have already set the compatibility parameter to *compatible='11.2.0.2' My 11gr2 is a test DB I don't have a valid backup..
View 2 Replies
View Related
May 30, 2013
We are using the following statement to obtain a row lock in a table in the database(ORACLE 10G), SELECT * FROM {TABLE_NAME} WHERE ID = 1 for update and if we succeed grabbing the row lock we will continue to issue a update statement every 30 seconds to preserve the lock as far as possible. here is the update statement to preserve the lock,
UPDATE {TABLE_NAME} SET time = ? WHERE ID = 1.
As you see more longer we keep holding the row lock , more update statements are submitted in the pending transaction. In normal case our application can grab the exclusive row lock and works for a long time,however sometimes a connection reset exception is thrown and our application will close the connection(I assume the pending transaction will be rolled back by the database) and exit the JVM. Since other applications will keep trying to grab the same row lock to become the master role, we expect one of them can succeed but they are all failed because the database has not released the row lock as expected. how and when the row lock can get released in our use case?
View 14 Replies
View Related
Jun 16, 2013
I know how to use database links in various forms, but I've been trying to think through how the authentication works for a connected user link in 11g. If I create the link like this,create public database link using 'orcl';then any user can use the link, provided they have an identical username/password in the two databases. With pre-11g passwords, it was understandable: the password was salted with the username, so the hash of the password would be the same in both databases, and I assumed that the logon through the link used some sort of IDENTIFIED BY VALUES mechanism. But in 11g, the salt will different in the two databases. So the hash will be different. And of course Oracle never stores the actual password. So I don't see how the authentication works.
View 4 Replies
View Related
Jul 24, 2013
I was prompted by an error in the middle of Oracle 11g Release 2 installation and unable to continue further.
The error was file not found e:product11.2.0.dbhome_3oc4jj2eeoc4j_applicationsapplications em.ear.
View 2 Replies
View Related
Dec 14, 2012
we need to find the key pressed action and key release action on Oracle form 10g. On key pressed (i.e. key-up, key-down, key-page-up and key- page-down) the event will be fired and as soon as the user release the key, the event will be stop.
As current situation, we have one form which contains the database blocks. As per search condition, all the data populated in Database block, there are 1000 and more records. Now user going use any of key (i.e. key-up, key-down, key-page-up and key-page-down) as he pressed key ( say Key- down) it scrolled down but as soon as he release the key, the event is not stopped. its going on going down then stop.
Is it possible, as user release the key scrolling will stopped at same time ?
View 3 Replies
View Related
May 28, 2009
I want to upgrade all the Oracle 10g Release (10.2.0)master sites (bi-directional) databases to Oracle 11g Release (latest). In fact, we are using bi-directional oracle streams and snapshot replication, it means capture,propagate and apply process is running.
View 1 Replies
View Related
May 9, 2012
why we seem to be unable to report against the ap invoice hold release date using Discoverer in Oracle 11.5.10? the person who wrote our current report used a decode statement to look at the last update date of the release lookup code to create a release date, but i am trying to recreate this in a different tool (Qlikview) and just wanted to understand why we seem to be unable to report on the field as is!
View 4 Replies
View Related
Jul 2, 2012
I am running a 10gR2 rac database on 11gR2 grid.
I like to switch from a rac to a standalone database including downgrading the license to standard edition one. Actually SE1 is not an install option for 10g.
Would it be enough to reconfigure the 2nd rac node ?
View 8 Replies
View Related
Nov 30, 2012
I have started to migrate 11.2.0.3 database from Enterprise to Standard edition with expdp/impdp (RHEL box). I've managed to transfer database without any problem (ok i had little difficulties with bitmap indexes but never mind).
But now i do not have all public synonyms in place as i already knew. So i have to create sql script and i have found several good ones. My question is do i need to recreate all public synonyms or there is a exceptions in my case because i now have Standard Edition database (old one was Enterprise)?
View 1 Replies
View Related
Feb 10, 2011
I am checking out licenses. We all know that EE is much more expensive than SE. But many customers do have EE installed - unsure if they need all the features at all. After several years of production, a downgrade is considered 'risky' and we continue to pay the full EE.
How can we check and be sure that a downgrade to SE would not be any problem?
Some checks include:
* partitioning used in user schemas? --> no downgrade to EE
* bitmap indexes in user schemas? --> no downgrade to EE
How can we complete this list, or is there some script to make this easy?
View 7 Replies
View Related
Dec 28, 2010
I want to downgrade my database from Oracle 11g (11.2.0.1.0) to Oracle 9i (9.2.0.1.0).
I've done trial of taking export of higher version(Oracle11g) through lower version(Oracle9i) exp utility and trying to import same exp.dmp files into lower version(Oracle9i), but not succeeded and getting some parameter related error.
On Oracle9i database client- Here i'm connecting to Oracle11g via use of 'wbdata.wbh-db1' service
[oracle1@WBDevelop smbshare]$ exp lab/lab@wbdata.wbh-db1
Export: Release 9.2.0.1.0 - Production on Tue Dec 28 15:45:32 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >
[code].....
On Oracle9i database client - Here i'm importing the lab.dmp
(Export taken from Oracle11g via use of 'wbdata.wbh-db1' service)
[oracle1@WBDevelop smbshare]$ imp lab/lab
Import: Release 9.2.0.1.0 - Production on Tue Dec 28 15:49:51 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
[code].....
View 13 Replies
View Related
Aug 21, 2013
We have Forms application created in Oracle Forms Builder version 9.0.4.0.19. We have done modification in some forms and few forms created using Oracle Forms Builder 10g version 10.1.2.0.2.
Now we need to convert those forms which are around 5 or 6 in number to Oracle Forms 9.
View 1 Replies
View Related
Aug 20, 2012
I wanted to downgrade our 2 node RAC 11.2.0.3 to previous version11.2.0.2 on our test environment, so i could prepare to upgrade production later.
I followed oracle documentation and issued
'/u01/app/11.2.0.3/grid/crs/install/rootcrs.pl -downgrade -oldcrshome /u01/app/11.2.0/grid -version 11.2.0.2.0'
and both nodes and manually removed file in upgraded oracle home (rm -r u01/app/11.2.0.3).
This seems to have caused havoc and ASM and srvctl are no working. lsinvemntory lsinventory still poitns to removed oracle 11.2.0.3
I tried to set
export ORACLE_HOME=$ORACLE_HOME
.oraenv
+ASM1
srvctl config ##n
srvctl config
PRCR-1119 : Failed to look up CRS resources of database type
PRCR-1115 : Failed to find entities of type resource that match filters (TYPE == ora.database.type) and contain attributes DB_UNIQUE_NAME,ORACLE_HOME,VERSION
Cannot communicate with crsd
View 11 Replies
View Related
Apr 12, 2010
How to Release Lock on table ? ( without killing session )
create table x ( a number);
insert into x(a) values (1);
Lets lock table.
declare
cursor c is select * from x for update;
begin
open c ;
end;
[code]....
View 15 Replies
View Related
Nov 18, 2011
I have a problem...
I created a tablespace called my_ts:
CODECREATE TABLESPACE my_ts DATAFILE 'C:\Oracle\oradata\db\my_ts.dbf' SIZE 5M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;
ALTER DATABASE DATAFILE 'C:\Oracle\oradata\db\my_ts.dbf' AUTOEXTEND ON;
Its was sucessfully created and my_ts.dbf file has 5MB
charging with data...
CODEcreate table big_table tablespace my_ts as select * from dba_objects;
select * from big_table;
begin
for i in 1..10 loop
insert into big_table select * from dba_objects;
end loop;
end;
Now the my_ts.dbf file has 90MB
Now I want drop this table:
CODEdrop table big_table purge;
And my tablespace file still has 90MB.
I already tried to restart the database but doesn't works...
how can I reduce the size to the original (5MB)?
View 3 Replies
View Related
May 27, 2012
assuption is that when we truncate the partition it immediatly release the allocatd storage.i have just tested the scenario , but still i can see that table size is same even after truncating the partition( which have around 25% of the data)
alter table test truncate partition t1p3 update indexes ;
OR
alter table test truncate partition t1p3 drop storage update indexes ; to see the table size:
SELECT owner, table_name, TRUNC(sum(bytes) / 1024 / 1024) Meg
FROM (SELECT segment_name table_name, owner, bytes
FROM dba_segments
WHERE segment_type = 'TABLE'
UNION ALL
[code]...
View 14 Replies
View Related
Nov 24, 2010
Share 11g Release 2 Grid infrastructure and RAC installation experience on Sun SPARC. Any documentation which provide complete information from server setup to database setup.
View 2 Replies
View Related
Sep 4, 2013
Ours is Oracle 11.2.0.2.0 Db 4 instances RAC on Unix AIX OS.Since long we are facing problem that CPU utilization reached 100% and reboot is required alteast once or twice a month.On seeing the Events Logs we find that the Event "CURSOR PIN S WAIT FOR X" is consuming a lot of waits.
On analyzing i came to know that we are firing same query from Application 15 to 20 lack times for which a lot of Mutex keeps spining for getting Shared Mode and consumes a large amount of CPU.
View 3 Replies
View Related
Feb 15, 2012
How to delete flashback log and to release the space?
I guess that it maybe like archive log ,it can release the space using RMAN.But when i try a test ,it fail.
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE FLASHBACK OFF;
View 6 Replies
View Related
Oct 23, 2012
I am new to this forum. I want to install XE 11g Release 2 in windows 7 64 bit. Can I intall 'Oracle Database Express Edition 11g Release 2 for Windows x32' or is there is 64bit version?
View 2 Replies
View Related
Aug 8, 2012
I'm trying to install 11g Release 2 on a CentOS (4.9) box, but the pre-req check shows that I'm missing the following packages (I had 9 to begin):
gcc-3.4.6 (X86_64)
gcc-c++-3.4.6(X86_64)
libstdc++-devel-3.4.6
Tried to use the yum command "yum install gcc" but get the following error.
Error: cannot find a valid baseurl for repo:update
I think this is due to the "CentOS-Base.repo" file, which I've tried to update by changing the mirror URL's but no success.Then tried to find the rpms online ([URL]...
INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
INFO: rm -f ntcontab.*
[code]....
View 2 Replies
View Related
Apr 22, 2011
I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.
I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?
1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site
View 2 Replies
View Related
Oct 11, 2012
i want to convert oracle database(schema data) to postgresql database
which tool would be best and url to download and steps to convert from one database to another ?
View 2 Replies
View Related
Feb 6, 2010
Can we use M.S Sql Server Database with Forms 6i with out oracle database install.
View 1 Replies
View Related
Sep 11, 2003
I'm trying to migrate a mySQL database into an Oracle database.
View 7 Replies
View Related
