How To List Disabled Database Instances

Nov 2, 2011

Currently, the only way I can find of doing so is to try to disable an instance, and if it is already disabled, it warns you that its disabled. This is not exatly an ideal solution! How do I simply run a query or issue a crs command to list all disabled database instances.

View 1 Replies


ADVERTISEMENT

Forms :: Disabled List Item Will Be Enabled Accordingly Just By Clicking

Feb 4, 2013

I have a problem in oracle forms. I have a block that displays five records in list item. On load, it will query two data in my table. So the list item (poplist) one and two enabled. (The default of oracle forms - List item one and two are enabled and the rest are disabled because one and two have data).

My problem was, what work around will I gonna do so that if I pressed the mouse in the third list item it will automatically enabled (for a new record) and if I pressed the list item one or two the third item will stay disable (even the fourth and fifth) because simply the user wants to update the item one or two in the list.

View 2 Replies View Related

Why Database Trigger Can Became DISABLED

Apr 30, 2013

We have an application, using ddl database trigger on oracle database.Trigger depends on package and several tables, package depends on user defined function.It works on different customer sites well, but for one customer (11g?), sometimes (cannot determine when and why), trigger became disabled.

I know, that trigger can became invalid, when its dependencies changed (i think in this situation oralce probably try to re-compile it). I understand that it can changed to be invalidwhen dependencies are not valid.I know I can alter trigger to became disabled manually.

But when it can became disabledwithout explicit alter statement be run!? Are there some conditions / circumstance when Oracle changed the trigger to be disabled?We'll ask the customer DBA team to enable audit on trigger, but it will take time to be done..

View 1 Replies View Related

Data Guard :: Multiple (Database) Instances

Oct 17, 2012

I wanted to know whether we can configure single data guard for multiple database (instances), has this been done anytime in the past .

We are a small business and growing at rapid rate. we want to cut down the cost at the same time.

Any other method or approach that is practical and economical to synchronise database between multiple production system into centralised DR system.

View 4 Replies View Related

Installation :: Install Two Database Instances In The Same Server

Jun 4, 2013

We are planning to install second instance of Oracle 11gR2 in Linux server 2.6.39-400.21.1.el6uek.x86_64 x86_64. This is something we never haven done before. The existing instance has all the standard ports:

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

Enterprise Manager Console HTTP Port (pterpdb02) = 1158
Enterprise Manager Agent Port (pterpdb02) = 3938

What ports should we select for second listener and enterprise manager? Is there anything else that we need to know before we install the second instance?

View 6 Replies View Related

Enterprise Manager :: Grid Control Database Instances Always Down

Jun 11, 2010

Installed Grid Control 10.2.0.2.0 on Windows Server 2003R2 32-bit. Immediately upgraded to 10.2.0.5.0. Both install and upgrade went fine, Grid Control can see its own database in the list of targets, looks good.

I then installed Oracle 11gR2 11.2.0.1.0 64-bit on Windows Server 2008R2 64-bit and created a new database. I then installed the 10.2.0.5.0 agent manually on the server via OUI. Agent install went fine, secured and started properly.

The problems I'm having is Grid Control can't seem to see the database instance. If I go to "Targets", GC can see the host just fine, shows that its up and can see targets for the listener (Up), the agent at port 3872 (Up), and the database instance (Down). Drilling down to the database instance, it shows that the instance is not up (though it is as I can connect to it from a different machine and run queries against not) and the Agent Connection to Instance is down with the error:
Failed to connect to database instance: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc...

Also, pulling up the "Alerts" tab for errors showed the following for Metrics "Access to Important Tables and Views", "DB Data Files Permissions", and "DB Control Files Permission":

Target: SR3
Type: Database Instance
Metric: Access To Important Tables And Views
Collection Timestamp: Jun 11, 2010 11:11:26 AM
Error Type: Collection Failure
Message: 1804 at c:oracleagent10g/sysman/admin/scripts/db/esaDbUtils.pl line 290.
There are also several "Missing Properties : [AdrHome,ConvertFromCharset,needCharsetConvert]" errors listed too.

I've looked into the 1804 error and from what I could find, its a perl-related issue with not being able to get the ORACLE_HOME information.

