ORA-02097 / Parameter Cannot Be Modified Because Specified Value Is Invalid

Jun 21, 2012

pga_aggregate_target has been incorrectly set to 21gb in one of our databases.

SQL> sho parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 21686M

When I try to change it to 1g or 800m I get the following error.

SQL> alter system set pga_aggregate_target=1g scope=memory;
alter system set pga_aggregate_target=1g scope=memory
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00068: invalid value 104850 for parameter smmmax_size, must be between 0 and 0

Whereas when i try to set the scope to spfile it works

SQL> alter system set pga_aggregate_target=1g scope=spfile;
System altered.
Version is 11.2.0.3 on RHEL 5

how I can set the pga_aggregate_target right, I am not sure whether bouncing will work or not since i m doubtful that I may get the same error related to smmmax_size while bouncing with the new pga_aggregate_target.

View 4 Replies


ADVERTISEMENT

XE Edition Memory Parameter Invalid Or Not Specified

Jan 25, 2011

i was unable to log in to oracle database. i am doing the following steps :

- sqlplus /nolog
- connect /as sysdba
connect to an idle instance
- shutdown
ORA - 01034: oracle not available
ORA - 27101: shared memory realm does not exist

each command i give is showing the following error: ORA - 44412: XE edition memory parameter invalid or not specified.

View 4 Replies View Related

SQL & PL/SQL :: Ora-12705 - Invalid Or Unknown NLS Parameter Value Specified

Aug 12, 2003

while i log on to the oracel, i get the following error "Ora-12705 - Invalid or unknown NLS parameter value specified" AND i could not log on. how can i rectify this problem?

View 7 Replies View Related

SQL & PL/SQL :: ORA-12705 / Invalid Or Unknown NLS Parameter Value Specified

Sep 7, 2010

I am facing problem with my application while it tries to connect to the Oracle 9i DB using OCI, it fails with ORA-12705: invalid or unknown NLS parameter value specified.

On my client side, the oracle ennvironment variable for the NLS are

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=american_america.we8iso8859p9

same is on the RDBMS side.

SQL> show parameter NLS_LANG

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string AMERICAN

When i try to do a manual connect with sqlplus, it succeeds

$sqlplus /nolog
SQL> connect oltpgen/oltpgen@TSTPOOL
Connected.

I have tried 'unsetting' the NLS_LANG parameter on the client side but did not work.

View 7 Replies View Related

Replication :: ORA-00119 / Invalid Specification For System Parameter

Dec 28, 2007

I am getting errors while starting up my database using command 'STARTUP'

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL2'

have a look on sqlnet.ora , tnsnames.ora, listener.ora

sqlnet.ora
# sqlnet.ora Network Configuration File: c:oracleproduct10.2.0db_2
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to

[code]....

View 1 Replies View Related

Last Modified Timestamp Of A Table

Jul 8, 2013

Provide me a query to find the last modified timestamp of all the tables present in a schema? 

View 5 Replies View Related

How To Know Exact Time Of Row Modified And Deleted

Jul 16, 2010

1)How can i know that in a table when i modified a row or deleted a row and which row i inserted when i want to know the particular time

can it is possiable if possiable then tell me how.

2)Is there any difference between 9i merge and 10g merge command ?

View 4 Replies View Related

SQL & PL/SQL :: Get Last Updated Date When Data Modified?

Jun 20, 2011

I have multiple project databases where their tables are similar. I wanted to know just a single date from each project databases is modified/updated. If I run a query like select * from component order by eng_proj_id, chg_date desc then it will return many records sorted by their eng_proj_id and chg_date in their descending but I only need just a single record with last update from each project databases.

View 13 Replies View Related

SQL & PL/SQL :: Find Date When Attributes Modified?

Sep 14, 2012

The requirement is to find the last date when either ATTRIB1 or ATTRIB2 were modified for each ID. There are many other columns in the table, but I'm not interested in other columns.

Test Case

SET LINES 100
SET PAGES 100
DROP TABLE test_log
/
CREATE TABLE test_log

[code]....

Expected Output

ID LAST_CHANGE_DATE
---------- --------------------
11 02-SEP-2012 10:58:32
35 05-AUG-2012 10:58:32

I have written the below query, to get the required output.

