Forms :: How To Make A Node
Feb 27, 2012How to make a node of a Hierarchical Tree BOLD without intervene java code ?
View 1 Replies
ADVERTISEMENT
Workflow :: How To Make Node To Deferred In Oracle
Aug 17, 2012How to make node to deferred node in oracle workflow ?
View 2 Replies View RelatedReplication :: Possible To Make Service Running Even When Node Falls?
Sep 23, 2008I've configured a replication environment with Oracle 11g (Multi-master synchronous replication). Apparently it works fine, when replication is started any change in a table that belongs in a node is replicated in the rest of the nodes.
One of the tests I'm making is the following: Try to see what happens if one of the nodes drops. Meanwhile one of the nodes is no avalaible, any modification in an available node is not allowed (as I expected). I'm trying to see if the database service can be available meanwhile a node is missing, although the replications is not running.
What I've experienced is replication cannot be suspended until the the node was down is restarted.
Is this the usual behaviour or can I set any parameters to avoid this? In other words, is it possible the database service is running meanwhile one of the nodes is down? The application I'm working on needs this type of replication, buy also needs the service is running always?
What can I do to make possible the service is running even when a node falls?
RAC/ASM Clusterware Installation :: Query On Adding New Node To Existing 2 Node Cluster
Jun 15, 2012current environment
Oracle VM 2 Node RAC cluster
Oracle 11G 11.2.0.3.0
Oracle 11g rel 2 GI
on current 2 node cluster we have GI and RAC db configured Nodes: vmorarac1,vmorarac2
we shutdown vmorarac1 to clone it to vmorarac5
on new node I have changed the hostname to vmorarac5 In /etc/sysconfig/network-scripts/ifcfg-eth0 change ip to new ip and same for /etc/sysconfig/network-scripts/ifcfg-eth1 152.144.199.210,152.144.199.211
mad echanges to /etc/hosts on vmorarac1/2 for 2 new IP address assigned to vmorarac5
152.144.199.171 vmorarac1.pbi.global.pvt vmorarac1
192.168.2.30 vmorarac1-priv.pbi.global.pvt vmorarac1-priv
152.144.199.184 vmorarac1-vip.pbi.global.pvt vmorarac1-vip
[Code]....
Query is is that all ok to reboot the new node to reflect changes as below and change the hostname to vmorarac2
152.144.199.210 vmorarac2.pbi.global.pvt vmorarac2
192.168.2.32 vmorarac2-priv.pbi.global.pvt vmorarac2-priv
152.144.199.211 vmorarac2-vip.pbi.global.pvt vmorarac2-vip
hostname change in /etc/sysconfig/network
On new node vmorarac5, there is alreay software for RAC DB and GUI cloned from vmorarac1
addnode.sh is used to add existing node, but as part of pre-requisite configuratoin is there any config step missing
Data Guard :: How To Find Apply Node In RAC Two Node Standby DB
Aug 16, 2013I believe, in a multiple RAC Physical Standby nodes only one node applies the archivelogs to the standby database. How you can find which node is the APPLY NODE using a SQL query?
I know you can veiw this information by querying the standby configuration using DGMGRL but how would you find out this information from a remote client using SQLPlus/PLSQL?
RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment
Jan 24, 2011We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?
View 3 Replies View RelatedRAC/ASM Clusterware Installation :: VIP Node Application Failing In Second Node
Jul 18, 2013I am installing Oracle 10g Clusterware in RHEL 5 Server. When i run root.sh in the second node the last step Running vipca(silent) for configuring nodeapps failed. Then i run VIPCA manually in second node and configured vip configuration successfully,but when i checked the post-checks for cluster services the Checking existence of VIP node application,Checking existence of ONS node application and Checking existence of GSD node application in second node failed. I am able to ping both the servers one another with vip name successfully and the CSS,CRS and EVM appears healthy in both nodes. 1. Does the vip configuration is proper? If no what is causing this error and how to rectify it? Find the output below
[root@Rhel52 bin]# ./crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy[root@Rhel52 bin]#[root@Rhel52 bin]# clear[root@Rhel52 bin]#[root@Rhel52 bin]# ./crs_stat -tName Type Target State Host------------------------------------------------------------------------------------ora.rhel5.gsd application ONLINE ONLINE rhel5ora.rhel5.ons application ONLINE ONLINE rhel5ora.rhel5.vip application ONLINE ONLINE rhel5ora.rhel52.gsd application ONLINE ONLINE rhel52ora.rhel52.ons application ONLINE ONLINE rhel52ora.rhel52.vip application ONLINE ONLINE rhel52 [root@Rhel52 bin]#./runcluvfy.sh stage -post crsinst -n
[code]....
RAC & Failsafe :: Single Node RAC - Configure Only One Server Instead Of Two Node?
Sep 13, 2012 I would like get more details about single node RAC.. What is single Node RAC?..
1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ...
2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...
is there any advantage using single node rac(other than online upgrade to full RAC).
Forms :: How To Make A Calendar
Mar 4, 2003I have read the messages below about making a calendar but am still unsure of how to go about doing this. I have the STNDRD20.OLB file, but I don't know where to put it or what to do with it! What comes next?
View 20 Replies View RelatedForms :: Make Calendar In Oracle 10g
Sep 15, 2011I want to make calendar in oracle form 10g, but i don't know make it. How to do make calendar?
View 2 Replies View RelatedForms :: Make Field Non Editable
Jul 29, 2010I have a field on the form which is a database field and the value is populated by a LOV. The user should not be able to edit the value selected or enter his own values in the field. Basically the field should only be populated by the lov and should not be editable.
I tried using the SET_ITEM_PROPERTY('XX.XX', UPDATE_ALLOWED, PROPERTY_FALSE); but this only disable update against existing value. If a user selects a new value from LOV that can be edited.
Forms :: Make Cursor At The Item
Jan 25, 2013I have a button "clear" , I want when the button is clicked the items will be cleared and the cursor is at the first item, here is the
:emp.id:=null;
:emp.ename:=null;
:emp.sal:=null;
go_item('emp.id');
=>but the problem that the item changes color, but the cursor remains at the button "clear"
NOTE:
I used the "when-new-item-instance" trigger to change the color of text items
Forms :: Make One Form For Many Systems
Mar 4, 2013make one form for many systems i have (i.e) I need to make it like portal many button for many systems When i enter the button i login to specified system (i.e) I need to make new connection to this schema and disconnect the previous one.
View 1 Replies View RelatedForms :: How To Make Calculator In Oracle 6i Or 10g
Jul 22, 2013Is it possible to design calculator in oracle forms 6i or 10g?
View 2 Replies View RelatedForms :: How To Make Oracle Application Always On Top
Feb 13, 2010I want to make oracle application "always active" or "always on top" automatically when windows logon as feature provided in task manager.
View 2 Replies View RelatedForms :: How To Make Block Query
Jan 30, 2012I have one form, when i press f7 , it says the "The function has no meaning in this context" , how to make it query enabled block.Actually i am going to that block using when button pressed and execute_query.
View 12 Replies View RelatedAdd Third Node To Existing Two Node Cluster
Feb 3, 2012I'm trying to add the third node to my existing two node cluster. In fact i succeded adding the node but i have the following problem:
-when i start node 1 and 2, everything is ok, but on node 3 startup one of the other nodes fails
-this happens in any combination: start 1 and 3, everything is ok. when i start node 2, node 3 fails
The asm configuration (disks, permissions, etc) is the same on all three nodes.find below the asm and crsd log details from the failure time:
alert_ASM.log
NOTE: enlarging ACD for group 1/0x124851d1 (DATA)
WARNNING: cache read a corrupted block group=DATA dsk=4 blk=1 from disk 4
+NOTE: a corrupted block from group DATA was dumped to /u01/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_rbal_4109.trc+
WARNNING: cache read(retry) a corrupted block group=DATA dsk=4 blk=1 from disk 4
[code]...
Forms :: Add Checkbox With Hierarchical Tree Node
Jun 10, 2011I am using oracle forms 9i. I have to create a Hierarchical Tree and attach checkbox at its node,so that user can select which tree he want in its further processing.
View 4 Replies View RelatedForms :: Disabling A Node In Hierarchical Tree?
Jun 3, 2010I have a hierarchical tree with two parent nodes. Each parent node has different number of child nodes. Can i disable or hide a node according to some condition?
View 5 Replies View RelatedForms :: How To Make Browse Image In Oracle 10g
Apr 17, 2011how to make browse image in oracle form 10g?
View 1 Replies View RelatedForms :: Make Field Protected Against Update?
Apr 29, 2011What i am required to do is to protect a field 'COUR_CODE' from update when the SHIP_METHOD='R'. c
if :system.record_status = 'INSERT' then
declare
vcour_code ACCOUNTS.cour_code%type := NULL;
vcourier_account_no ACCOUNTS.courier_account_no%type := NULL;
canvas_name varchar2(30);
begin
[code]....
Forms :: How To Make Query Mode Work (f11)
Apr 2, 2012I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.
View 18 Replies View RelatedForms :: How To Make Demand Wise Report
Jul 3, 2013I have a payment table that has the ids of cds that has being sold in the past month. From there I want to make a demand wise report. I am aware of the report wizard in the oracle forms but I dont want to use it. Here are the tables in a bit more details.
payment: id_cd, price, dateofsell
cd_details: id_cd, name, price, language.
Forms :: Finding Node In A Tree - No Data Found?
Mar 5, 2012I have a problem with finding a node in my tree, but when I click the find button, it threw a message NO DATA FOUND.
here is the code that I used in find button:
DECLARE
tri ITEM;
hanapin_mYnode FTREE.NODE;
BEGIN-- Find the tree itself.
[code]...
Forms :: Unable To Make The Form Fields Available To Edit
Jan 30, 2013My requirement is to call a form through special menu icon from one main form and display some information. Whenever i open a new form it should fetch a record and display where some of the fields should be available to edit. I am displaying a record based on a view.
For that i have used below code in when-new-form-instance
- GO_BLOCK('Block name');
- DO_KEY('Execute_Query');
After executing the query my block status is becoming 'QUERY' where i am not able to set the block/item property "Update allowed" to true.
I have added below piece of code
set_item_property('block_name.item name',insert_allowed, PROPERTY_TRUE);
set_item_property('block_name.item name',UPDATE_ALLOWED,PROPERTY_TRUE);
in almost all the triggers and tried. I could still see all the fields are read only.
Forms :: Make Print Button To Display Information
Oct 4, 2012how can i put button in a form to print the information i displayed in this form.
View 1 Replies View RelatedForms :: Make Excel Dump For Some Banking Application Using 6i?
Jun 17, 2010I am trying to make an excel dump for some banking application using Forms 6i . I am making use of OLE to make an excel dump. I have a small problem while using this OLE concept . I have an Account column which is is having the data type VARCHAR2 at database level . when i try to make a excel dump of this column , then the values in the account number column in excel is getting converted into number column . Eg: A/c - 000123 is appearing as 123 in excel. How this can be retained as 000123 in excel sheet .
test case -
actual value appearing value in excel
000123 123
code extract in hv used -
args := ole2.create_arglist;
ole2.add_arg(args, rowcount);
ole2.add_arg(args, colcount);
cell := ole2.get_obj_property(worksheet, 'Cells', args);
ole2.destroy_arglist(args);
ole2.set_property(cell, 'Value', rec1.BANKNR);
ole2.release_obj(cell);
Forms :: Make Push_button To Act As Browse Pictures Files?
Feb 19, 2010How i can make a push_button to act as browse the Pictures files only to upload in Image Box. At Commit store in my Database.
View 1 Replies View RelatedForms :: Create Hierarchical Tree With Department Number As Node?
Mar 25, 2010I would like to create a hierarchical tree with Department number as a node and all the employees (only employee names) under that department as shown below:
[-]Department - 10
KING
JAMES
-----
[-]Department - 20
MARY
|
|
and so on...
I have created a hierarchical tree 'HT_DEPTNO' under block 'BL_EMP'. I also created a Record Group 'RG_HTREE' with query as shown below:
SELECT 1, LEVEL, E.ENAME, D.DEPTNO||' - '||D.DNAME DEPARTMENT, D.DEPTNO
FROM EMP E, DEPT D
WHERE E.DEPTNO = D.DEPTNO
START WITH E.DEPTNO = 10
CONNECT BY PRIOR E.EMPNO=E.MGR
I am attaching the form for your reference.
Forms :: Hierarchy Tree Menu - Call Reports Through Node
Jun 12, 2012I have a hierarchy tree menu look like this
+GL
Accounts
Inform
+Export
Export Entry Form
+Security
New User Entry
when i click Gl==>Accounts, accounts form opens and i want call my forms and reports through nodes.