- I verified that ORACLE_HOME was set in the environment variables and even rebooted to make sure it was being picked up properly. That didn't work.
- I added "$ENV{ORACLE_HOME}='c:\oracle\product\11.2.0\dbhome';" to the esaDbUtils.pl file. That didn't work either.
- I added the GC security certificate to the trusted certificates on the target box in case it was some kind of SSL issue. I don't get the annoying "invalid certificate" warning, but it didn't fix it.

View 1 Replies View Related

SQL Performance Analyzer Link Disabled

Apr 10, 2012

Oracle Enterprise Manager 11g, navigating to the Performance tab for our test database. The "SQL Performance Analyzer" link is not apparent (as is all the other links).

I checked the "setup", in particular, the Management Pack Access ... all of these have checks by them ...

Database Change Management Pack
Database Configuration Management Pack
Database Diagnostics Pack
Data Masking Pack
Database Tuning Pack
Provisioning Pack
Pack Access Agreed.

Also, checked the value of the "control_management_pack_access" which reads "DIAGNOSTIC+TUNING"

How to get the "SQL Performance Analyzer" link enabled? Apparently, according to one of my colleagues, they used it about a month ago, so I don't know what could have happened between then and now.

View 1 Replies View Related

Forms :: All Block Fields Are Disabled

Dec 11, 2011

I am using Forms 6i in Application. In Form, After i enter the data and saved then,if i retrieve the data by using Ctrl+F11, all the fields of data block turns to be disabled (insert not allowed, update not allowed) of course i am getting the data.If i close the application, and open freshly it works good (insert allowed, update allowed).

View 1 Replies View Related

Save Password Disabled In Login Screen

Dec 6, 2011

I have Toad 9.6.1 already installed on my machine and have now installed Toad 10.6 . unfortunately the Save Passwords option on the Connection screen is disabled. how do I enable that option.

View 2 Replies View Related

Query Tablespace For Flashback Enabled / Disabled

Jun 16, 2011

Since tablespaces can be enabled/disbaled for flashback is there a query that can tell me the flashback status of each tablespace in my DB.

View 2 Replies View Related

Forms :: Fields Not Getting Disabled In Mouse Click?

Apr 11, 2011

I am using the below code to disable forms field in fdtlblk.mdt_rqr = 'NO'

but I can go there with mouse click ( for tab and enter it is working fine ) .

but for mouse click it is not working .

if (:fdtlblk.mdt_rqr = 'NO') then
go_item('fdtlblk.section_loss');
set_item_property('FUP_RCVD_DT',enabled,property_false);

[Code]....

View 1 Replies View Related

Forms :: A Button Has To Be Disabled In Query Mode (F11)

Apr 3, 2012

Am developing a custom form. I have a block with 5 Items and one button(SUBMIT). When I go in query mode (F11), SUBMIT button to be disabled. How do i achieve this.

View 22 Replies View Related

Server Administration :: Disabled Triggers And Constraints

Oct 29, 2010

What should I do with those disabled CONSTRAINTS (most were those file starts with LOGMNR) & TRIGGERS found on our production dB? Are there any impact once I enable those?

View 2 Replies View Related

How To Audit When A Constraint Is Disabled / Enabled Or Dropped

Sep 3, 2013

Is it possible to audit when a constraint is disabled, enabled or dropped? Sometimes I wonder why some constraints are missing. To make sure someone is dropping I would like to audit that action. Further, I would need to compare schemas to realize if some constraints are missing. As it names are generated automatically by oracle, how could I easily run a select to compare the constraints that does not match between schemas?

View 10 Replies View Related

Forms :: SUBMIT Buttons Which Is Disabled / Gets Enabled Automatically

Apr 3, 2012

I have a scroll bar in my form. When i scroll the bar, one of SUBMIT buttons which is disabled gets enabled automatically. Do we have any triggers on scroll bar where i can disable the button again.

View 4 Replies View Related

Multiple DB Instances On Same Server

Sep 6, 2012

We have installed "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" on server. we created one SID(agile9d) and configured listener(LISTENER) on 1521.This is working fine.

Now,we want to create one more SID(XXXX) on the same server.So,Need some clarification on below points.

