Oracle Connection Manager
Apr 30, 2013
I've a problem with Oracle Connection Manager and I've read the Oracle topic about it at URL.....but it doesn't work well...This is an image describes the diagram I want to configure URL.....
The IP for each machine is
Database Server : 192.168.0.150
Proxy Server : 192.168.0.153
client : 192.168.0.159
And these are the files for each machine.
1.Proxy server has 1 file
cman.ora
CMAN=
(CONFIGURATION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.153)(PORT=1521))
(RULE_LIST=
[code]....
2.Database server has 3 file, and for each one I've added some lines as following
tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
[code].....
3.Finally the client has 2 files
tnsnames.ora
orcl=
(DESCRIPTION=
(SOURCE_ROUTE=YES)
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.153)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.150)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
[code]....
ORA-12154: could not resolve the connect identifier specified: where I actually define my DB service (orcl) in the tnsname.ora...The output is showen here URL.....
View 1 Replies
ADVERTISEMENT
Dec 4, 2011
I was trying to connect to a remote database from my client machine. Client machine runs a jsp code to connect to the database and execute a query. I have got oracle jdbc on my machine but still unable to connect to the database.
When checked in Google, i found that oracle connection manager has to be used to connect to the database from jdbc if the web server and database reside on different physical servers. But couldn't gather any further information regarding download and installation.
I do not have oracle connection manager on my system. I read in internet that it is shipped along with oracle 11g software. But i am not sure if that was the case in earlier version as well.
My question is where should i install oracle connection manager? (on database server or client machine) and is it possible to download and install only the connection manager as a stand alone so that i can connect to database from application?
View 3 Replies
View Related
Apr 5, 2011
I am trying to connect my oracle server with enterprise manager. But i have no network connection. What will be the probable listener config. ?
View 2 Replies
View Related
Apr 3, 2013
I've tried to configure Connection Manager but i fails on TNS-04012: Unable to start Oracle Connection Manager instanceThis is my configuration (
CMAN1=(CONFIGURATION=
(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1522))
(RULE_LIST=
(RULE=(SRC=*)(DST=<IP>)(SRV=*)(ACT=accept))))
[code]...
View 3 Replies
View Related
Oct 16, 2012
I am facing a problem with my oracle 10g enterprise manager. It is working properly with 64 bit windows 7 os with internet connection. without internet connection i cant start start the enterprise manager how can i resolve the issue and start the enterprise manager without internet.
View 12 Replies
View Related
Feb 25, 2011
I am trying to create a secure connection and getting the following error. I have tested the password via sqlplus and it works just fine.
oracle[/u01/app/oracle] emctl config emkey -repos -sysman_pwd
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
enter repository password..Invalid Password caught Exception java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
View 2 Replies
View Related
Sep 14, 2013
I have configured OEM and is up and running but, I am getting below error message when open the OEM URL.
Error Message:
Secure Connection Failed / an error occurred during a connection to rhel6:1158.
The page you are trying to view can not be shown because the authenticity of the received data could not be verified.
View 2 Replies
View Related
Mar 12, 2009
I have installed Oracle 10g database on my laptop. and when i login into Enterprise Manager I get the java error: "java.lang.Exception: IOException in sending Request :: Connection refused in the header of the homepage".
View 6 Replies
View Related
Sep 30, 2012
how to duplicate it on oracle 11g xe windows 2003
i have read from documentation but getting some error.
in last
E:Documents and SettingsAdministrator>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 30 03:03:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect auxiliary sys/12
connected to auxiliary database: XE (not mounted)
RMAN>
RMAN> DUPLICATE DATABASE TO xe
[code]...
Backup-Based Duplication Without a Target and a Recovery Catalog Connection?
View 6 Replies
View Related
Feb 2, 2010
We have the Oracle Enterprise Manager Grid Control 10.2.0.5. We recently upgraded our Databases from 10.2.0.3 to 10.2.0.4 and since then we are having this problem.
Whenever i click an Agent on the Grid Control it gives me this error: "Communication between the Oracle Management Service host to the Agent host is unavailable. Any functions or displayed information requiring this communication link will be unavailable. For example: deleting/configuring/adding targets, uploading metric data, or displaying Agent home page information such as Agent to Management Service Response Time (ms)."
I get the same error when i try to configure a host or a database.
Don't know what is wrong
View 4 Replies
View Related
Dec 25, 2010
I have installed ORACLE 11g on RHEL-4, where the RHEL is installed on VM.ORACLE is working fine on RHEL but i am not able to connect oracle on my XP.
View 1 Replies
View Related
Jul 15, 2013
How to connect to database with windows authentication:
OS system: 2008 R2 windows
oracle : 11.2.0.3
sqlnet.ora set to NTS.
also user is created on database externally "domain/username"
i want to connect to the database with my windows account!
View 4 Replies
View Related
Jun 22, 2012
How do i test if a OracleConnection came from the pool or was created for the first time?
View 2 Replies
View Related
Jun 8, 2011
I´m just having a problem whit the connection between Oracle Forms 6i and Oracle Database 11G. Is just when i login to the database schema i cant log in using Forms.
TNS Names its already configured, No problems when i log in using Toad and using the TNS Names from Developer's 6i tool. I can log in just when i change the schema(user) password from the database (thats the rarest thing) and log into the application.
So whenever i want to login to the application i must to change the schema password, i need to use it directly.
View 2 Replies
View Related
Jan 11, 2013
I have an application in VB6 that connects to an Oracle Database 10g with Oracle native ole db but win7 can not make the connection with a standard user, only makes the connection to a user with administrator permissions. The error that shows the application's rubbish eg @, H, etc.. only rare characters.
View 7 Replies
View Related
May 20, 2013
error regarding oracle connection
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oradb As String = "Data Source=CallTaxi; UserName = SCOTT; Password=TIGER ;"
Dim conn As New OracleConnection(oradb)
conn.Open()
Dim cmd As New OracleCommand
[code]...
Error msg:
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.
View 1 Replies
View Related
Aug 8, 2011
Toady i have installed oracle forms 10g and oracle 10g db when i run my form it gives me this error how can i resolve it
"ora-12154 tns could not resolve the connect identifier specified"
View the image below:
Here are the values in forms 10g tns
# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[code].......
and here the values of forms 10g SQLnet
# sqlnet.ora Network Configuration File: C:DevSuiteHome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
(description =
# (address=(protocol=tcp)(host=localhost)(port=1383))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(connect_data=(rpc=on))
)
What changes should i make to overcome this problem.
View 1 Replies
View Related
Feb 6, 2013
what's long connection and short connection in Oracle ?
View 4 Replies
View Related
Jun 23, 2012
I'm having great difficulty connecting to two separate databases on my PC. Here are the details.
c:>echo %TNS_ADMIN%
C:TNS_ADMIN
#C:TNS_ADMIN nsnames.ora
XE =
(DESCRIPTION =
[code]...
View 22 Replies
View Related
Aug 26, 2010
I have a client program that needs to communicate with another server program. My client program is implemented in PL/SQL using utl_tcp running on Oracle 9 while the server program is a 3rd party software running on Windows server 2003.
Basically my client program needs to send a request to the server, waits for the response (wait for the incoming string which ended /w chr(3) ) and then acknowledge (sending chr(6) ).
My problem is that if I wait for the chr(3) and then acknowledge. My send routine (l_sent := utl_tcp.write_text (g_conn, p_content) will raise a Oracle generic network error. It seems like the connection is closed. I checked /w the vendor and they said it might be I am taking too long to response ( I question timeout is the problem). I have also attempted to change my read routine from read_line to read_raw but it only make things worst. I cannot even read the complete string. At least with read_line, I can read back the entire string.
My current work around is to send out the ack before I receive the chr(3) (which is not recommended by our vendor).
View 5 Replies
View Related
Mar 2, 2011
I am using dg4msql to connect to SQL server from Oracle(10.2.0.4, with AIX 5.3).
#from my laptop sqlplus (10.2.0.2)
SQL>select count(*) from table1@mssql; #works
SQL>select * from table1@mssql; #ERROR
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation
{01004}[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}
#from my laptop, TOAD
Both queries works fine.
i have compared
"select * from nls_session_parameters;" values , TOAD and sqlpus gives same result.
View 3 Replies
View Related
Apr 26, 2010
I have Multi-threaded application using pro*c to connect to oracle.
I am using the following piece of code to create a connection to oracle database and preserver the context of created connection.
struct sqlca * tempSqlca = new sqlca;
struct sqlca & sqlca = * tempSqlca;
EXEC SQL BEGIN DECLARE SECTION;
SQL_CONTEXT localContext;
[code].....
I am using the following piece of code to close the connection to the oracle database, I am using the context created in the previous step and passing it to the below code(connection.context)to release the connection.
if (connection.context == 0 || connection.ca == 0)
return true;
// Multithreading: get the communication area of the context
struct sqlca & sqlca = *(connection.ca);
EXEC SQL BEGIN DECLARE SECTION;
[code].....
When the above code is executed there is no exception thrown but the connection is not getting close. I am using the V$SESSION system views to monitor the connection created.
I there anything I am missing in my code for the connection closing to fail.
View 1 Replies
View Related
Feb 1, 2011
I have installed Oracle 11g R1 and have problem in connecting Oracle SQL Developer.
I have given user name: ora; pswd: ora.
In command prompt it works fine if I gave as below.
uid: ora as sysdba
pswd: ora
But when I am trying to connect to Oracle SQL Developer it says TNS listener does not know SID.
So I reinstalled this since i have doubt on myself whether I made mistake first time. Also I have doubt whether the un installation completely clears all the files from Registry. - What should I do to clear all the files from registry when un-installing.
1] What is SID. Is it session ID. If so how to find it.
2] Is there any way to confirm the values such HOST NAME: localhost, PORT: 1521, SID: (By default it has 'xe') which I gave for data base connection are correct.
I tried with SID value:135 (I got this value by executing [Select distinct sid from V$mystat;])
3] Is there any editor for practicing sql & pl sql queries. where I can download it.
View 6 Replies
View Related
Jul 15, 2013
I have been using oracle based database security but company now wants to handle with windows authentication.I have windows os 2008 R2 and oracle 11.2.0.3.
I also have set up the SQLNET.AUTHENTICATION_SERVICES= (NTS).I created user with create user "domainusername" identified Externally! but now how can i connection from application to database!
View 1 Replies
View Related
Oct 18, 2012
i have a Windows Forms .Net 2.0 App which defines AppDomain.CurrentDomain.UnhandledException handler.When an app thread throws an exception this exception is caught or handled by this method.
The problem is that if i define an OracleConnection, open and close it and then the thread throws the exception this is not handled and app finishes...
Why i can't handled this threads exceptions if i use OracleConnection?
Here is the simple app code example:
program.cs
[STAThread]
static void Main()
{
AppDomain.CurrentDomain.UnhandledException += CurrentDomain_UnhandledException;
Application.ThreadException += Application_ThreadException;
Application.SetUnhandledExceptionMode(UnhandledExceptionMode.ThrowException);
[code].....
View 0 Replies
View Related
Feb 26, 2013
Just installed the new 2.0.8 version. Its been a while I am interested on using PM for our company.The problem I have is creating an Oracle DB connection. When I create a new Oracle DB connection, and test it, Steps 3 and 4 fail.What is strange is that I followed the following procedure in PM 1.9-825 and worked fine. I am wondering if something changed in the new PM 2.0.8 version (I noticed that php_oci8.dll was commented out in php.ini).
Oracle Version is 10GR2
PM installed on clean XP sp3
1. Got a new Windows XP SP3 PC
2. Installed PM 2.0.8
3. Edited php.ini and uncommented [PHP_OCI8] and extension=php_oci8.dll
4. Installed oracle instant client “instantclient-basic-win32-10.2.0.5” in c:oracle
5. Installed oracle instant client “instantclient-sqlplus-win32-10.2.0.4” in c:oracle
6. Added c:oracle in PATH environment variable
7. Created ORACLE_HOME = c:oracle environment variable
8. Added TNS_ADMIN = c: environment variable
9. Copied working tnsnames.ora file into c:
10. Rebooted.
-------------------------------------
1. Tried sqlplus connection to my oracle db and worked.
2. Launched PM
3. Created a new process
4. Created a new DB connection as follows:
a. Engine:Oracle
b. Server:192.168.xxx.xxx
c. Database name: my_name (where my_name appears in tns_names.ora)
d. Username:my_username
e. Password:my_password
[code]....
View 1 Replies
View Related
Jul 11, 2013
i have 2 instances (one on Oracle 11g and the otherone Mssql) i was asked to make a link between both.
btw i need excecute a procedure from Oracle against Mssql tables.
View 3 Replies
View Related
May 28, 2010
I'm getting the error messaage:
Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory
I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.
View 3 Replies
View Related
Mar 5, 2013
While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:-
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument
Attaching output session.
View 16 Replies
View Related
Jun 8, 2010
I'd like to make a connection from Oracle SQL Developer to a MS SQL Server DB. How can I do that?
View 2 Replies
View Related
