Cannot Connect To Oracle Running Under A Virtual-PC XP Mode Guest
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
ADVERTISEMENT
Mar 8, 2011
I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don't know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.I have heard about oracle Heterogeneous Connectivity but don't know exactly how to implement it in Unix environment.
View 1 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
Jan 22, 2011
I have installed Oracle 10g in Windows XP which is in 'VMware' as guest OS. share the procedure if we can connect to the oracle installed in Guest OS from the main operating system.
Main OS is Windows 7
Guest OS is Windows XP
View 2 Replies
View Related
Aug 24, 2011
changing archive mode during DB running.Before in 9.2, 'ALTER SYSTEM ARCHIVE LOG START/STOP' is available for this job. But, after 10g/11g, it cause 'archive log stop has been deprecated'.
However, for my practice, I need to estimate archived logs size before backup them, so I need to stop archive log for a while and enable it later during DB running.
I check Oracle documents, it only mentions changing archive log mode at DB mounted but not open.
View 12 Replies
View Related
Jan 27, 2012
I'm trying to run dbca in silent mode and works perfect, this is how the code look like:
dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbName test.mydomain -sid test
-sysPassword passoracle -systemPassword passoracle -emConfiguration LOCAL -dbsnmpPassword passoracle
-sysmanPassword passoracle -characterSet WE8ISO8859P1
-initParams "open_cursors=500"
The problem is when I specify more than one initialization parameter in -initParams. If I try something like
-initParams "open_cursors=500, parallel_max_server=0"
Then I get this error Exception in thread "main".
View 3 Replies
View Related
Jun 7, 2013
I am trying to install Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox/Mac OS.But getting problem to set network & ip setting and yum is not able to reach oracle repository.
if anyone tried installing Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox on intel based Mac OS.
View 0 Replies
View Related
Jun 4, 2013
We have the Oracle 11g XE database installed on a Windows 7 laptop. The Oracle XE database runs fine when the laptop not connected to a network, when connected to our corporate lan, or when connected to a cable-modem. However, when running under the Cisco AnyConnect VPN client, we are unable to connect to the Oracle XE service.
I have tried to resolve this, but am stuck. I do not if this issues is caused by:
1. There is no IPv6 address listed for the AnyConnect VPN (from ipconfig /all)?
2. Something regarding split-tunnelling that must be configured on the VPN?
3. Can the Oracle XE database run under an SSL VPN?
Below is the output of when I try to connect the Oracle XE service via sqlplus.
**************************
The OracleXETNSListener service is starting.
The OracleXETNSListener service was started successfully.
The OracleServiceXE service is starting..............
The OracleServiceXE service was started successfully.
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>sqlplus system/password@XE
SQL*Plus: Release 11.2.0.2.0 Production on Fri May 31 07:03:24 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12546: TNS:permission denied
Enter user-name:
**************************
listeneralertlog,xml
<msg time='2013-05-31T07:03:24.950-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DEV-M-137GF'
host_addr='fe80::2884:a03d:5286:7996%21'>
<txt>31-MAY-2013 07:03:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:ProgramDataoraclexeapporacleproduct11.2.0serverinsqlplus.exe)(HOST=DEV-M-137GF)(USER=ptavolet))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.99.8.39)(PORT=56324)) * establish * XE * 12514
[code].........
**************************
listener racelistener.log file
Started with pid=3688
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV-M-137GF.paychex.com)(PORT=1521)))
[code]......
**************************
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:07:43
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 31-MAY-2013 07:01:12
Uptime 0 days 0 hr. 6 min. 31 sec
[code].......
The command completed successfully
**************************
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>lsnrctl service
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:08:13
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
View 4 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
Aug 17, 2010
I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.
View 1 Replies
View Related
Oct 6, 2010
I have the following computer/setup:
Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)
I cannot can't to the Oracle database from Delphi. The error I keep getting is:
Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.
Here's what I've done:
1. Create an ODBC connection to my Oracle database
- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.
2. Open Delphi and drop a TDatabase component on my main form.
- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".
Alternatively, I tried using the Delphi ADO components (the dbGo components).
- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".
Again the same error.
My questions are:
1. Can Delphi work with Oracle XE (Express Edition)?
2. If so, then do I need to install the "Instant Client"?
3. Will the instant client for Oracle 10g work with Oracle 10g XE?
4. Do I need to install any additional ODBC driver(s)?
5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?
6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?
View 2 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
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
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
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 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
Oct 29, 2012
I have to install oracle 11g R2 on AIX. but I need to install from putty I have configured cygwin Xwindow. able to get GUI from my local VMware linux server but unable to get GUI for remote servers.
and followed the same process as I did for my local vmware linux box. How to get the GUI for remote servers as well. If it not possible or any configuration needs to be done at remote site.
View 5 Replies
View Related
Mar 16, 2011
I am running oracle Apps 11.5.10.2, trying to enable duplex printing for all PDF / XML reports.
View 1 Replies
View Related
Jul 12, 2012
I am using oracle 10g. Is there any mechanism to / parameter to enable or disable archive log mode? can I enable arching directly from pfile without touching the startup process?
View 2 Replies
View Related
Jun 30, 2008
I'm trying to create a physical standby database on my Oracle9i DB runing on WinXP.
Note: I have both Primary and Standby on the same system.
Actually everything went well .... I did created the standby DB but the problem is I can not start my primary DB if my standby DB is mounted. I get this error:
ORA-01102: cannot mount database in EXCLUSIVE mode
And when I read about the error message I learnt that I should start my DB in compatible mode ...
View 5 Replies
View Related
Jul 9, 2013
The customer wants the RMAN recovery catalog database to be highly available so that none of the RMAN database backup jobs are impacted at the time of taking the database backups. There are are 200+ databases running on OEL, RHEL and Windows. So we planned to host the recovery catalog database on Oracle Active DataGuard 11.2.0.1 Enterprise Edition on RedHat EL 5.8 version on two physical servers.
The Primary Instance will be in one server in the Primary DC and the Standby Instance will be on another server in another DC. Also all the database datafiles are hosted in ASM Diskgroups on SAN (DATA, FRA, REDO, ARCH diskgroups). Are there any specific RPM/patch/OS user custom/specific settings or configurations needed..?
View 5 Replies
View Related
Jun 6, 2012
I have installed an Express edition of Oracle 11 database on one host (Windows 7) and want to access to from another host (Backtrack Linux based on Debian) from SQL*PLUS Instant client.
While I managed to resolve multiple issues with shared libraries, I am still not able to run the sqlplus command as Oracle. I get the following errors:
oracle@evil:~/instantclient$ sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
I followed the installation manual by Oracle and also created Oracle user with 2 env. variables set to:
LD_LIBRARY_PATH=/opt/Oracle/instantclient/lib
ORACLE_HOME=/opt/Oracle
Note that I only installed SQPLUS client on Linux and there is no DB running. The version of sqlplus is 11.2.0.3.0
On different forums people advised to set other variables according to the DB installed but I have none. All I want is to run sqlplus with the IP address, SID, port and username. Is it feasible to have only SQL*PLUS client installed .
View 1 Replies
View Related
Nov 1, 2010
I have Oracle 11g R2 (11.2.0.1) with Oracle EM running on Solaris 10 with ZFS.When I start OEM it comes up and tells me that the listener is running but that the DB instance is down and agents are down.I know that the instance is up because I can start it manually.
Each time I start emctl, lsnrctl and DB manually everything starts running but OEM returns a failure for the DB. long as the display shows the DB not running OEM won't allow me to work in it.Instead of getting the login page I get the Database Control Page stating that "Enterprise Manager is not able to connect to the Database instance."I have tried the various emca -config dbcontrol db -repos drop and recreate but no luck.
Is there a way to uninstall/reinstall without dropping the DB?Are there control/configuration files I may hack to tell OEM the correct information?
View 3 Replies
View Related
Feb 18, 2013
I am using oralce 10g database,because of performance hit in my database in want to generate AWR and STATSPACK reports.
I have already generated AWR report by running awrrpt.sql script.
I just wanted to know the steps to run STATSPACK reports.Will it create the same file as AWR does. Will i get much advantage after running STATSPACK reports than AWR.
View 8 Replies
View Related