(1). Do I need to configure one more listener for new SID?(Ex: LISTENER1)?
(2). Can I use the 1521 port again while configuring new listener?

View 7 Replies View Related

SQL & PL/SQL :: ORA-01994 - GRANT Failed / Password File Missing Or Disabled

Apr 5, 2012

When I create the orapwd file the sys user is not in the file,The problem started when I tried to grant sysdba privileges to sys

[oracle@bg2mo08i3 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Apr 5 18:47:06 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production

SQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

SQL> shutdown immediate;

From the postings I read I shutdown the DB and I created a new orapwd file:
$ orapwd file=$ORACLE_HOME/dbs/orapwSID password=password entries=30 force=y

SQL> startup;

Started the DB, verified that the password parameter is set to EXCLUSIVE.

SQL>show parameter password;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>

SQL> select * from v$pwfile_users;
no rows selected
SQL>

Shouldn't the sys user be listed in the v$pwfile_users?

[oracle@bg2mo08i3 dbs]$ ls -l ora*
-rw-r----- 1 oracle oinstall 1536 Apr 5 18:02 orapwSID

Are these permissions and ownership correct?

I can connect using sys's password: SQL> connect sys/sysPASSWORD as sysdba Connected

View 12 Replies View Related

Using Services To Correlate Workloads To Instances In RAC

Jan 17, 2011

We have a new requirement for a RAC environment. Its workload will comprise both OLTP and batch loads. Am I right in thinking that I can map the appropriate applications to the required node using services, e.g.

Application 1 (OLTP) has node 1 as its preferred service node - so all OLTP trxs run through node 1
Application 2 (Batch) has node 2 as its preferred service node - so all batch trxs run through node 2

Both applications will have the other node for its available service to facilitate HA in an emergency.

Does that sound right? (or have I got it completely wrong!)

View 3 Replies View Related

Comparing Index And PK Of A Table Between Instances?

Dec 2, 2012

I am about to compare Indexes and PK's(Constraint) of 3 instances.

What DBA table/s should i use best? The comparison is done to a specific schema only.

PS:Which is better dba_ind_columns or dba_objects?

View 10 Replies View Related

Running Two Instances On Single Machine

Apr 25, 2013

i am using oel 5.5 with oracle 10g release 2 installed in it . I am unable to run two different instances on same machine how can do that? I changed the ORACLE_SID then i startup one instance is starting but when i change the sid again and tried to startup it shows me that oracle is already started shut it down first.

Is there any way to startup two different instances?

View 5 Replies View Related

Clusterware :: 2 Oracle SE Instances In 1 Cluster?

Jun 21, 2013

I would like to build a 2-node cluster without RAC.  I desire to operate 2 Oracle database instances for use by 2 separate applications.  I plan to run Linux.  I would like node1 to act as the primary server for the databases in application1 and node2 to act as the failover server for the databases in application1.  Conversely, I want node2 to act as the primary server for databases in application2 and node1 to act as the failover server for databases in application2.  Can Oracle SE and Oracle Clusterware be configured in this this way?

View 2 Replies View Related

SQL & PL/SQL :: How To List Database Objects

Jul 21, 2010

Is there a SQL that gives the list database objects (tables/views/packages/functions etc.) where a particular column in a table is used?

Example:

CREATE TABLE XYZ (ID NUMBER);

I want to know all the objects that used the column ID in table XYZ either in select statement or in a condition.

View 3 Replies View Related

PUSH Versus PULL Tables Between Two Instances?

Oct 19, 2010

I want to move data between two instances and recommended we create a local database link to PULL data from remote database located here (supplier on site) but they want to PUSH data to us. I thought you could only PULL data over a database link but then read the link [URL] where PUSH is considered ? I was going to use standard creatas like create table A as select * from table A@<remote_db_link> which works well and fast ( tried and tested) but some are saying they think PUSH quicker/better ?

we do have data "PUSH" already but this does not use a db link - effectively it calls a local proceedure here and passes a row of data and is slow ie for a 1000 row table to be pushed to us we have our local proceedure called 1000 times.

I have always suggested a PULL with db_link as the fastest method - any proof OR info on a fast PUSH method ( that is quicker than PULL ) ? can you REALLY push ?

View 2 Replies View Related

Forms :: Running Multiple Instances Parallel In 11g R2

Feb 13, 2013

My requirement is to Run 2 instances of forms 11g R2 parallel at a time(means running 2 urls of 2 instances same time). I have tried with installing 2 instances but when i install and configure my 2nd instance then my 1st instance services are shutting down.At a time it is running only one instance services.

And also i have tried with installing 2 Cluster instances of 11g R2 Forms but same thing happening as above.

how to run 2 instances of Forms 11g R2 parallel and also suggest me to install instances in same domain or different domain because with same domain 2 instances it is creating only one config file..so i tried with different domains. Different Config files created but only one instance service is running.

View 1 Replies View Related

RAC & Failsafe :: Listing Hidden Parameters For All Instances

Nov 30, 2010

I used following statement (user SYS as SYSDBA)

select x.inst_id,x.indx+1,ksppinm,ksppity,ksppstvl, ksppstdvl, ksppstdf,
decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE'),
decode(bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED', 3,'IMMEDIATE','FALSE'),
decode(bitand(ksppiflg,4),4,'FALSE', decode(bitand(ksppiflg/65536,3), 0, 'FALSE', 'TRUE')),
[code].......

to list hidden parameters. However, when using it on RAC I found that only a singe instance data is displayed.

View 8 Replies View Related

Data Guard :: Stop Instances At Standby?

Aug 30, 2012

My oracle version is 11.2.0.2 RAC RDBMS on RHEL 5.6.

At my standby site my physical standby database is on 4 node cluster with all 4 instances up. I need to disable 3,4 instances so that we want it to run on only 1,2 instances.To disable the instances do i need to stop apply(mrp) process. And the apply node is node 1.

View 9 Replies View Related

Getting List Of Populate Tables In A Database?

Feb 9, 2012

The database system they have has around 5000 tables. The majority of these are not used (it is an off the shelf package). What I am trying to do is get a list of all tables in the database BUT only those that contain records (not the empty tables) and then copy this to an excel spreadsheet. We use a tool called aquadata to run sql enquiry statements on.

View 5 Replies View Related

Server Administration :: Listener Shutdown For Individual Instances

May 17, 2013

I am upgrading a DB using catupgrd.sql, and one of the prerequisites is to shut down the listener. Now, I have multiple database instances registered with this listener, and I don't want the other ones to become unavailable while I do the upgrade. Is there any way to do this for a particular instance only?

View 9 Replies View Related

Real Application Clusters :: 2 Node Instances On AIX - Row Lock

Jan 24, 2013

I am wokring on oracle 10.2.0.4 rac 2 node instances on AIX. We have one table having multiple rows defilning jobs will be done by users ...the functionality is that ..when even one user will pick on row (job) , one update statement will issue and it will update status column to 1 which menas job is allocated , this means now this should not allocate to any other user ..

but we are facing issue that once any user will pick that job , in application log files we can see that row gets lock and updates the status to 1 . but then also users connecting to other or some time same instance will get that job...means multiple users can pick same job .. even after already picked by another user ..

Is this can be issue with rac configuration ... like whenever one user updates a row ..it will be in cache of one instance and when another user trys to again update 2nd instance does not have that information and allows user connected to that instance to pick that job..like delay in block transfer or cache fusion..

is this can be issue with rac or it is purely application issue..

View 3 Replies View Related

Queueing :: Error When Create Sub-consult With DBLink Between 3 Instances

Nov 7, 2012

I have 3 instances and i want to work between then. The error occurs when i use subquery, This is the code:

update erie.rie_cbtrega@l$e_tfcries rgr
set rgr.c_descri = ( select rg.c_descri
from dadm.cbtrega@l$e_tfccie rg
where rg.c_idrega = rgr.c_idrega
)
;

When i execute update without subquery "( select rg.c_descri from dadm.cbtrega@l$e_tfccie rg where rg.c_idrega = rgr.c_idrega)" the result is successfully, but when i add subquery the result is

ORA-02019: no se ha encontrado la descripción de la conexión para la base de datos remota
ORA-02063: line precediendo a TFCCIE
ORA-02063: 2 lines precediendo a L$E_TFCRIES

View 1 Replies View Related







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