Server Administration :: CPU Patch Not Working Properly?

Feb 10, 2009

I applied the Jan 09 CPU to my database this past Saturday and now my daily schema export is not running properly:

With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport done in WE8MSWIN1252 character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms

[code]...

View 8 Replies


ADVERTISEMENT

Server Administration :: Listener Not Functioning Properly?

Nov 22, 2006

while aim starting listener But Services in windows services showing listerner status as "started"

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.NTS.rethi.com)(P
ORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error

[code]....

View 7 Replies View Related

Server Administration :: One-off Patch?

Jan 24, 2012

I am reffering to one off patch "10402264" .I have to apply tihs patch to my 11.2.0.2.4 database.Is there any chart oracle provide to check if 10402264 is covered in any PSUs? or i have to go to each PSU readme and check "Bugs fixed" ?

i wish i could get somthing like this

11.2.0.2 One-off# PSU4 PSU5 11.2.0.3.0
10402264 NO YES YES

Or any other best practive

View 1 Replies View Related

Server Administration :: Oracle 10.2.0.5 Patch

Aug 19, 2010

We're thinking of moving from 10.2.0.3 to 10.2.0.5 in our production Oracle RAC. The 10.2.0.5 patch is quite new and I was wondering if any of you have upgraded to this patch in any of your environments and if you experienced any issues afterwards?

View 2 Replies View Related

Server Administration :: 11.2.0.2.3 GI Patch Set Update?

Sep 12, 2011

I installed oracle 11.2.0.2 RAC and want to apply the PSU patch. I would like to know whether its better to apply the April 2011 PSU or July release.

View 1 Replies View Related

Server Administration :: Applying Patch (10.2.0.1.0 To 10.2.0.4.0)

May 19, 2011

I installed Oracle 10.2.0.1.0 in RH Linux 4.5. After that applied patch for 10.2.0.4.0. Everything went smoothly, but at the last steps I unknowingly clicked next button. I dont know whether some scripts is to be run as I did during installation of 10.1.0.4.0. If it is to be done I didn't do that.

How can I proceed now? If some scripts to be run where is the location? Will it cause any issue if I running it after completing the update?

View 1 Replies View Related

SQL & PL/SQL :: Merge Is Not Working Properly?

Apr 23, 2013

I am using the following merge statement it's not working properly. If I tried to insert (or) update the existed record. I am getting unique key constraint violated error.

DECLARE
p_buid NUMBER;
p_ordernum NUMBER;

[Code].....

View 12 Replies View Related

SQL & PL/SQL :: Cursor Not Working Properly?

Nov 29, 2011

I'm trying to Create a procedure that generates:
Customer
Description of Order
Amount of Order
Total Of Order

As this Generates More than One Row I thought i would need to use cursor in order to store the results and then use them from the object So this is what i Coded:

CREATE OR REPLACE PROCEDURE UP_CustOrders
AS
/*I Am Selecting A Cursor Cause It Return More Than One Row*/
CURSOR ReportCursor IS
SELECT Company

[code]..

It appears It creates the procedure but im not sure why it has compilation errors Perhaps im missing some symbols? Here are the tables:

CREATE TABLE Customers
(CustNum NUMBER(10) NOT NULL,
Company VARCHAR2(20) NOT NULL,
CustRep NUMBER(10),

[code]...

View 12 Replies View Related

PL/SQL :: DML Triggers Not Working Properly?

Jul 18, 2013

There are two servers A and B ,and i am maintaining one table suppose table1 and another table suppose table2 , DML triggers are made for both of these tables.The action of DML trigger is that the movement we are inserting values , suppose a table1 on server A so automatically the same set of value in table2 on server Bso my problem is that the movement i inserted value on table1 on server A ,

the same set of values were inserted into table2 of server B and as the values were inserted intotable2 , the same set of values were inserted into the tabld1 because of the trigger.  How to stop the non ending loop which occurs due to the simultaneous firing of triggers and insertion of same records into both the table endlessly...

version :---Personal Oracle Database 10g Release 10.2.0.3.0 TNS for 32-bit Windows: Version 10.2.0.3.0

View 0 Replies View Related

SQL & PL/SQL :: WITH Clause Not Working Properly?

Nov 8, 2010

It seems some issue with With Clause along with Row Number. Output is strange when it comes with SELECT MIN()... But Looks fine Once you add "order by" or "where" clasue inside WITH Clause

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production

[code]....

But Output looks fine once you add ORDER By clause inside WITH clause

SQL> WITH EM AS
2 (
3 SELECT EMPNO, ROWNUM RN
4 FROM SCOTT.EMP T ORDER BY ROWNUM

[code]....

why it happens ?

View 4 Replies View Related

Server Administration :: Download Patch Documentation?

Oct 27, 2011

where i can download the patch documentation. Is it available in the metalink (my oracle support)? if yes then is there any other way i can get hold of it?

View 6 Replies View Related

Server Administration :: Apply Oracle Patch 10.2.0.5?

Nov 22, 2010

I want to upgrade 10.2.0.1 to 10.2.0.5.

Can I straightly apply 10.2.0.5 or need to sequentially apply one by one?

View 2 Replies View Related

Server Administration :: Apply 11.1.0.7 Patch Set On 10.2.0.3 Database?

Mar 25, 2010

can we apply 11.1.0.7 Patch Set on a 10.2.0.3 database server? i mean are patch sets cumulative or do i have to install the patch specific to my release the issue is i have the below error with rman: RMAN-03009: failure of delete command on ORA_DISK_1 channel at ORA-19633: control file record is out of sync with recovery catalog

View 7 Replies View Related

Server Administration :: Oracle 11g Patch Installation

Jan 31, 2011

I am using Oracle 11g (11.2.0.1.0) and I want to apply January patch on 11.2.0.1.0. I have applied 3 patches. I have single Instance with ASM and Grid.

Grid home: /opt/grid/11.2.0/grid
Oracle Home: /opt/oracle/product/11.2.0/db

1. O patch (6880880)
2. Grid patch (9655006)
3. Oracle Patch (10248516)

I have followed the following steps.

1. Applied Opatch on grid.
unzip p6880880_112000_LINUX.zip -d /opt/grid/11.2.0/grid

2. Validated the Oracle Inventory.
/opt/grid/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /opt/grid/11.2.0/grid

3. Shut down the databases.
4. Run the prepatch script
./9655006/custom/server/9655006/custom/scripts/prepatch.sh
5. Shutdown the ASM.
6. Ran the below command to stop CSS etc.
/opt/grid/11.2.0/grid/crs/install/roothas.pl -unlock

7. Applied grid patch.
/opt/grid/11.2.0/grid/OPatch/opatch napply -oh /opt/grid/11.2.0/grid -id 9655006

8. Applied Opatch on Oracle home
9. Applied Oracle patch
/opt/oracle/product/11.2.0/db/OPatch/opatch napply -oh /opt/oracle/product/11.2.0/db -id 10248516

8. Run the postpatch script
./9655006/custom/server/9655006/custom/scripts/postpatch.sh

9. Run the following script to enable CSS etc.
/opt/grid/11.2.0/grid/crs/install/roothas.pl -patch
/opt/grid/11.2.0/grid/bin/crsctl check has
/opt/grid/11.2.0/grid/bin/crsctl check css

10. If CSS is not online ran the below command.
/opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
/opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
/opt/grid/11.2.0/grid/bin/crsctl stop has
/opt/grid/11.2.0/grid/bin/crsctl start has

11. Up the ASM and Databases. Ran the postinstall in GRID and Oracle.
@catbundle.sql psu apply

12. Ran the below command on grid and Oracle.
/opt/grid/11.2.0/grid/OPatch/opatch lsinventory
/opt/oracle/product/11.2.0/db/OPatch/opatch lsinventory

1. Let me know steps which are followed are right because I didnot see the version change after connecting to database? (for example 11.2.0.1.0 after applying I can see 11.2.0.1.4 but not changed the version). How should I know the patch is applied properly?

2. Is the above steps are applicable to HA setup.

View 7 Replies View Related

Server Administration :: Oracle Patch Application

Feb 18, 2010

I am running a 10g oracle DB on AIX the application running is SAP.

Now I will be applying the following patch

8201796:OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#10)

But I find the following patches are already applied to the system which happens to be included in 8201796

6934892,7228971,7278117.

Do i need to remove the above patches individually before applying 8201796 or will it automatically do the needful during installation.

View 4 Replies View Related

How To Verify Serverside TAF Working Properly

Apr 22, 2009

#service setup:

$ srvctl add service -d dc1ext -s addval.dc1 -r "dc1ext1" -a "dc1ext2" -P BASIC
$ srvctl start service -d dc1ext -s addval.dc1

begin
DBMS_SERVICE.MODIFY_SERVICE(
service_name=>'addval.dc1',
aq_ha_notifications => true,
failover_method=>DBMS_SERVICE.FAILOVER_METHOD_BASIC,
[code]......

my attempt at verifying the TAF is working.

SQL> run
1 SELECT MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER, COUNT(*)
2 FROM GV$SESSION
3* GROUP BY MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER

MACHINE FAILOVER_TYPE FAILOVER_M FAI COUNT(*)
---------------------------------------------------------------- ------------- ---------- --- ----------
anetapp02.dc2 NONE NONE NO 10
anetapp01.dc2 NONE NONE NO 10
app02.st2 NONE NONE NO 5
racdb02 NONE NONE NO 44
anetapp03 NONE NONE NO 10
anetapp04 NONE NONE NO 10
GNOME\APTSEA-6GKJHF1 SELECT BASIC NO 3
app01.st2 NONE NONE NO 5
anetapp05 NONE NONE NO 10
anetapp01 NONE NONE NO 10
anetapp03 NONE NONE NO 10

so it looks as thought the sessions are failing over, but my app guy says he get a few errors during the process.. i need it setup to move the current query over without returning an error.. do i not have this setup properly?

View 3 Replies View Related

Server Administration :: Oracle 11g Patch Installation Steps

Jan 16, 2011

I have installed grid and oracle 11g on linux environment. I want to installation January patch related to grid and oracle 11g. This is the first time i m going to install the oracle 11g.

View 4 Replies View Related

Server Administration :: Use OPatch Utility For Patch Upgradation

Mar 14, 2012

How to set Path environment variable if we want to use OPatch utility for patch upgradation.

View 2 Replies View Related

Server Administration :: Getting Error While Applying PSU Patch On Windows

Apr 7, 2011

We are applying PSU JAN 2011 patch 10349197 on windows server 2007. While applying the patch we are getting the below error.

Following files are active :

E:oracleproduct10.2.0inoraclient10.dll
E:oracleproduct10.2.0inorapls10.dll
E:oracleproduct10.2.0inoracommon10.dll
E:oracleproduct10.2.0inorageneric10.dll
E:oracleproduct10.2.0inoraplp10.dll
[code]........
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:

1) OUI-67620:Interim patch 10349197 is a superset of the patch(es) [ 8559466 ]
in the Oracle Home
--------------------------------------------------------------------------------
Its not an rac. We stopped all the services running on this server.

OPatch failed with error code = 74

View 4 Replies View Related

Log Of Materialized View - Trigger Not Working Properly

Oct 25, 2012

I have created a Table and a log of materialized view in an Schema SchemaAA of Server A

CREATE TABLE TABLA_TEST
(
TEST_PK NUMBER,
TEST_TEXTO VARCHAR2(50),
CONSTRAINT PK_TEST PRIMARY KEY (TEST_PK)
);

CREATE MATERIALIZED VIEW LOG ON TABLA_TEST;

I have created a DB Link from server B with user REPLIC

I have granted SELECT to REPLIC to the table and the log materialized View.

I have created a table in instanceBA of Server B

CREATE TABLA_TEST
(
HOSPCODE NUMBER(3),
TEST_PK NUMBER,
TEST_TEXTO VARCHAR2(50),
FECHA_INSERT DATE,
FECHA_UPDATE DATE,
FECHA_DELETE DATE,
CONSTRAINT TTEST_PK PRIMARY KEY (HOSPCODE, TEST_PK);

I have created a materialized view in schema SchemaBB of Server B with a trigger

CREATE MATERIALIZED VIEW WORKAREA.TABLA_TEST70
BUILD IMMEDIATE
REFRESH FAST ON DEMAND
WITH PRIMARY KEY
AS
SELECT TEST_PK,
TEST_TEXTO
[code].........

All schemas have the appropriate grants.

When inserting in TABLA_TEST (SchemaAA) and refreshing MView TABLA_TEST70 things go nicely.

But, when updating a record in the original TABLA_TEST and refreshing the MView the results in TABLA_TEST in SchemaBA are as if I have deleted the record (FECHA_DELETE is set to SYSDATE).

View 1 Replies View Related

Forms :: Tree Hierarchy - Not Working Properly?

Apr 8, 2009

i have created a tree hierarchy....when the user clicks on any node,that particular form will open....But there is some problem...i click on form A,it opens.,...then i exit that form via a exit button on the toolbar....and then I click on form B on the tree....but first the form A only opens...and then again i exit form A, then form B will open..

i have written the following code in when_tree_node_selected trigger :

if condition then
call_form(path,no_hide,do_replace);

View 3 Replies View Related

Performance Tuning :: Hint Is Not Working Properly

Jul 14, 2010

I have a query with FULL hint that is behaving in a strange manner. The query fetches around 700000 of data. Sometimes it fetches the data with the hint and sometimes it does not fetch any data with the hint and then I have to remove the hint and have to fetch the data. Below is the query,

select /*+ FULL(COMP_TM) FULL(TRANS_TM) FULL(INVC_TM) */
CUST_BE_ID ,
DISTR_BE_ID ,
FG_BE_ID ,
KIT_BE_ID ,
BG_ID_NO_BE_ID ,
[code]....

The statistics gathering activity of FACT_DLY_ALGND_SLS table takes around 5 hours to complete. It is a range partitioned table with subpartitions.

View 14 Replies View Related

PL/SQL :: Up And Down Arrow Keys Not Working Properly When Using SQL CLI On Linux?

Feb 27, 2013

Every time I hit up, down, left, and right arrow keys to return to a previous sql command I got ^[[D, fix this issue? The backspace works fine with me.

View 2 Replies View Related

Forms :: (Drag And Drop) Not Working Properly?

Jun 6, 2013

I created one Form manually. how to Drag and drop from items in Data Blocks to Canvas. when I created text in Canvas it was automatically creating the item in Data block. but when i create the items in Data blocks and then trying to copy to canvas.

View 1 Replies View Related

Server Administration :: Information Regarding Latest Patch Installed For ORACLE_HOME

Feb 23, 2010

How do i find out the information regarding the latest patch installed for ORACLE_HOME..

OR

If given a patch number, how do i find out whether it's applied to ORACLE_HOME

View 1 Replies View Related

SQL & PL/SQL :: Multiple Row Insert Not Working - Command Not Properly Ended

Mar 7, 2013

The multiple row insert is not working

CREATE TABLE example (
example_id INT NOT NULL,
name VARCHAR( 50 ) NOT NULL,
value VARCHAR( 50 ) NOT NULL,
OTHER_VALUE VARCHAR( 50 ) NOT NULL
);

For the below query its showing error .

INSERT INTO example
VALUES
(100, 'Name 1', 'Value 1', 'Other 1'),
(101, 'Name 2', 'Value 2', 'Other 2'),
(102, 'Name 3', 'Value 3', 'Other 3'),
(103, 'Name 4', 'Value 4', 'Other 4');

the error message is.

Error starting at line 1 in command:
INSERT INTO example
VALUES
(100, 'Name 1', 'Value 1', 'Other 1'),
(101, 'Name 2', 'Value 2', 'Other 2'),
(102, 'Name 3', 'Value 3', 'Other 3'),
(103, 'Name 4', 'Value 4', 'Other 4')
Error at Command Line:3 Column:39
Error report:
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:

View 8 Replies View Related

Forms :: Loop Is Not Working Properly - Cannot Save All Records

Oct 11, 2010

here i m giving the code

DECLARE
TYPE SUBNO_TABLE_TYPE IS TABLE OF
TRANS_DEICMAIN1.SUBNO%TYPE
INDEX BY BINARY_INTEGER;
SUBNO_TABLE SUBNO_TABLE_TYPE;
K NUMBER := 1;
S NUMBER := 1;
[code]...

HERE CHECK1 IS A CHECKBOX.WHEN I AM USING THIS CODE ONLY ONE RECORD IS SAVED AT A TIME INSTEAD OF SAVING ALL RECORDS.

View 2 Replies View Related

SQL & PL/SQL :: Write Trigger On A New Table - Body Not Working Properly?

Jun 29, 2010

I am trying to write a trigger on a new table. (dest_test) This is the first trigger that I have ever attempted (fairly new DBA) and I am having some trouble with the trigger body.It is a before insert trigger that will need to select from another table (dest) for a particular value being inserted (destination).

create table dest_test (
destination varchar2(4) not null,
db_name varchar2(10) not null
)

desc dest

[code]...

I am getting the exact opposite results than I want, though. If the value appears in dest, it is inserting into dest_test... NOT whatI want it to do!If the value doesn't appear in dest, it is throwing ora-6512 and ora-4088 errors. Is there a way to suppress these errors, or to graceful exit from the block so that the trigger completes without throwing these errors?

View 3 Replies View Related

Forms :: Menu Tree Not Working Properly - Change It?

Feb 12, 2010

I have a form in which menu tree is populated with this sql

SELECT 1, Level, MenuLabel, MenuName, MenuId
FROM MenuFile
CONNECT BY PRIOR MenuId = ParentId START WITH menuId = :moduleid||'0000'

The result is attached in the CSV file enclosed in sheet mrnufile1As we can see in row 3 the item LPC has menuid BDME13.
In my view This item should be in ROW 19.How can i change query do get the desired the result.I have also tried another sql query.

select * from menufile where applicationid = 'BD' order by parentid,menuid

Result of this query is in 2nd Half of CSV file

View 2 Replies View Related

Application Express :: Interactive Report Search Not Working Properly?

Jun 12, 2013

I am using Apex 4.2, The Interactive report Search is not working properly, when i am entering complete date or time it is not showing any results...how to increase performance of the search...

View 5 Replies View Related







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