How To Disable FlashcacheMode - Writeback

Nov 1, 2012

I'm trying to disable the new write flash cache feature that came with the latest Exadata patch on our Quarter RAC X2-2
The procedure i'm trying to follow is as described below:

1. CellCLI> alter cell flashcache all flush
2. CellCLI> drop flashcache
3. CellCLI> alter cell shutdown services cellsrv
4. CellCLI> alter cell flashCacheMode=Writethrough
5. CellCLI> alter cell startup services cellsrv

My problem is that when i'm running 1. i receive a syntax error.The only doc i could find describing how to go back from WriteBack mode is[URL]...

View 1 Replies


ADVERTISEMENT

Dba_Jobs Disable Script

Aug 2, 2010

I am trying to get a working script that could just go and mark all dba_jobs to BROKEN ==> TRUE
"execute dbms_job.broken(jobno,true)" using a pl/sql script

I have the working structure of the script except for the fact that the goal is not achieved. I came to know that the ALTER SESSION SET CURRENT_SCHEMA does not take effect when used with the DBMS_JOB API.

Is there an alternative I can get this working.

CODE<--------- part of the script : START

FOR l_job_users IN job_users LOOP
execute immediate 'alter session set current_schema='||l_job_users.LOG_USER;
DBMS_OUTPUT.PUT_LINE(current_user);
FOR l_jobs IN jobs(l_job_users.LOG_USER) LOOP
[code].....    

View 4 Replies View Related

Enable / Disable Auditing From PHP

Dec 15, 2010

In PL/SQL Plus, i can enable/disable auditing when i connect as sysdba by using these command:

SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE
SQL> shutdown
SQL> startup

I've done it successfully with PL/SQL Plus command line. But in PHP, how can i do that?How to execute "shutdown" and "startup" from PHP?
I've found this code for connect to oracle as sysdba:

oci_connect("/", "", null, null, OCI_SYSDBA);

From the following link:

[URL]......

But, i still can't execute "shutdown", "startup";

View 4 Replies View Related

Forms :: How To Disable Function Key F4 In 6i

Feb 22, 2012

How to Disable Function key F4 in forms 6i for example in forms i want that no body copy full row with F4 Key pls guide me where to apply key F4 trigger in forms.

View 1 Replies View Related

Security :: How To Disable Sql Login

May 28, 2012

How to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".

Is it possible? If no, then what can be done to achieve below.

I have a userid which has all the update, delete privileges on it. That id needs to be configured in the application alongwith the password. So in order to avoid misuse of that id I want to block its sql access.

I am not sure whether this can be achieved or not.

View 2 Replies View Related

SQL & PL/SQL :: Disable Oracle 11 Audit (AUD)

May 31, 2012

is it possible to disable audit logging (audit_file)? (Ora 11)

View 27 Replies View Related

Forms :: Radio Box Disable

Dec 1, 2010

I have a Radio Box Item field in Form, It contain Three Radio Buttons.

During the User Login Some of the users Not Require to Touch Any of the Three Radio. Thus i Require to Disable that Radio Button to That User. How to Disable the Particular Radio Button.

View 4 Replies View Related

Forms :: How To Disable Shift+ Tab

Jul 22, 2010

I wanna disable shift+tab key function not to be able to go to previous item. What should I do?

View 1 Replies View Related

Forms :: Disable The Commutation Tab?

May 11, 2011

the software i use in oracle 10g is for calculating the pensionary benefits. Those who retire voluntary or on superannuation gets pension, commutation and gratuity.

for those death cases only family pension and gratuity is eligible.

my problem is when i give the pension case as family pension the commutation tab also gets visible and it allows the users to enter values for commutation even though they are not eligible.

i would like to know if i can disable the commutation tab once i enter the pension case as family pension.

View 1 Replies View Related

SQL & PL/SQL :: How To Disable Procedure On Oracle

Oct 18, 2010

how to disable procedure on oracle

View 3 Replies View Related

Drop Or Disable A Scheduled Job

Oct 11, 2012