SELECT MAX(i_date) last_change_date
FROM
(
SELECT seq,id, attrib1, attrib2, i_date,
row_number() OVER (PARTITION BY attrib1 ORDER BY i_date) rn1,
row_number() OVER (PARTITION BY attrib2 ORDER BY i_date) rn2

[code]....

View 6 Replies View Related

PL/SQL :: Logs Of Modified Database Objects

Jul 25, 2012

i have a sequence for one of my table that this sequence's current value was 3000 yesterday but today when i checked current value of it, i surprised because the value changed to 50, can i check who changed my sequence? is exists any data dictionary that shows logs of modified database objects.

View 3 Replies View Related

PL/SQL :: Check Date Of Last Modified Procedure?

Oct 17, 2012

how to check last modified function or procedure.

for example: INVO_75.PCK.PrintInvoices_fct

View 4 Replies View Related

PL/SQL :: How To Find Who Modified Package Code At Last

May 13, 2013

how to find who modified a package code at last? I can only find the latest modified date with USER_OBJECTS.

View 3 Replies View Related

Enterprise Search :: Last Modified In Web Source

Jul 13, 2012

I have created a web source with the default settings and pointed it at a test site. The pages being craweled have both last modified response headers and meta tag last-modified being set in the rendered html but the crawler doesn't seem to be indexing the values.

It is indexing and returning last modified on the liked files (i.e. *.doc, *.pdf) but not the actual web page itself.

Am I missing a step? How do I get the last modified meta tag of html to be indexed?

View 0 Replies View Related

Find Details Of User Who Modified Structure Of Table?

Aug 3, 2011

I have a small question is it possible to find the details of a user who modified the structure of a table, including what command he ran to change the structure of the table?

View 2 Replies View Related

Forms :: How To Downgrade (FMB) Created / Modified In10g To Version 9

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

Server Administration :: How To Know Which Table In Oracle Updated / Modified

Jul 29, 2010

I use oracle 9i. After doing execution ,process, how can I know which table in the oracle have been update/modify?

View 18 Replies View Related

SQL & PL/SQL :: ORA-30556 - Functional Index Is Defined On Column To Be Modified

Feb 2, 2012

I'm altering a column length to increase the size and getting "ORA-30556: functional index is defined on the column to be modified".

On searching more about this error, it seems like the function index must be dropped before altering the column.The table I'm dealing with is huge.

Question 1:In case of dropping and recreating the index, should the following steps be done:

- Drop Index
- Alter the column to increase the size
- Recreate the index with NOLOGGING and NOPARALLEL clause
- ALTER INDEX to turn on LOGGING
- Gather Statistics on that index

Question 2:Is there anything else that should be done when the index is dropped and re-created?

Question 3:What are the side-effects of carrying out the above steps in a huge table with around 15 million rows?

Question 4:Would it work if I disable the index, alter the column and reenable the index?Do I have to rebuild the index and gather Stats upon reenabling it?

View 2 Replies View Related

Forms :: FRM-40202 - Field Must Be Entered (after Standard Form Had Been Modified)

Apr 14, 2010

I got an error FRM-40202: Field must be entered. I did some modifications to Standard form by copying it. after that when I selected the first Email check box in the list and then selected the Email button which I created newly for that form.

View 1 Replies View Related

Server Administration :: Modified Objects - Compare Two Users On Different Databases

Oct 2, 2012

I want to compare two users on different databases, actaully there are two users one in user a on database a and another user b on database b they have same tables, and everytime when a table or object is created on user a (database a) i will take the table name ,procedure or any other object from user_objects based on ddl_created date and then i need to recreate the same on user b on database b, is there a way to find out tables which are not only created but also i need to check whether if there is any column added or any change in procedure or any other objects.Is there a way to generate the scripts based on list of objects selected from user_objects.
all i want is.

a)Find out the list of objects added along with creation scripts
b)find out the list of objects modified along with creation scripts.

View 2 Replies View Related

Server Administration :: Trace IP Address And OS Username / Service IP Who Modified Objects?

Sep 4, 2011

I have a problem some user modified the objects and now objects became invalid .How to trace the ip address and operating system username and service ip who modified the objects?

View 3 Replies View Related

Application Express :: ORA-01439 / Column To Be Modified Must Be Empty To Change Datatype

Sep 4, 2012

I need to modify the column type that already has data in it, i need it change varchar to number then The datas entered have $ and , (e.g $3,200). I need the $ and , removed with column type set to numbers.

