SQL & PL/SQL :: ORA-01843 After Upgrading To ORACLE 11.2g
Sep 12, 2011
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).
View 9 Replies
ADVERTISEMENT
Apr 7, 2012
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?
View 1 Replies
View Related
Aug 27, 2013
I 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 Related
Dec 14, 2011
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?
View 1 Replies
View Related
Jul 25, 2011
I have a date field with varchar datatype. My data look like :
ID Amend_DATE
1 4/24/1974
1 4/18/2001
1 8/2/1971
2 8/4/1965
3 11/9/2001
4 8/15/2001
I need to find the minimum amend_date for each ID.When i calculate min(amend_date), it gives me error:
ORA-01843 : not a valid month
Query i am using is :
select min(to_date(amend_date ,'mm/dd/yyyy') ) from t group by id;
My data on application appears as 24 April 1974.
View 2 Replies
View Related
Sep 14, 2012
I have 2 cursors. Cursor 1 selects a number and 2 dates (values in the Table are in the format mm/dd/yyyy for both the columns).
I pass these values to Cursor 2.
v_promotion_id promotion.promotion_id%TYPE;
v_promotion_start_date promotion.start_date%TYPE;
v_promotion_end_date promotion.end_date%TYPE;
CURSOR c_promotion_list IS
(SELECT DISTINCT p.promotion_id,
p.start_date - 5,
p.end_date + 5
FROM promotion p,
[code]....
I am getting this error: ORA-01843: not a valid month
Initially I was passing just the variables without To_date. But I got the same error.
View 2 Replies
View Related
Aug 10, 2012
i am facing problem with date column.when i am trying to do execute a query this works fine
select null as link,'S'||to_char(DATE_OF_JOIN,'YY'),COUNT(STUDENT) "Blue Acres" from STUDENT_RECORD where PROCESSOR=1 and DATE_OF_JOIN >= to_date('0620' || to_char(sysdate, 'YYYY'), 'MMDDYYYY') and DATE_OF_JOIN < to_date('0920' || to_char(sysdate, 'YYYY'), 'MMDDYYYY') group by to_char(DATE_OF_JOIN,'YY')
and when i am trying the below query its showing the only this year dates its not referring the previous years
select null as link,'S'||to_char(DATE_OF_JOIN,'MMDDYY'),COUNT(STUDENT) "Blue Acres" from STUDENT_RECORD where PROCESSOR=1 and DATE_OF_JOIN >= to_date('1220' || to_char(sysdate, 'YYYY')-1, 'MMDDYYYY') and DATE_OF_JOIN < to_date('0320' || to_char(sysdate, 'YYYY'), 'MMDDYYYY') group by to_char(DATE_OF_JOIN,'MMDDYY')
when i am trying below query its showng the error ORA-01843: not a valid month
select null as link,'Fall'||to_char(to_char(DATE_OF_JOIN,'YY')-1),COUNT(STUDENT) "Blue Acres" from STUDENT_RECORD where PROCESSOR=1 and DATE_OF_JOIN >= to_date('0620' || to_char(sysdate, 'YYYY')-1, 'MMDDYYYY') and DATE_OF_JOIN < to_date('0920' || to_char(sysdate, 'YYYY')-1, 'MMDDYYYY') group by to_char(to_char(DATE_OF_JOIN,'YY')-1)
View 11 Replies
View Related
Oct 30, 2013
I am trying to insert some values into a table from a form i get the below error;
which says not a valid month;
FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01843
after i do google i added the below one to the insert statement and again i receive the error;
to_date(to_char(sysdate,'dd/mm/yyyy'),'dd/mm/yyyy')
My Insert Statement
insert into Invoice123
(Invoiceno, invdate, gross_tot, discount)
values
(nvl(INVOICEno(j),0),
to_date(to_char(invdate(j),'dd/mm/yyyy'),'dd/mm/yyyy'));
commit;
by which format we can achieve this!
View 6 Replies
View Related
Sep 16, 2010
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.
View 8 Replies
View Related
Jun 6, 2013
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.
View 4 Replies
View Related
Feb 15, 2011
I 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
View 11 Replies
View Related
Nov 30, 2010
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 Related
Apr 25, 2011
I 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.
View 3 Replies
View Related
Mar 23, 2011
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
View 5 Replies
View Related
Sep 6, 2013
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
View 8 Replies
View Related
Sep 23, 2011
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.
View 1 Replies
View Related
May 8, 2010
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 Replies
View Related
Feb 16, 2011
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 Related
Feb 16, 2010
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?
View 2 Replies
View Related
Jul 29, 2013
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?
View 2 Replies
View Related
Aug 27, 2012
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?
View 4 Replies
View Related
Dec 27, 2012
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 Related
Apr 22, 2013
I 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 Related
Mar 16, 2012
After 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?
View 4 Replies
View Related
Feb 20, 2013
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?
View 4 Replies
View Related
Oct 24, 2012
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...
View 20 Replies
View Related
Oct 17, 2012
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 Related
Apr 30, 2013
Upgrading 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?
View 8 Replies
View Related
Dec 11, 2012
How to configure Oracle EM with newly created Oracle Instance on Oracle 10g DB,which is Single Instance DB but not RAC ,when I start the Oracle EM it is starting the default DB which created during Oracle Server Installation.
View 0 Replies
View Related
May 17, 2011
But i do a lot of work-arounds to make sure the installation does not make corrupt my OracleAgent,OracleService and OracleDataGatherer. If i just let the installation do its thing i have problems with my libraries, and can't start anything.
The errors are : Procedure entry point 'BlaBla' could not be located in the Dynamic Link library 'AnyName'.
I notice that i have 2 versions of the libraries in OracleHomeBIN (one version 8, one version 11). The programs that start the OracleAgent,Service and DataGatherer call the old libraries but expect to find values that can be found only in new libraries.
View 1 Replies
View Related