I have a job running under HUMADM user and would like disable or drop it.I do not have the login credentials of HUMADM user but can log into the database as system/sys user.

When I run the below commands as sys/system user it says humadmjob must be a job or it is not running.This is because it is looking for the job under sys/system user.

exec DBMS_SCHEDULER.drop_job (job_name => 'humadmjob');
exec DBMS_SCHEDULER.stop_job (job_name => 'humadmjob');

SELECT owner, job_name, job_class, enabled FROM dba_scheduler_jobs;

OWNER     JOB_NAME     JOB_CLASS      ENABLED
====== ========= ======= ======
HUMADM     HUMADMJOB     DEFAULT_JOB_CLASS     TRUE

how to stop/disable this job? My oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi

View 8 Replies View Related

REVOKE ROLE - Disable All Privileges?

Mar 1, 2012

I am observing a strange behavior for the ROLES:

The DBA granted the RESOURCE role for my user USER1:

GRANT RESOURCE TO USER1;
The USER1 logged and activated the role RESOURCE.
CONN USER1/USER1
SET ROLE RESOURCE;

... it has some privileges in database ( UNLIMITED TABLESPACE for example that grant to him create table in any tablespace).

Now I created a new tablespace, but the user1 cannot use this new tablespace.So I will to revoke the RESOURCE for the USER1:REVOKE RESOURCE TO USER1;

It seems ok, but the user USER1 can still create tables in the new tablespace.I repared that UNLIMITED TABLESPACE still active, and the REVOKE RESOURCE just will have effect in the next LOGON of the USER1.

How can I REVOKE the ROLE and disable all the privileges from it immediately?

View 3 Replies View Related

Disable All The Services For Node D Temporarily?

Dec 28, 2010

There are 4 nodes in a RAC environment A,B,C,D..For instance i want to disable all the services for node D temporarily and hand over the Node D to the system admin guys and after the maintainance is done I want to restart the services again on node D..

View 1 Replies View Related

SQL & PL/SQL :: How To Disable Or Enable All Constraints In A Table

Apr 8, 2010

I knew, how to enable or disable a constraint on a table.

>alter table <table_name> disable constraint <constraint_name>;

But if we know all the data is correct, it's better to disable all constraints to improve the performance.

We are allowed to Disable or Enable only a single constraint.

Enable or Disable All Constraints.

View 11 Replies View Related

Forms :: Disable Save Button In 6i

Jul 22, 2011

I am working on form 6i. I want to disable the 'SAVE' button which can be seen in the menu (front end).

View 2 Replies View Related

SQL & PL/SQL :: Temporary Disable All Constraint In Particular Table?

Jan 7, 2012

i have one table HR.employees

SQL> desc hr.employees
Name Null? Type
----------------------------------------- -------- ----------------------------

EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
EMAIL NOT NULL VARCHAR2(25)
PHONE_NUMBER VARCHAR2(20)
HIRE_DATE NOT NULL DATE
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)

SQL>

in this table i want to temporary disable all constraint in this employees table

View 4 Replies View Related

Forms :: Disable Fields Using Personalization

Oct 2, 2010

I am working on Oracle Apps 11i. Need Forms Personalization.

Client requirement: Selected user should only see Office Phone Number for all the people in the organization when he enters the Phones form.

Means, the client is having around 10 Lookup values for Phones (Like Mobile (Office), Mobile (Personal), Office (fax), Office No. etc). Now, they want to give access to admin, only to update the Phone numbers related to Office. So, when the admin logs-in to the phone form of a employee, that admin should not be able to see other phone numbers of that Employee.

Is it possible using Forms Personalisation?

View 4 Replies View Related

SQL & PL/SQL :: Difference Between Disable Constraint And No Validate

Aug 22, 2010

Is there any logical difference between DISABLE CONSTRAINT and DISABLE NOVALIDATE, in order to accept any new values into the table regardless of violating anything?

View 2 Replies View Related

Forms :: Disable Function Keys In 6i?

Apr 3, 2006

how to disable function keys in forms6i(i.e., i want to deactivate the default function keys when running a form)

