Virtual Host Name Must Be Static And Resolvable Consistently On Network
Apr 2, 2013
10g
SLES 11
Oracle® Enterprise Manager Grid Control Installation and Configuration Guide
10g Release 5 (10.2.0.5.0)
Part Number E10953-1518 Configuring Enterprise Manager for Active and Passive Environments18.1 Using Virtual Host Names for Active and Passive High Availability Environments in Enterprise Manager Database ControlSet Up the Alias for the Virtual Host Name and Virtual IP Address
You can set up the alias for the virtual host name and virtual IP address by either allowing the clusterware to set it up automatically or by setting it up manually before installation and startup of Oracle services. The virtual host name must be static and resolvable consistently on the network. All nodes participating in the setup must resolve the virtual IP address to the same host name. Standard TCP tools similar to nslookup and traceroute commands can be used to verify the set up.
View 21 Replies
ADVERTISEMENT
Dec 22, 2010
How to get a RAC running in an EC2 environment?
It isn't possible to use one EC2 machine for each RAC node because EC2 can't handle the virtual IPs, but I had thought that I could use one EC2 machine to host several Linux VMs using Virtual Box (the same way that I use Virtual Box on a Windows host). But I can't get Virtual Box working on EC2. The only relevant advice I can find on this is comments to the effect that running any virtualization product with a Xen machine as host is not a good idea.
I do realize that this isn't a 100% Oracle question, but if set up a RAC on an Amazon Cloud machine,
View 1 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
Oct 3, 2013
I am using the HOST command within Oracle Forms 10g on Windows server to copy a pdf file from the application server to a network folder on another Windows server.
The command works fine if I logon to Windows app server and type it. But it doesn't work when it is launched within Oracle forms using HOST. The command looks as follow
net use \\FileServer\e-file /user:usergroup\username password & copy D:\RepTmp\myReport.pdf \\FileServer\e-file\test\myReport.pdf
Oracle forms doesn't give any error message at all but the pdf file never gets there. Even when I map the network folder as "R:" drive on the Windows app server, a simple copy command like this does not work with HOST:
copy D:\RepTmp\myReport.pdf r:\test\myReport.pdf
Oracle Forms server is running as "SYSTEM" on the Windows server. If HOST won't work, is there any other way to copy the file other than using fpt?
View 1 Replies
View Related
Aug 25, 2011
I take a backup on PROD and want to use that backup on test to duplicate the PROD db.I ran this first on PROD:
catalog rman11cv/password@metarep
connect target /
RUN
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'G:
estore\%U';
BACKUP DATABASE PLUS ARCHIVELOG;
I runs fine.map the network drive on my TEST machine. I run the script:
connect target sys/password@pdm;
connect auxiliary /;
run {
allocate auxiliary channel 'ch1' type disk;
SET NEWNAME FOR DATAFILE 1 TO 'D:oracleoradatadatabasedataSYSTEM01.DBF';
SET NEWNAME FOR DATAFILE 2 TO 'D:oracleoradatadatabasedataUNDOTBS01.DBF';
SET NEWNAME FOR DATAFILE 3 TO 'D:oracleoradatadatabasedataCWMLITE01.DBF';
[code]....
Its trying to read from the right backupset.But Im not sure it can see it:
channel ch1: reading from backup piece G:RESTOREN3MKSOMQ_1_1
ORA-19870: error reading backup piece G:RESTOREN3MKSOMQ_1_1
ORA-19505: failed to identify file "G:RESTOREN3MKSOMQ_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.failover to previous backup
Net view of the PROD host gives this:
D:oracleadminduplicatePDMTEST>net view myprod
Shared resources at myprod
Share name Type Used as Comment
------------------------------------------------------
restore Disk G:
The command completed successfully.
View 8 Replies
View Related
Dec 11, 2012
Static Tables Creation In oracle & Diff Between Static table ,Dynamic table
View 2 Replies
View Related
May 10, 2011
Can we declare static variable in Oracle 9i.
View 2 Replies
View Related
Jun 4, 2011
how to use static ip address in oracle 10g.
View 5 Replies
View Related
Jun 4, 2011
i got static ip from witribe a broadband company in pakistan i am trying to connect database from client side computer who connect with internet when i ping my server it reply with good speed but when i try to connect database the message appear (Unable to connect Destination) but it works very well with Local Area Network computers. More how can we change port 1521 in client sides
View 6 Replies
View Related
Jun 11, 2013
what configurations I do the static listener shows no services.Here is my listener.ora
:SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME=ELLISON9) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=ELLISON9) ) ) LISTENER11G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora1)(PORT = 1522)) )ADR_BASE_LISTENER = /u01/app/oracle My tnsnames.ora:ELLISON9 =
[code]...
View 13 Replies
View Related
Oct 22, 2004
I am using Reports6i. I want to know how to show the image on the report but the image is not in static filename.
I used "Link File", but the "Source Filename" Boilerplate can only allow me hardcode the file path and file name.
Remark: The image is not stored in the database.
View 4 Replies
View Related
Jul 4, 2011
I am using oracle 9i release 2 and forms 6i.I have a question,I have stored all the fmx files under one folder in a single server called "MAINSERVER".From here only client system calls the forms.In am calling forms in call_form function like
call_form('\MAINSERVERFORMSemployee.fmx',no_hide);
here mainserver is the server name, forms is the folder name and employee is the form name in fmx format.My question is when i call form from server with in a network no problem but When i call form from outside lan that through internet via static ip forms are not called.I tried like this way call_form('\198.52.67.66FORMSemployee.fmx',no_hide).Here i have specified static ip and forms folder but is not working.
View 7 Replies
View Related
Jan 7, 2013
I am trying to only display a column value one time for a record, not a static value. The value changes and there can be many values. I do not think grouping will work since the Date value is dynamic. I am using Oracle for Toad 10.5. There are 4 records with this test data.
select Date, Person, Language, Country
from TableATableA
Date Person Language Country
01/25/2013 James English
12/20/2012 James English
US
[code]....
View 3 Replies
View Related
Jun 8, 2012
We recently updated to version 4.1.1.00.23, and need to do an export of our static files to migrate from our development to test (ApEx run-time) platform. When our DBA attempted to run the export script (we had renamed it from static_file.sql to browser_detect.sql), he received this error:
SQL> @browser_detect.sql
Set Credentials...
Check Compatibility...
Set Application ID...
...static file repository
p_notes=> '');
*
ERROR at line 14:
ORA-06550: line 14, column 5:
PLS-00103: Encountered the symbol "P_NOTES"
when expecting one of the following:
. ( ) , * % & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "(" was substituted for "P_NOTES" to continue.
ORA-06550: line 14, column 18:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
. ( ) , * % & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset
We took a look at static_file.sql, and noticed this:
declare
l_name varchar2(255);
l_html_id number := null;
begin
l_name := 'browser_detect.js';
wwv_flow_html_api.remove_html(
[code].......
The comma is missing after the p_flow_id parameter. This appears to be a bug in the export. It appears to be happening pretty consistently (other static files for this application, other static files for other existing applications).
I did a search of the forum to see if this issue reported this and checked listing on OTN and I don't see any reference to this particular issue. We're hesitant to just add the comma right now since we don't know whether there may be any other issues in the file it's generating.
View 6 Replies
View Related
Feb 6, 2013
understanding where to store the static SQL code (Database or Application).Consider a scenario, that I am executing a simple SQL from Java which is returning some value, and it will not be changed in future.
should I store this sql in java application code or in database in form of procedure/function and returning the result to Java. Is there any security/performance impact?
View 3 Replies
View Related
Nov 17, 2011
I have created two database one for production and another one for test.I created both database in shared_server mode(by using dbca),after than I did not change anything.My problem is when i connect to test database from outside lan through static ip its working well,but when i connect to production database which is not connected. I checked and compared two databases,then I find there are some changes in dispatcher and mts_ dispatcher parameters.And I used this query to check the shared_server status,
ie.select * from v$shared_server,
the output of this query is attached with this post.
View 8 Replies
View Related
Jul 20, 2012
I have to display a 24 hours time as an index. (00:00 - 23:00) That is easy, if the data exists.
But, if the data is not regularly exists on specific hour (the time/hours is not regular, i.e: 00:00, 01:00, 05:00, 08:00, 10:00, 11:00, 23:00), then it is OK for a TABLE, but not for a CHART.
Here is the story:
I wrote an SQL statement that can "choose" what to display respectively to the the available time. The result will be displayed on the chart: Days or Time is used for X-Axis, and the respective Value on the Y-Axis.
Example:
+ if the data consists of "days" (i.e: the last 5 days from now, 16/07/2012, 17/07/2012, 18/07/2012, 19/07/2012, 20/07/2012), then the chart will show those dates on the X-Axis.
+ if the data consists of "hours" (i.e: 1 single day, from 00:00 hour - 23:00), then the chart shows hours on the X-Axis.
If the 'hours' are not regular, means: there is no data on specific hours, the query result is also not regular, means: the X-Axis-value 'jumps' irregularly.
Question:
Is it possible to query our own static value?
for example:
select 'hello' from dual --> result: "hello", 1 column, 1 row
But how to display this in multiple rows, i.e.:
Time
*****
0
1
2
3
4
5
...
...
23
Note: the X-Axis on the chart template can be only customized for 1 single mode, example: "Days", but of course it is not going to show up properly if the query result are in "Hours". It means: I have to find the workaround on the SQL Query.
DB: ORA 11
View 9 Replies
View Related
Sep 6, 2011
I had a query related to call_form function in forms 6i.How can I call a particular form via static ip(outside LAN),but the actual forms are stored in a server called "MAIN_SERVER" which resides in internal LAN domain.That is I have stored location of all my forms path(fmx)in my database table called "FORMS_LOCATION" in the MAIN_SERVER system under the directory "FORMS".From here only users can call all the forms by call_form function.To understand see the example below,
In the table FORMS_LOCATION,there is a column call "forms_path" which holds the value like,
//MAIN_SERVER/FORMS/EMPLOYEE.FMX;
(server_name,foldername,form_name)
In application the call_form just uses the column "forms_path" to call the form.like CALL_FORM("forms_path",no_hide) this statement will call the form from the main_server.
Here 1.MAIN_SERVER is the name of the server system where forms fmx is actually stored under the folder name "FORMS".When the users access the particular form the call_form function call the form from the MAIN_SERVER.Now there are no problem inside the LAN.Incase if I access the database and call the form outside LAN via internet through STATIC IP what happened was database was connected but call_form function failed and not calling the form because which does not know the MAIN_SERVER/FORMS/ path.
Because my user want to access the form outside lan via internet,so I tried replacing the above statement like //192.54.67.98/FORMS/EMPLOYEE.FMX' with static ip in the prefix instead of local server called MAIN_SERVER.But its not working again.How can I do this?.
View 1 Replies
View Related
Oct 1, 2012
I would like to convert some existing application popup LOV items that currently use a static list for the LOV values.I have not been able to find instructions on how to use the existing popup static list (or create a new static list) with the new SuperLOV plug-in. Is this possible to do?
If an example or instructions are available, a link to these.
View 3 Replies
View Related
Sep 3, 2012
I am running a two node rac on grid 11.2 and db 11.2.0.3. My application does not like the scan listener, therefore I have to configure the remote listener parameter to the vips of the two hosts, which is working fine.
But it comes out the the system needs the service registered with the scan listener. So. How can I add a static service entry for my scan listener ?
View 7 Replies
View Related
Dec 31, 2012
Version oracle 11g
Is there a way to avoid multiple UNION statements and get statitc values in single SQL?
select 'Week1' as term from dual
UNION
select 'Week2' as term from dual
UNION
....
....Some functionality like selecting from dynamic table column-rows.... like .. "select term from table(term(rowvalues('Week1', 'Week2'...'Week5')) from dual" or something like that
View 4 Replies
View Related
Apr 17, 2013
After Upgrading to Apex 4.2
When uploading a static text/javascript file (i.e. filename = 'thisFile.js') the file Mime Type defaults to 'application/octet-stream' (instead of 'text/javascript'). This issue occurs in I.E. 8 but not in Firefox.
View 0 Replies
View Related
Aug 19, 2013
I m migrating from 10g to 11g.I have doubt on virtual column.whether function based index and virtual column are same? if no means what difference between then.What are difference in their performance??
View 5 Replies
View Related
Sep 27, 2013
Im getting this error when trying to connect toad to my test database using virtualbox. This is my first time trying to do this on a Mac as well:
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
The settings in toad are correct as far as host, port #, and sid. My listener is up, and it is registered with the database. My tnsnames.ora file is correct. No firewall. I can ping my virtualbox from my local machine. I placed my tnsnames.ora file on my local machine, and tried to connect that way as well. I have no clue what else the Network adapter is looking for.
View 1 Replies
View Related
Feb 5, 2013
I have a new laptop with windows 8 installed. I tried installing Oracle Virtual Box. But I am unable to install OEL on top of that. How to do installations on Windows 8. If so, what are the compatible versions of OEL and Virtual Box?
View 2 Replies
View Related
Sep 1, 2010
I work as a Sys. Admin. for several RHEL 3.8 servers, most of them are clusters of 2 machines. All these servers are running Oracle 9.2.0.7 database. They are running fine on a separate filesystem. So everytime the system has to be formatted for some particular reason, there is no need to re-install the database.
I am trying to make some tests by running the same filesystem containing the oracle database in a fresh Red Hat Enterprise Linux 4.8 X86_64 Install. This task has become impossible, and I'm not quite sure why.
I installed all the compat- packages required for a fresh oracle 9 install in a RHEL4 machine, but at the time of stating the STARTUP sentence, it gives me the next error:
CMCLI ERROR: OpenCommPort: connect failed with error 2.
CMCLI ERROR: OpenCommPort: connect failed with error 2.
CMCLI ERROR: OpenCommPort: connect failed with error 2.
CMCLI ERROR: OpenCommPort: connect failed with error 2.
CMCLI ERROR: OpenCommPort: connect failed with error 2.
After this error (repeated) it says something like: Cannot start an already running database.... But if i stat a shutdown sentence, it says that the instance has not been initialized....
I don't know whether i have to re-install all the oracle software in order to make a clean install in the new kernel version or not, i tried to apply a patch, and the oracle installer recognized the installation i had.
I think it might be because the original system is configured to work as a cluster, and i'm running it on only a virtual machine.
View 6 Replies
View Related
Nov 23, 2011
Does know why I am getting ORA-01733- virtual column not allowed here Following :
CREATE TABLE EMPL
(
EMP_ID NUMBER(10),
CNT NUMBER(10)
)
insert into empl(EMP_ID)
values(1)
[code]....
ORA-01733- virtual column not allowed here
View 33 Replies
View Related
Jul 3, 2012
I have a Windows 2008 R2 SP1 2 node active/passive cluster with fail safe 3.4.2 installed. I also have 11G database software installed. My problem is I am unable to successsfully add an oracle virtual IP to the oracle group within fail safe. I receive the below error when I try. I need to get this resolved so that I can add my databases to the cluster.
Oracle Fail Safe Manager
FS-10890: Oracle Services for MSCS failed during the create operation
FS-11220: Failed to create the virtual address
FS-10012: Failed to bring the cluster resource Network Name HHVHAVELP01 online. Check the Windows event log for messages.
FS-10726: Resource Network Name HHVHAVELP01 is in a failed state
I don't see any message in the event log when I check...
View 2 Replies
View Related
May 17, 2011
what my issue is with this virtual column
CREATE TABLE C0HARPA.VCOL_TAB
(
col1 VARCHAR2(30 BYTE),
v_col1 VARCHAR2(6) GENERATED ALWAYS AS (SUBSTR(col1,1,6)) VIRTUAL
)
TABLESPACE TOOLS
[code]...
Lastly, can an index be created on a virtual column? I am thinking no since it calculated?
View 3 Replies
View Related
Aug 25, 2012
I am having one table Where,different country names are stored. while viewing data, I have to make sure that if country name having "USA" can only view its data. How can i do at DB level without passing where clause. Is Virtual Database in this case?
View 25 Replies
View Related
