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
ADVERTISEMENT
Sep 16, 2012
)How do you view the value of the parameter that is being used by instance? show parameter..?
2)How do you get the information of hidden parameters
3)What is the database object that stores information related to various types of db connections over network
4)How do you verify since when the db session is running
5)How do you verify the Originating machine details of the database session
6)How do you verify the name of program that the db session is running
7)What is the naming convenion of Base tables. Where is the information of base tables stored?
8)How are dynamic views created. Whre is the information of dynamic views stored?
View 8 Replies
View Related
Nov 16, 2010
Today, I've got an error:
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 17 09:45:50 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
idle> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/DOISOAT/spfileDOISOAT.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/DOISOAT/spfileDOISOAT.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
idle> exit
SP2-0042: unknown command "exit" - rest of line ignored.
idle> exit
Disconnected
First time, I tried to recreate spfile from pfile, however, it - the errors continued to occur. And I searched in metalink, so, I've got ID 387217.1. I've been beging followed:
1- Check the REQUIRED_RESOURCES was listed by crs_stat -p command, wasn't it? Then, the REQUIRED_RESOURCES did not contain anything
2- Modify by Metalink comment solution:
srvctl modify instance -d <database name> -i <instance name> -s <ASM instance name>
Everything is done, however, I still did not startup database instance. The above error continued, and I force to stop all by crs_stop -all.
View 1 Replies
View Related
Jan 17, 2012
working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.
View 6 Replies
View Related
Sep 4, 2012
I have an agent, actor, movie and producer table, I want to list the details of all agents who represented actors casting in movies produced by "X" (X is the name of producer). I want to know the command for doing this.I have the following tables:
table agent(
agentID(pk),
fname,
sname,
city,
sex
[code]...
I have a producer fname as Xavion in the table.
View 3 Replies
View Related
Mar 18, 2013
I have a table with data in below format:
Table A
Id Value
1 R
2 S1
2 S2
3 T
the o/p in below format:
Col
R|S1|T
R|S2|T
The general is that multiple value for any given id must be aggregated separately.
View 1 Replies
View Related
May 30, 2013
I frequently need to run queries to do things like sum space used by each schema, but excluding all of the default system users. Is there a better way to identify the default users than listing all 30 of them in a "not in" expression? For example in sql server to query user databases you just say "with database_ id > 4". Is there something simple like that in Oracle to identify all default users?
View 6 Replies
View Related
May 25, 2010
Is there anyway to get a listing of the files in a specified directory on an ftp server using webutil?
View 2 Replies
View Related
Aug 7, 2012
Is it possible to use a compound condition on a form listing say 15 records utilizing the F11 key?(ie. order column <10 and >5)
View 2 Replies
View Related
Jul 31, 2011
I am not sure if the problem is related to hidden characters but its my best guess so far. I am trying to enhance a part of the ERD by creating a lookup for a column one of the table that uses text (finite set of values).
CREATE TABLE N_AGREEMENT_STATUS
(
STATUS_ID NUMBER(2) PRIMARY KEY,
STATUS_NAME VARCHAR2(10 BYTE)
);
INSERT ALL
INTO N_AGREEMENT_STATUS VALUES (1, 'INACTIVE')
INTO N_AGREEMENT_STATUS VALUES (2, 'ACTIVE')
INTO N_AGREEMENT_STATUS VALUES (3, 'CLOSED')
INTO N_AGREEMENT_STATUS VALUES (4, 'CANCELLED')
SELECT * FROM DUAL;
when I try to update the source table no update takes place (0 records updated) if I used the following statement:
ALTER TABLE N_AGREEMENT ADD STATUS_ID NUMBER(2);
UPDATE N_AGREEMENT SET STATUS_ID =
(
SELECT STATUS_ID
FROM N_AGREEMENT_STATUS
WHERE N_AGREEMENT.STATUS = STATUS_NAME );
but it works fine only if I used:
UPDATE N_AGREEMENT SET STATUS_ID =
(
SELECT STATUS_ID
FROM N_AGREEMENT_STATUS
WHERE N_AGREEMENT.STATUS LIKE STATUS_NAME || '%'
);
The strange thing is that when I use:
SELECT N_AGREEMENT.STATUS, N_AGREEMENT.STATUS_ID
FROM N_AGREEMENT
WHERE N_AGREEMENT.STATUS = 'ACTIVE';
it returns correct results and all status = 'ACTIVE' appear correctly!
View 20 Replies
View Related
Feb 15, 2012
I want to create a column which will be having unique values but while selecting data from table i am not willing to display same column in output.
SQL> create table temp
2 (
3 c1 number,
4 c2 number,
5 c3 number
6 );
Table created.
SQL> insert into temp values (1,2,3);
1 row created.
SQL> select * from temp;
C1 C2 C3
---------- ---------- ----------
1 2
I want C3 as a hidden column and while selecting like
select * from temp;
expected output is...
C1 C2
---------- ----------
1 2
My main target is, C3 column should not display in select * ... stm but column with data should be there in table.
View 7 Replies
View Related
Mar 9, 2011
I ran into the following issue as mention below.
select dump(column_name) from table where column_name2 = 'HP1';
dump(column_name)
--------------------------------------------------------------------------------
Typ=1 Len=5: 194,160,82,88,66
I am trying to get right of these hidden character 194 and 160. i tried different method as mention below,
1) translate(column_name, chr(194)|| chr(16),'')
View 7 Replies
View Related
Dec 15, 2011
Jow can i sort field data getting from formula column. The filed that i want to sort have source of that formula column. When i use order by clause with :abc ---(formula column) then it doesn't not work.
View 3 Replies
View Related
Mar 20, 2013
quick check on a hidden parameter? I need to know the default value and possible values for _serial_direct_read on various releases, I have only 11.2.0.3 available right now and I'ld like to know this for 11.2.x.x 11.1.x.x, and 10.2.x.x.
Below is the query that will show what it is currently which (unless you've changed it) will be the default: auto for my 11.2.0.3. Then to see the options, try to set it to something wrong, my options are false/true/never/auto/always. I think false/true were the only choices for 10.2 and are maintained only for compatibility. But I can't rememebnr 11.1.
orcl>
orcl> set lin 80
orcl> select KSPPSTVL from x$ksppcv join x$ksppi using (indx) where ksppinm='_serial_direct_read';
KSPPSTVL
--------------------------------------------------------------------------------
auto
orcl>
orcl> alter system set "_serial_direct_read"=rubbish;
alter system set "_serial_direct_read"=rubbish
*
ERROR at line 1: ORA-00096: invalid value RUBBISH for parameter _serial_direct_read, must be from among false, true, never, auto, always
orcl>
update: added 11.1.x.x to my wishlist
View 10 Replies
View Related
Mar 20, 2012
My database is in UTF8 character set..
And it is not supporting chr(194)||chr(160)
what character set you were using then ?
And.. is there a way to handle non breaking spaces in UTF8..
View 16 Replies
View Related
May 6, 2011
I have a forms 11g application that of course has several message and alert windows that pop up when various errors or messages need to be displayed. This all works great on the developer machine, but when I try and run the form on another machine using any browser the message and alert windows appear to be hidden and the application locks up with the rolling bar across the bottom. I would guess it is waiting for a response, but I cannot get the window to appear.
Following is an example of an alert to be displayed:
declare
vAlertButton number;
begin
vAlertButton := show_alert('NO_EMAIL');
end;
View 1 Replies
View Related
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
May 8, 2013
1.-) i got a page that contains 2 regions, lets say :master (HTML text) and a detail (tabular form updateable report) in my tabular form i got a hidden item that should take the value from the master form. how do i do this ?
2.-) i am calling a form from another form, sending a couple of fields as a link parameters. the second form is called as expected, but i need that records on the second form that match the parameters get displayed. how do i achieve that ?
View 6 Replies
View Related
Sep 6, 2012
i m using Apex4.1 and data base oracle 11g, browser firefox
i m using recaptcha plugins i had tried it with both way by creating 3 hidden field and and also directly with taking a item based on plugin. URL.....
More specifically, the page has two items for user input (the captcha and a text item) and a Submit button. If the captcha is successful, then the text item will be submitted and redirect to another page. The problem I'm running into is that the text item is always submitted regardless of the captcha.
View 0 Replies
View Related
Sep 12, 2013
I just created a "Hide and Show Region" from a template in APEX4.2, and would like to control the behaviour of this region, i.e.
1. At the page load, this region should be in "Hidden" mode
2. Once the user Opens the region, it should stay as "Expanded" mode ( even the page gets submitted), until the user chooses the "Hidden" mode again.
So I tried the following
1. Chose the Hide and Show Region(expanded) template for the APEX region
2. uses Dynamic action to force the "Hidden" mode by setting Style as style="display: none;" at the page load event.
But it still shows the region in "Expanded" mode after the page gets loaded.
View 0 Replies
View Related
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
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
View Related
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
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
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
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
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
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
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
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