When i currently do this i get the following error:

The TABLE operation was not successful for the following reason:

ORA-01439: column to be modified must be empty to change datatype

I've tried unloading the data and loading the data using the spreadsheet, cut and past and csv file but both give me more errors, so i just want that one column modified.

View 2 Replies View Related

SQL & PL/SQL :: Invalid Row-id?

Jul 9, 2013

I CREATE A COLUMN AS 'STATUS VARCHAR2(40)' IN EMP1 TABLE IN SCOTT USER

EMP1 TABLE IS A DUPLICATE TABLE OF EMP
CREATE OR REPLACE PACKAGE SAL_STATUS IS
PROCEDURE SAL_STATUS;
END SAL_STATUS;

[code]...

PACKAGE CREATED SUCCESSFULLY...

WHEN I EXECUTE THIS PACKAGE]
BEGIN
SAL_STATUS.LOAN_STATUS;
END;

IT THROW ERROR AS
BEGIN
*
ERROR at line 1:
ORA-01410: invalid ROWID
ORA-06512: at "SCOTT.SAL_STATUS", line 21
ORA-06512: at line 2

HOW CAN I OVERCOME THIS ERROR..

View 7 Replies View Related

SQL & PL/SQL :: All Invalid Records

Jun 12, 2013

I have the following sample data:

Sample Data

