Importance Of Public And Virtual IPs In Etc / Hosts File When Dealing With Oracle RAC
Mar 12, 2011
When working against the Oracle 10G/11G RAC database it's important to have all the relevant entries in the etc/hosts file.
Thus, when running the following code against the database sometimes it finishes with "Ok!" and sometimes getting the error below:
CODEimport java.sql.*;
public class TestDBOracle {
public static void main(String[] args)
[Code].....
The reason is missing RAC-related entries in the etc/hosts.
When dealing with Oracle RAC it should be both entries for the public and for the virtual IPs of the nodes in the etc/hosts file.
CODEA.A.A.A NODEA
A.A.A.B NODEB
...
B.B.B.X NODEA-VIP
B.B.B.Y NODEB-VIP
...
View 1 Replies
ADVERTISEMENT
Oct 21, 2010
I am working with oracle 10g / 11. I need to operate with CLOB values of some table, unknown for me: I read them from .Net (3.5), and have to save them to files (Windows) to be loaded after this with DBMS_LOB. Lets say that table contains 3 columns (1 - CLOB) and several rows.I want to store each CLOB value to separate file, and to store it after this into another DB table (another Instance, also).I cannot use dblinks and other techniques like this.
The point is - how to avoid dealing with encoding?
I just want to save the CLOB values to the files, with no meter about Database Instance character set, language, and so on. If I use default for .Net StreamReader UTF-8 format, the loading with DBMS_LOB failed.
what will be the best way to determine the encoding, and to convert Oracle used encoding to .Net one?
View 6 Replies
View Related
Oct 21, 2010
I need to encrypt a file with GPG using a pgp public key I never done this, what are the commands..
View -1 Replies
View Related
Feb 22, 2013
Previously we had 32 bit C++. Now, we have migrated it to 64 bit. And our C++ programs interact with Oracle 10g DB.Our C++ program was working fine with 32 bit. But once after we migrate to 64 bit we are facing problem with one program which does FETCH(EXEC SQL FETCH SUBP1 INTO :new TabRec;) from Oracle DB. ie, We exit from a for loop in the C++ program when we get NOT FOUND(sqlca.sqlcode=1403) on executing the FETCH statement.
The sqlcode generated for NOT FOUND scenario is 1403. But, once after moving to 64 bit C++, we do not see the sqlcode 1403 instead we are seeing a different code 7124089117159473.
As the sqlcode is not 1403, our program does not exit from the for loop and goes on an infinite loop.Am I missing anything that makes me to not get the exact sqlcode?
View 9 Replies
View Related
Aug 31, 2012
we need to use recursion functions in pl/sql?? How can we use them in efficient way?? Also focus on mutual recursion in real world scenario.
View 4 Replies
View Related
Oct 8, 2011
I am dealing with a bunch of tables containing sales information for an New Zealand organisation. The sale datetime has been recorded as UTC.
New Zealand operates Daylight Savings, so twice a year it changes its clocks.
When New Zealand is on standard time it is UTC+12.
When New Zealand is on daylight savings time it is UTC+13.
Thus an event which actually occurred when New Zealand was on standard time at 2011-08-31 15:20:52 local time, is recorded in the database as having occurred at 2011-08-31 03:20:52. However, an event that actually occurred when New Zealand was on daylight savings time at 2011-10-06 15:20:52 local time, is recorded in the database as having occurred at 2011-10-06 02:20:52.
I want to be able to read the sales dates from my table and convert them to the actual time in New Zealand when the event occurred. The table will contain data for sales that occurred in both standard and daylight savings times.
I do not think that the data has been stored with time zone information, simply that the application writing the data to the Oracle database, calculated the event time as UTC when it occurred and wrote that time to the table.
Does Oracle only know about what UTC-offset is in force right now or is it capable of determining what offset from UTC is required for any given historical date ?
View 6 Replies
View Related
Dec 12, 2012
I have this very simple SQL statement:
SELECT e_id AS id,
'javascript:$(''P4_ID'','|| e_id ||'); openModal(showEvent);' AS url
FROM event_info evtwhich returns
86 javascript:$('P4_ID',86); openModal(showEvent);
87 javascript:$('P4_ID',87); openModal(showEvent);
88 javascript:$('P4_ID',88); openModal(showEvent);
89 javascript:$('P4_ID',89); openModal(showEvent);
But I'd like it to return the following (apostrophes surrounding the e_id)
86 javascript:$('P4_ID','86'); openModal(showEvent);
87 javascript:$('P4_ID','87'); openModal(showEvent);
88 javascript:$('P4_ID','88'); openModal(showEvent);
89 javascript:$('P4_ID','89'); openModal(showEvent);
And I am struggling with figuring out how to get this working.
View 2 Replies
View Related
Apr 25, 2013
We just got a new Dell R720 server that will host our Oracle DB. The server hasn't even been turned on yet but we know that the load on the server will be very low for a long time.
One of our problems is that we need to run a VERY important application. Since it is not very resource consuming compared to it's importance we chose to run it on a not so new Xeon 5110 1.60 GHz - 4GB RAM server. He said it's not a good idea and that we should buy a new server. (money is very low)
The software vendor suggested to virtualize our R720 server, host a vm running our database, and along with it other smaller machines like the one I described above. I suggested the use of Oracle VM, Oracle Linux for the database host and transforming the physical servers servers in VM with P2V.
Our IT Manager didn't like that, he said that it's not recommended to run a database on a virtual machine. But our software vendor said that many of their clients run their solution this way.
View 7 Replies
View Related
Mar 31, 2012
I created policy as follow.
BEGIN
DBMS_RLS.ADD_POLICY (
object_schema => 'scott',
object_name => 'orders_tab',
policy_name => 'orders_policy',
function_schema => 'nisadmin_vpd',
policy_function => 'get_user_orders',
statement_types => 'select');
END;
/
After the creation of this policy for the table when I select the table Orders_tab then getting the below error.
ORA-00904: "ORA_ROWSCN": invalid identifier
When I dropped this policy then I can see the records of Order_tab table.
View 3 Replies
View Related
Jul 9, 2010
Does already installed Oracle 10g (10.2.0.1) on a windows 2003 server x64? Do you notice strange behaviors, any errors after the installation?
Does already installed Oracle 10g on a windows virtual machine? Are there any prerequisites?
View 9 Replies
View Related
Mar 27, 2013
I am configuring two node RAC on oracle virtual box. Did its mandatory to configure DNS on both nodes before Rac installation? Whats the purpose of DNS in RAC. And if its mandatory did i have to configure DNS on each node separately?
View 1 Replies
View Related
Oct 8, 2012
I have one production server with oracle 11g R2 DB. I have to change Server Hardware and thats why I have to install oracle 11g R2 DB on New hardware and test it. I had installed DB with software only option and copied the cold backup of production server. The hostname and ip address of both the servers are different. I had change the "db_domain" parameter into init.ora with the hostname.Now my question is that can the same db runs on the same network with different hosts. Change of "db_domain" parameter into the init.ora is enough or i have to follow some other procedure.
View 12 Replies
View Related
Jul 18, 2013
I have a Host system of windows 8, installed the Virtual Box Latest edition.The guest OS is the oracle Linux that came with the Pre-Built Developer VMs from Oracle.The VM is set to HOST ONLY network setting. Now, the thing is that i want to access the Oracle in the guest machine from my windows host machine.the guest OS shows the IP address as 192.168.56.101. I can ping the IP address from the HOST machine, but cannot connect theSQL developer to the oracle in the guest OS from the host machine. It keeps on saying the Network adapter cannot connect. do not say that install the oracle in window itself. I actually want to do the same on my macbook pro as that is my primary machine.
View 10 Replies
View Related
Sep 8, 2012
I created Virtual Private Network for VIP and subnet is 255.255.255.255. I need VPN subnet as 255.255.255.0. How to i create
INS-40911: Ensure that nodes in the list are up and reachable, and ensure that the node addresses are all in the same subnet.
View 2 Replies
View Related
Oct 27, 2012
Host: Win7
Guest: Using Virtual PC on Win7, created a VM using XP-Mode. Installed Oracle and everything on it. I can connect to the Oracle from within the guest env using sqlplus. Listener is also running, checked with 'lsnrctl status"
Guest and Host can ping (network) each other. I installed the guest using the Microsoft Loopback Adapter. Disabled the firewall on the guest OS before the host ping could work.
So ping works both ways from guest to host and host to guest. tnsping from host fails says "no listener". When I did a "telnet 192.168.x.x 1521" from host it said could not open connection on port 1521.
How do you open port 1521 on the guest OS to traffic from the host OS?
View 2 Replies
View Related
Mar 21, 2012
i have oel installed on my parallel Virtual machine.
i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.
my os is windows7 32 bit.
View 13 Replies
View Related
Aug 6, 2013
When trying to install Oracle Grid Infrastructure on Virtual Box RHL 5.5 (2.6.18-194.el5 kernel) machine it gives error.
Quote:$ Xlib:connection to ":0.0" refered by server
Xlib:No protocol specified
Exception in thread "main" java.lan.NoClassDefFoundError
at java.lan.Class.forName0(Native Method)
..........at oracle.install.ivw.crs.driver.CRSInstaller.main(CRSIntaller.java:103)
View 7 Replies
View Related
Jun 14, 2011
When we run a backup of a database [oracle7.3.4.5] using EBU [2.2.1.0.0] on Solaris 7, error message appears:
Statement processed.
BFS in progress "1134684df1de4a" cancelled on 10-JUN-2011 11:05:34
BFS in progress "1134694df1de4a" cancelled on 10-JUN-2011 11:05:35
Ending backup to tape
This backup spawns archive sequence numbers 1731 to 1731
This backup comprises SCN 8725981 to 8725802
EBU-2003: Job 24267 failed due to an internal error
on 10-JUN-2011 11:05:52 [ 7178 : brcdodbfil ]
[cod]....
In EBU catalog, are registered 2 databases with the same name but different hosts.
View 3 Replies
View Related
Jun 21, 2013
I am having issue with IMPDP on ORACLE VIRTUAL COLUMNS.I am having following table with Virtual column defined with Not null. Expdp is fine without any issue.
DDL :
------
CREATE TABLE alert_hist
(
alertky INTEGER NOT NULL,
alertcreatedttm TIMESTAMP(6) DEFAULT systimestamp NOT NULL,
alertcreatedt DATE GENERATED ALWAYS AS (To_date(Trunc("alertcreatedttm"))) VIRTUAL NOT NULL
When I do the import (IMPDP) it got failed with the following error.
. . imported "TESTSCHEMA"."VALART" 359.1 KB 4536 rows
ORA-31693: Table data object "TESTSCHEMA"."ALERT_HIST" failed to load/unload and is being skipped due to error:
ORA-39097: Data Pump job encountered unexpected error -1
After that I dropped the Virtual Not null column and recreated that column with Nullable.
DDL :
-----
alter table alert_hist drop column alertcreatedt;
alter table alert_hist add alertcreatedt DATE GENERATED ALWAYS AS (To_date(Trunc("alertcreatedttm"))) VIRTUAL;
After that I took the expdp and impdp , it went fine with out any issue.
View 7 Replies
View Related
Oct 31, 2013
I have an issue during the database configuration using DBCA at 85% it blocs, then it displays an error asking to reconfigure ORACLE_UNQNAME.
View 6 Replies
View Related
Jul 26, 2013
In my Organization I am trying to install oracle ODTwithODAC112030 but one Error showing that is java virtual machine could not find main class program will Exit.
Server Configuration Dell power Edge r510 Windows 2003 64 bit serv PAck 2 Citrix Presentation server 4.5 .
View 1 Replies
View Related
Feb 18, 2013
My production database server is cloned for test environnement . I kept the same name of SID for both environnement but on different hosts.
I got error when try to connect to test database : TNS:protocol adapter error.
Below the the TNSNAMES.ORA files:
----- production host ---
HOFL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol)(PORT = 1521))
[Code].....
View 10 Replies
View Related
Dec 25, 2012
I have already created an active standby pair(without cache group) and managed by Oracle Clusterware and it work fine.
Now ,I create another DSN and I also want to create another active standby pair on the same 2 hosts.
I try to setup and reference this setting:
[URL]...
But I get error message in ttcwmessage :
TT17013 The default hostname cannot be set to host_name because a local host of host_name is currently in use
Is it possible that I can create more than one A/S pair(with different DSN) ? Or any other solution? !
TimesTen version:11.2.2.3.3 (64 bit Linux/x86_64)
View 5 Replies
View Related
May 22, 2011
I have exported and imported a schema from one server to another. In the source schema, I have a public synonym. I do not know the name of that synonym. In the destination schema, the public synonym is missing. How to create the public synonym which is missing in the destination database? In the source, I queried dba_synonyms, all_synonyms... but it returns no rows selected.
View 2 Replies
View Related
Feb 15, 2013
I am able to create view and the public synonym with the same name but when I am quering view result is showing .
Is there any logic behind this .
CREATE OR REPLACE VIEW emp_dtls as SELECT * FROM emp;
CREATE PUBLIC synonym emp_dtls for emp;
SELECT * FROM emp_dtls;
view result is showing
View 3 Replies
View Related
Apr 15, 2013
how to make the complete schema public synonym, instead of creating public synonym object by object.
View 2 Replies
View Related
Sep 4, 2012
As far as I know, in APEX 4.0 no other user other than the one who created a Public report can delete it. Can this behavior be changed somehow?
View 3 Replies
View Related
Jul 9, 2011
grant insert,update,delete,select on staging_tb1 to public;
What is public here? i know something about public user like it is users exist in the database .
View 5 Replies
View Related
Aug 12, 2011
I am using oracle 8i and need to read data from teradata using public link and views.
View 4 Replies
View Related
Aug 25, 2012
differences of enabling thread as public or private?
lets assume that i have two threads (1, 2) for two instances (1, 2) and each of thread consists of 2 redolog groups - minimum configuration.in case i need add third node i need third thread.
what will be difference if i set this thread as public instead private?
View 7 Replies
View Related