View 5 Replies View Related

SQL & PL/SQL :: How To Delete Data Without Disable Constraints

Feb 14, 2013

I want to delete data from say 100 tables without disable the constraints.

Tables having foreign key.. which is giving error if I select table randomly to delete.

I want to know the query which will give me the sequence of all tables based upon dependencies, so that If i delete the data on that sequence, it wont give me child record exists error.

View 8 Replies View Related

How To Disable Index In Partition Table

Aug 11, 2010

I am trying to disable the index i am getting the error like

ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

the table have partition. how to disable the index in partition table.

View 1 Replies View Related

Forms :: How To Disable Radio Button

Jul 16, 2013

I have some doubts about Radio buttons,

1) how to validate radio buttons in WHEN-RADIO-CHANGED?

2) how to disable a radio button?

3) how to disable a text item when a radio button is un-checked.

4) how to assign default value to radio button like(1,2,3...) or(A,B,CD,...)

View 1 Replies View Related

Spatial :: How To Disable Triggers Per Session

Mar 1, 2013

I recently stumbled upon a post for an undocumented golden gate procedure that I find VERY useful when repairing / simplifying spatial data as a DBA without causing user triggers to fire and do unnecessary work, etc. Anything with foo in the name must be good, right? ;-)

HINT: Oracle please make this a documented feature!

This will disable triggers – just for a session – no system wide changes or trigger mods needed! Yes, fire needs to be set to true - to disable the triggers from firing.

exec sys.dbms_xstream_gg.set_foo_trigger_session_contxt(fire=>true);

Note, you will need execute permissions on sys.dbms_xstream_gg first.See for more info: URL.....

View 1 Replies View Related

Forms :: Disable SAVE Button

Apr 20, 2010

I have created a form using data block wizard and lay out wizard. I want to disable the SAVE button, I gave the following in Triggers WHEN-NEW-FORM-INSTANCE

set_item_property('SAVE',visible,property_false);

but when I run the form it displays this message at the bottom of the screen

Frm 41045:Cannot find item invalidID.

View 2 Replies View Related

SQL & PL/SQL :: Disable Jobs Scheduled By User

Sep 13, 2010

changing the user for a job.

There are 2 jobs which are scheduled in database by a user XX.
Now I need to make these scheduled jobs run by user YY.

In order to do this do I need to disable the jobs scheduled by XX and then create same jobs as before under the new user YY.

View 9 Replies View Related

How To Disable SYSTEM Access From Client Users

Oct 29, 2012

My requirement is to disable access of sys user from all clients even they are providing correct password.

View 2 Replies View Related

SQL & PL/SQL :: Unable To Disable Trigger On Synonym Table

Apr 19, 2012

I have schema a and b in the same database with synonym table a (schema a) to schema b. When I try to disable trigger from table a in schema b; I got this message:

ORA-00942: table or view does not exist

I have granted all permissions to schema b and I am able to SELECT FROM table a in schema b

View 11 Replies View Related

Server Administration :: Enable / Disable Row Movement

Oct 20, 2011

for defragment of a table,

after enable it:

alter table test enable row movement;

do i need to:

alter table test disable row movement; ??

View 3 Replies View Related

Client Tools :: Disable And Enable Constraints?

Feb 7, 2011

how to disable and enable all constraints pertaining to one table at once. I want to disable them at once and also enable them at once. I make use of TOAD.

View 14 Replies View Related

Application Express :: Disable Edit Link

Dec 14, 2012

i want to disable my EDIT link in report if it satisfy my case condition.

i am using some code but using this i can unable and disable text link not a image link how can i disable image link like edit link in report.

select * from (
SELECT AP.*, CASE WHEN AP.INVOICE_STATUS='C' THEN
'<font color ="Red"></b>Modify Invoice</b></font>'ELSE
'<a href="f?p=&APP_ID.:58:&SESSION.:INV_ID:&DEBUG.:58:P58_INV_ID:'
||INV_ID||':">
[code]........

View 5 Replies View Related







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