WITH DATA AS
(
SELECT '100' GRP, '01-JAN-2012' EFFECTIVE_DATE, '30-JUN-2012' TERMINATION_DATE from DUAL
UNION ALL
SELECT '100' GRP, '01-JUL-2012' EFFECTIVE_DATE, '31-JUL-2012' FROM DUAL
union all
[code]......

Query Result

10001-JAN-201230-JUN-2012
10001-JUL-201231-JUL-2012
10031-JUL-201205-AUG-2012
10001-AUG-201215-AUG-2012
10017-AUG-201231-AUG-2012

Expected Output

10031-JUL-201205-AUG-2012
10017-AUG-201231-AUG-2012

The above mentioned output is produced by using the following business rules:

-- row no 1 = Valid records
-- row no 2 = effective date is 1 day after termination date of row no 1. Means valid records
-- row no 3 = effective date is equal to the row no 2 termination date -- Means invalid record
-- row no 4 = effective date is 1 day after termination date of row no 2 Means valid records
-- row no 5 = The gap between row no 4 termination date and row no 5 effective date is more than 1 day. Means record is invalid.

Query always compare effective date with previous valid record termination date by using the above mentioned condition and return result accordingly.

Summary is that there should be 1 day gap between termination date and next effective date as well as effective date
is always less than termination date in same rows. In addition, if record is invalid then next record check with previous valid record termination date.

View 15 Replies View Related

SQL & PL/SQL :: Invalid Table Name

Mar 8, 2011

create or replace TRIGGER "tddev.stage_column" BEFORE
INSERT ON SRC_STG_INDEX_MAP_TABLE
FOR EACH ROW
DECLARE

[Code]....

The trigger fails saying invalid table_name for all_tab_columns.

View 9 Replies View Related

SQL & PL/SQL :: Invalid Identifier?

Oct 30, 2011

I am trying to do an update with an anonymous PL/SQL block because it has been absolutely impossible to get by the infamous "Single-row subquery returns multiple rows" Whatever.So this code below work... Obviously, I am updating it to a constant.. OK, duh.. Of course it works, it's easy.... Now, I really need to update it to a value in another table that is in my cursor. I believe that I probably need to declare a secondary cursor.

I'm just getting back in the DBA saddle, so I'm a little rusty..

set serveroutput on;
DECLARE
numrows NUMBER := 0;
total NUMBER := 0;
CURSOR upd_record_cur IS SELECT m.rowid, m.swcm_cycle, t.newcycle, p.aprem_no from toad.fswcmas m,

[code]...

Not so good here

ORA-06550: line 20, column 53:
PL/SQL: ORA-00904: "TOAD"."TTP43425_LOAD"."NEWCYCLE": invalid identifier
ORA-06550: line 20, column 10:
PL/SQL: SQL Statement ignored

Doesn't work...
BEGIN
FOR upd_rec IN upd_record_cur LOOP
update toad.fswcmas sw set sw.swcm_cycle = toad.ttp43425_load.newcycle
WHERE rowid = upd_rec.rowid;
total := total + 1;

View 17 Replies View Related

SQL & PL/SQL :: Cause Of Invalid Package?

Mar 8, 2012

There are 4 packages got invalid 2 days back. when I analyze the database I came to know that there are 5 tables got truncated and 2 tables got altered during the issue period through the code. Those truncated tables have the indirect relationship with these 4 packages.but there is no any relation between these packages and altered table.

Also during that time I got the below error in my alert log.I am sure the cause this error is the invalid packages.

ORA-00600: internal error code, arguments: [kkxprpic8], [], [], [], [], [], [], []

I know if any alteration happens in a table, the refrence package will be getting as invalid. Apart from this, is there anyother cause to bring the package into invalid status? How to proceed further to find the root cause of thses invalid package?

View 6 Replies View Related

SQL & PL/SQL :: Invalid Cursor?

Dec 2, 2010

procedure vieworderstatus(in_CALL_ID IN NUMBER ,
in_DAYS_OF_HISTORY in number ,
out_SUPLY_REORDR_STATUS_LST OUT supplyreordrlist ,
out_ERR_CODE OUT NUMBER,
out_ERR_MESSAGE out varchar2);

This procedure takes retrievs cust_id for given input call_id. The procedure then retrieves order information for that customer and returns using the out ref cursor. I need to test the scenario where the user passes invalid call_id.

The following query returns no data for call_id = 12345 ( invalid call_id)
select fk_cust_id into v_cust_id
from xcom_call
where call_id = in_CALL_ID;

in such cases; I just need to return null ref cursor and log the error but right now when I pass invalid call_id ; I am getting "invalid cursor" error.How do I handle this ?

View 35 Replies View Related

SQL & PL/SQL :: Invalid Number

Dec 3, 2012

select to_char(to_date(mcih_date, 'dd-mm-yyyy')),
mcih_terms from I_MEMO_CONF_H;
TO_CHAR(TO_DATE(MCIH_DATE,'DD-MCIH_TERMS
118-OCT-1245
206-NOV-1222

[Code]...

why i am getting this error?

View 3 Replies View Related

PL/SQL :: Get All Invalid Records

Jun 12, 2013

Oracle Version : Oracle Database 11g Express Edition Release 11.2.0.2.0 - ProductionI have following sample  data:

Sample DataWITH DATA AS( SELECT '100' GRP, '01-JAN-2012' EFFECTIVE_DATE, '30-JUN-2012' TERMINATION_DATE
from DUAL           
UNION ALL           
SELECT '100' GRP, '01-JUL-2012' EFFECTIVE_DATE, '31-JUL-2012'
FROM DUAL          
UNION ALL  SELECT '100' .

[Code]....

Business Rules: I have to get all invalid records according to the below business rules.

- row no 1 and 2 are valid records because row no 2 effective date start after the termination date of row no 1
- row no 3 is invalid record because effective date start with termination date of row no 2
- row no 4 is valid record because effective date is after or greater than previous valid record termination date that is row no 2 (31-jul-2012).
- row no 5 is invalid record effective date is smaller than previous termination date
- row no 6 is valid record because effective date is greater than previous valid termination date that is row no 4 .
- row no 7 is invalid record because same data already exist in row no 6
- row no 8 is valid  because effective date is  greater than previous valid record  that is row no 6 termination date. 

View 17 Replies View Related

Oracle Sys Object Invalid

Jun 21, 2013

Oracle sys object are Invalid,But database working fine. How to fix these problem, I don't have oracle support,

Database Dba_registry contain are All Valid.But sys object getting Invalid.

Oracle 10g 10.2.0.5 Standard

OWNERCOUNT(*)
MDSYS359
DMSYS24
PUBLIC147
CTXSYS3
OLAPSYS32
XDB 5
SYS 141

Dba_registry

COMP_IDSTATUS
APSOPTION OFF
SDOOPTION OFF
ODMOPTION OFF
AMDOPTION OFF
XOQOPTION OFF
OWMVALID
CATALOGVALID
CATPROCVALID
JAVAVMVALID
XMLVALID
CATJAVAVALID
RULVALID
EXFVALID
CONTEXTVALID
XDBVALID
EMVALID
ORDIMVALID

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved