where I can download the software for upgrading to 10g 10.2.0.2.0 or higher, but not 11g. I am not going to install 11g. Currently, I have 10g 10.2.0.1.0 and I have Windows XP. I don't consider to install 11g.
View 3 RepliesI am upgrading oracle database from 9.2.0.7 to 11.1.0 (clients need 11.1. andnot 11.2).
Metalink tells me that I can do a direct upgrade and don't have to go to 9.2.0.8. so that's good news. Since time is of essence here : )
I ran the utlu111i.sql.
And made the following changes, per its recommendation.
Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
--> "log_archive_start"
--> "max_enabled_roles"
--> "parallel_automatic_tuning"
--> "background_dump_dest" replaced by "diagnostic_dest"
--> "user_dump_dest" replaced by "diagnostic_dest"
--> "core_dump_dest" replaced by "diagnostic_dest"
ISSUE 1:I already have a sysaux tablespace in my db, but the log still says, SYSAUX Tablespace:
[Create tablespace in the Oracle Database 11.1 environment]
**********************************************************************
--> New "SYSAUX" tablespace
.... minimum required size for database upgrade: 500 MB
ISSUE 2:I copied the 9i orapw file to the 11g $ORACLE_HOME/dbs location but when I try to login, using the same login (after I source the new profile) it still asks me for username/password. Doesn't allow remote sysdba login ? DO I NEED TO DO SOMETHING SPECIAL WITH THE PASSWORD FILE ?
ISSUE 3:Here are the steps I took before I get the next error:
I copied the init file from 9i location to the 11g location made the above changes in the init file.
I set the compatible to 10.1.0.
Added diagnostic_dest and got rid of bdump, udump and cdump
Then I shutdown the db (9i) I sourced the 9i profile (IS THIS TRUE OR SHOULD I SOURCE THE 11G PROFILE ?), and tried to start the db using startup upgrade (my changes have been made to the 9i init file and that is the one I am using to start the db with in the upgrade mode, is that ok ? ) I GET THE FOLLOWING ERROR SP2-0714: invalid combination of STARTUP options
Need to clarify upgrade procedures from Oracle 9i R1 (9.0.1.0.0) to Oracle 9i R2 (9.2.0.3.0). Do we need to first upgrade to 9.2.0.1.0 (as base) before proceeding to patch it by version 9.2.0.3? Or could we patch it directly from 9.0.1.0 to 9.2.0.3?
View 3 Replies View RelatedI am upgrading my server from 10.2.0.1 to 10.2.0.4. in DST check the timezone values returned is 2 and not 4. I have checked using utltzpv4.sql and the jobs returned are as below.
Owner table_name Column_Name.
SYS SCHEDULER$_JOB LAST_ENABLED_TIME
SYS SCHEDULER$_JOB START_DATE
SYS SCHEDULER$_WINDOW LAST_START_DATE
I dont have any userdata using TSTZ or TSLTZ.
If have several databases running on a 10.2.0.4 Oracle Home. I want to upgrade one of them to 10.2.0.5. My thinking is that I install 10.2 to another location e.g. /u01/app/oracle/product/10.2.0.5 and patch this OH to 10.2.0.5. Regarding the steps to upgrade a particular database. Oracle documentation as I'm unable to locate?
View 11 Replies View RelatedI need to upgrade an oracle 8i database on HP-Unix server to Oracle 11g on Linux server, whether to upgrade it first to 10g linux and then to 11g ?
View 4 Replies View RelatedWe can Import dump from higher database version to lower database version.
View 26 Replies View RelatedI have set my processes and session value in my database as 1000 and 1248 respectively. I am using 11.2.0.1 but when I restart my DB it showing me sessions=1524...its too high value then what I set.I don't know why it showing higher value than the value I set...
ALTER SYSTEM SET processes=1000 SCOPE=SPFILE;
ALTER SYSTEM SET sessions=1248 SCOPE=SPFILE;
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u02/app/oracle/product/11.2.0/db_1/dbs/spfileeng11g02.ora
System parameters with non-default values:
processes = 1000
sessions = 1524
And one more thing is there any recommended formula for calculate sessions in 11g? [ I found one formual from google:
SESSIONS derived: (1.1 * PROCESSES) + 5
We have downloaded the 11.1.0.7.0 version from the below link
[URL]
The downloaded dump name is win64_11gR1_database_111070.zip.This dump is intended for Windows 2008.
we have installed this dump on Windows 2003 and upgraded from 10.2.0.4 to 11.1.0.7 .
In the process we have not encountered any issues. Whether the steps we followed would suffice for an upgrade from 10.2.0.4 to 11.1.0.7 or Should i go for 11.1.0.6 base version installation and apply 11.1.0.7 patch set.
We have several applications hosted on a server using ODP.NET 10, but we are the first to decide to upgrade to ODP.NET 11 which means we need a method where only our application uses ODP.NET 11 without affecting any other existing applications.
I've read about the policy files which automatically redirects application to use latest version installed on the machine. Is there a method available which can avoid this situation as the owners of other application may not allow this to happen.
How can I ensure that my application is using ODP.NET 11 or ODP.NET 10 if both are installed? I created two sample app one with Oracle.DataAccess.dll 10.2.0.100 and other one with Oracle.DataAccess.dll 2.112.3.0. With below line of code, I found both applications are showing Oracle.DataAccess 2.112.3.0 at runtime.
System.Data.Common.DbProviderFactories.GetFactoryClasses();
Last thing, I may be wrong saying latest ODP.NET wouldn't work with NHibernate 1.0.3.0. please validate.
So I have an extremely weird error that I just found after several month of being upgraded to 10g from 6i. Right now I have several data blocks where users input data. The field that they input into is fairly long, so we give them the option to double-click which opens up the editor.
Now, if they do this when entering the field for the first time, everything works great. However, if they save, then decide to go back into the data block and edit the field, they can edit it in the text just fine. However, if they double-click and bring up the text editor, after they click ok (or cancel) it jumps back to the first data block.
What is more weird is I can't get it to happen on my own machine, only when it is running on the unix server. On top of that, I was able to avoid the issue by simply showing a message saying "field is about to be edited" and making them click ok. Of course, it's a work-around
I just upgraded my oracle DB version from 9 to 11.2g with the assistance of a DBA. The upgrade went fine, and all the data transfered as it should.
The only problem that I got is that almost every query that I try to run via my PL/SQL developer throws the ORA-01843 error. I checked the NLS-lang property from the previus DB and it is the same as the new one. The DBA says that the problem is in the PLSQL properties (althogh I didn't change them).
When upgrading database from 10.2.0.1.0 to 10.2.0.4.0 , i am getting following error$
/run Installer Starting Oracle Universal Installer...Checking installer requirements...Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3 Passed All installer requirements met. Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-07_01-25-05AM. Please wait ... error: invalid compressed data to inflate /tmp/OraInstall2013-09-07_01 -25-05AM/oui/jlib/ewt3.jarerror: invalid compressed data to inflate /tmp/OraInstall2013-09-07_01-25-05AM/oui/gui de/htmlguide.jar
I have a virtual Linux RHEL 3 server with Oracle 9.2.0.8 DB running on VMWare. Now I need to update Linux to RHEL 5 and oracle to 11R2.upgrading RHEL 3 to RHEL 5 is not possible, so I need to install a new RHEL 5 server.
My plan is to install a new virtual server with RHEL 5and Oracle 11R2 in it. And then migrate DB there.What would be the easiest/fastest/safest way to do this? I would prefer using the DBUA method because of simplicity and my knowledge of Oracle :-)
I already tested this certainly unsupported scenario and it seemed to work:
I was unable to install Oracle 9 to RHEL 5 (not supported on RHEL5). So I just shutdown the DB on old environment and just copied everything related to Oracle from old RHEL 3 server to same locations on new RHEL 5 server. The DB started up just fine on RHEL 5 server.
So now as I had Oracle 9 DB running in RHEL 5 and also Oracle 11R2 binaries installed, I just followed DBUA instructions to do the upgrade and it seemed to succeed.
We currently are running Forms and Reports 6i.
We intend upgrading Java to jre 1.6.0_14. Would this have any impact on our environment? Can we safely go ahead with the upgrade?
Servers: Linux 5 & Windows 3 (seperate servers)
Database: Oracle 10.2.0.5.
Upgrade to: Oracle 11.2.0.3
Upgrade type: Inplace upgrade (DBUA) on same servers ...
I am about to start our Oracle Production database from Oracle 10g to 11g and get a quick question: Will all database service accounts or usernames, or schema AND their passwords moved to the new environment?I am mostly concern about the password. I don't want to change them in the new environment. We have hundreds of jobs from all over the world using these usernames and password and do't want to change them.
Example: Will username app_users and its password (PassWord@rAll)be usable in the new 11g environment?
I receive this error. In my opinion the problem could be related to the presence of one personalized authentication schemas, based on a DB function, taken from a Packaged application, some years ago, called "menu_framework".
This is the error report:
........
-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
begin
*
ERRORE alla riga 1:
ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj],
[0x26962168], [0x1A1042F4], [], [], [], [], [], [], [], [], []
1) after the error trap, I copied the Image folder and tried to launch APEX. It was possible to lunch the development pages, but impossible to execute any application with the error: Authentication Schema not Supported
2) then decided to downgrade to APEX 4.0, following the proper instructions: received a similar error:
.......
SQL> exec apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000
');
BEGIN apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000');
END;
ERRORE alla riga 1:
ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj],
[0x16D5D9E4], [0x27F2074C], [], [], [], [], [], [], [], [], []
The execution of application reported the same problem.Then decided to restore the entirre DB.
Where is my problem?Are my suspects real or the Authentication schema malfunctiong is a conseguence of the upgrade error?
I got the following error when upgrading from Oracle 9.2.0.8 to Oracle 11.2.0.2 version using catupgrd.sql script.
=================================================================
CREATE OR REPLACE PACKAGE BODY kupm$mcp wrapped
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ERROR:
ORA-03114: not connected to ORACLE
SP2-1519: Unable to write to the error log table sys.registry$error
ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8168 bytes
(callheap,kcbtmal allocation)
Process ID: 81984
Session ID: 1 Serial number: 5
==========================================================
My machine environment is:
UNIX AIX 5.3 level 12
Oracle 11.2.0.2
RAM size 2GB
ulimit settings:
> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) unlimited
coredump(blocks) 2
nofiles(descriptors) unlimited
Currently i tried to increase SGA & PGA to possible extent, but still getting this error? Is there any change required in ulimit, RAM etc?
We have a 2 node rac cluster running on HPUX Itanium platform running oracle rdbms 10.2.0.4 that is currently configured using raw devices for ocr, voting disk, and all of the datafiles. We have a business requirement that is mandating that we have to use TDE tablespace encryption and in order to do so we must now upgrade to 11g.We are in the planning stages for the upgrade process and I am just trying to understand or find out what is going to be the best method to move the data that is currently in the tablespaces on the raw devices over to new tablespaces that will be created within ASM and will be created as TDE encrypted tablespaces?Our database is about 1.8 TB and we have alot of fairly large critical transactional tables that support a 24 x 7 oltp environment that cannot afford downtime.
View 2 Replies View RelatedI have installed oracle 11g R2 in windows and i ve created database of vesrion 11.2.0.1.0. I tried to upgrade the database to higher version using the dbua utility . But in this utility source & destination both is showing as 11.2.0.1.0. upgrade the database from 11.2.0.1.0 to higher version using the dbua utility
View 16 Replies View RelatedAfter our client upgraded to 11g database and application server, they are getting this error while trying to access another form from the option menu (The option menu is generated with a library, the values are taken from a database table). This issue occurs only in one particular scenerio, and only in on form, other forms with similar functionality and same structure are working perfectly fine. The error is written below.
FRM-21011: PL/SQL unhandled exception ORA-06508
I tried in my environment (10G), no error exist there.In 11G environment, I tried re-attaching a library in the form and compiling again, the error does not come after recompiliation. But the client can still see the error even after recompiling the form (after reattaching that particular library).I could find the below info on google:
FRM-21011: PL/SQL unhandled exception %s.
Cause: An unhandled exception occurred while executing a menu trigger.
Action: Examine the text of the exception in this message. If this indicates a cause,
correct it. If the problem persists, contact Oracle Support Services.
Level: 25
Trigger: None
I am using form builder 10G, will compiling the form using Form builder 11G?
We are considering upgrading our current system from Oracle 9i to 11g. The current operating system is SUSE Enterprise 9.
The 11g requirements say an update to SUSE Enterprise 10 is required to support the Oracle 11g installation.
Will I need to recompile my existing application programs which use pro C precompiler to create code that accesses the Oracle database when I upgrade the operating system and database?
I just upgraded my APEX 4.0 application to 4.2, and ran the utility to upgrade my charts to HTML5. After completing the upgrade, I noticed my charts no longer displayed in the region.
I am currently using IE9 to view the application, since that's the browser over 90% of my users have. Is there something more I need to install?
I installed APEX 4.2 over XE 11.2
The Installation process succeeded.I Used the Installation Guide -> and followed the steps from chapter 3...My problem after the Apex-Upgrade ->
The page URL.... is blank, or say it better, ... there is nothing visible on that page (no Login-Form)The original GetStarted page from XE Database -> URL.... shows an Error Error Error processing request.ORA-01403: no data found
I can post the sourcecode from the "blank" HTML-Page...
I am doing a upgrade from 10g2 standalone (with out ASM) to 11g2 2 node cluster (on ASM) and the database is some what 1TB of the size. My problem is if I do a export and import the live system need to be down for over an a day. is there a better way of doing this and how ?
View 6 Replies View RelatedUpgrading one of the 9i database to 11g that supports a 3rd party software - ***Vendor provided an over-simplified documentations*** and recommends moving from 9i to 10g before going to 11g. A few changes from 9i to 10g.
1) db_block_size
2) character sets
etc.
Anyway, created the database DBUPGTEST on 10.2.0.1 (ultimately moving to 11gR2, so no point patching to 10.2.0.5, is there?) with all the parameter changes. At this point, these are the 2 db in play:
Current production db: Oracle 9i - PROD dbname => 2048K db block size
Current migrating db to: Oracle10g - DBUPGTEST dbname => 8192k db block size
Steps
According to vendor notes / documentation,
1) create db
2) exp full from 9i
3) imp full to 10g
Problems
1) import ended with completed unsuccessful.
2) user accounts are imported (because their default tablespace is USERS - which had already been created during DB creation); but, user accounts (schema accounts) with a different default tablespace are not imported.
Looking at the imp.log - seems like it's complaining about the db_block_size during tablespace creation - which explains why the schema accounts are not imported; because the tablespace was not created.
My questions
1) How do I import to 10g? Can I create all the tablespace in 10g first? Then import? Will it crap out because it already exists? Or will it import the objects in the schema?
2) How do I refresh data from PROD? Remember this is 9i and most of the expdp functionalities are not available. And I cannot re-exp and re-imp because there are steps (sql to run) after moving to 10g to fix some software upgrade table mappings. If I re-exp from 9i and re-imp to 10g, won't I have to re-run all those steps before the apps will run?
i'm a student currently learning database administration security.
I need to create a tablespace for administration of database but i don't know what datafile settings are best suited for admin usage.
I have attached the schema that was given to me for this assignment.
My manager is asking to create a SQL scrip, which will provide following information.
Our database is 9.2.0.7.0 on Windows 2000 Server
-How many records Insert / Update or Delete daily in my Oracle database?
- Check Archive log / Redo Log switching information?
-Check database growth ?
i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."
I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).
All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.