I don't believe it is using the TNSNAMES.ora entry for this, because when I take it out of there it still connects. I create a 10.1.0.5 database and copied the tables,etc to there. But I'm having problem connecting, getting "ORA-12154:TNS Could not resolve service name". Tried the following:
I new to this, but my guess is the other entry had the full path name..and this SERVICE_NAME does not. But then again I don't believe it looks at the TNSNAMES file. This NJZTEST is the 2nd instance on the NJZAINETTEST machine.
I have one query related to database connection from server to client.I have one database in the server and I want to connect from client.I set the tnsnames in client system as follows.
when i am connecting to my database in command prompt,sql * plus editor is it successfully connecting to the database but not connecting with the oracle client OEM.
but after connecting the LAN it is not connecting and also in the case when i am connecting to the internet through the USB datacard it is not connecting with the oracle client OEM.
how can i connect to database when the LAN,USB datacard connection.
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?
ODBC--call failed.TNS:listener was not given the SID in CONNECT_DATA (#12504)
TNSname sets the SID. SQL*Plus is able to connect from the client Windows XP Proff using the same name. Access, on the same client, uses the same Oracle driver to connect successfully to other Oracle databases. These other databases show equal tnsname (different name and SID...)
ODBC Data Source Administrator configures the database and the test connection is successful.
Cannot set up a link from Access to the Oracle database. At some point, I have created a new Access database and it did let me connect, view the list of tables, and set up links to several tables, but the next day I could not open any of the tables and the complain was: ODBC--connection to 'MYDB' failed.
It seems that SQL*Plus passes correctly the SID from the TNSname but ODBC, when invoked from Access, does not. Yet, ODBC does it right for other databases.
How to set the QUEUESIZE in a RAC Database with SCAN feature. listener.ora inside the grid home contains the following information
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent
and the endpoints_listener.ora contains the following (edited the host and ip details for maintaining confidentiality)
LISTENER_HOSTDB02=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostdb02vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=<ip of hostdb02>)(PORT=1521)(IP=FIRST)))) # line added by Agent
As per my understanding, QUEUESIZE parameter can be set inside the endpoints_listener.ora
how to make changes in a oracle 11g rac environment.
One of our requirements is to secure the listener and other Oracle services by running them as a local OS account rather than as LocalSystem on the server.
I created a local OS account (assume it's named oracleuser), assigned it to the User and ORA_DBA groups on the server, and then I went to the Local Policies and added oracleuser to "Deny log on locally" and "Log on as a service".
I opened up the Services utility and stopped the four Oracle services we have running (OracleMTSRecoveryService, xxx_home1iSQL*Plus, xxx_home1TNSListener, and OracleServiceMYDB). I changed the "Log on as" for each service to oracleuser with its password (copied and pasted so I know there are no typo's), and restarted the services.
All the services except the listener started up. Attempting to start the listener caused the following error:
"The xxx_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."
I tried rebooting the server and had the same result.For now just the listener service has been switched back to logging in as LocalSystem while the other services continue to use the local OS account and the database seems stable, but I do need to figure this out.
I installed oracle 11g successfully and was able to login with SQL plus.When I tried making a connection with the username and password via SQL developer I'm getting the ora-12505 error (picture is attached)
I am getting the error TNS-12537. In the SQLnet.ora file, if no IP Address is listed everything works fine and the listener starts without any issue. But one of the Security requirements we have is, we need to list all the client IP address on the SQLNet.ora file. I checked the Windows Firewall services and it is disabled.
Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. M:>tnsping proditg TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 01-OCT- 013 10:31:14 Copyright (c) 1997, 2011, Oracle. All rights reserved.
When i connect from client to server the client looks up for the host address and port number in tnsnames.ora and connect to it via listener.ora in server.Where does pga and sga come into picture here?
Also what is the role of sqlnet.ora in client?What will happen if i specify a different port for the instance in tnsnames.ora and listener.ora?
I am facing ora - 12537 TNS connection closed issue while I am trying to login into database.I have installed Oracle database 11g on windows 7 premium OS.
I have a JBOSS aplication server connect to database. When I tested on local, everything was ok. But when i test on real system , have a message "connection time out" on log file of app server while Oracle db still active. I viewed OEM, the system is executing the query :
"SELECT a.path songFilePath, a.BEAT beat from vp_song a, mst_my_album b "+ "where "+ "a.BEAT = b.BEAT "+ "and b.my_album_id IN "+ "(select my_album_id from (select my_album_id, ROW_NUMBER() OVER (order by my_album_id asc) "+ "R from mst_my_album where msisdn = ?) WHERE R BETWEEN ? and ?)";
TNS-12518: TNS:listener could not hand off client connection TNS-12571: TNS:packet writer failure TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error Linux Error: 104: Connection reset by peer
I'm trying to connect Oracle 11g database from Oracle 9i database, by creating dblink on Oracle 9i database. But my session got hang while i perform this. Here i'm giving the steps i followed on my both the database. Here Oracle 9i database is my source db and Oracle 11g is my target db.
Following steps/setting on Oralce 11g Database
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon boolean TRUE
SQL> alter user SSA identified by SSA;
User altered.
Password File recreted on Oracle 11g Database Server
DROP DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM"; CREATE DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM" CONNECT TO SSA IDENTIFIED BY SSA USING 'DEVDATA.DEV11G';
I am facing difficulty in connecting Oracle 10g client to Oracle 10g database. Both the machines are in windows xp with service pack-2. The following observations are made in server machine
1. The loopback test of the server is successful. 2. One net service name created in the server end. 3. Database connection is successful with above service name. 4. tnsping <server ip address> is successful
# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.
# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.
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.
connecting two oracle database in two different server.I installed Oracle 10g XE in both system.Both system act as Server.I need to connect both server using database link concept.
how to use the tnsnames,ora and listener.ora file for connecting both system.
We want to configure HSODBC on HP-UX 11.23 for Oracle Database 10g R2 in order to establish a DB link from Oracle to Netezza.We have installed the ODBC Drivers too..Currently we have not done any configurations and we go via an AIX box to establish a link.We want to get rid of the AIX box and instead establish directl link towards netezza from HP-UX Box.
Does Oracle support have some guidelines or steps to setup HSODBC on Oracle database 10g r2 residing on HP-UX 11.23 towards Netezza?
Connecting Oracle to SQL Server via database link.
I am trying to connect from Oracle 10G to a SQL Server database. I have looked at the manual and i will admit that i am finding the documentation quite difficult to follow. There seems to be several options to use but none of the documentation describe how each option works.
As an example, i have been given the following information on the database i need to connect to (i.e. the SQL Server database)
- Username - Password - Database Name [lets assume the database name is data_extract]
Note: In listener.ora, i only added the last SID_DESC entry. I then went on and created the database link as shown below
create database link sqlservdb using 'sqlserver.db';
When i try to access a table i get the following error
sqlplus> select * from TESTTABLE@sqlservdb; select * from TESTTABLE@sqlservdb * ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from ORASQLSERVER
A couple of things i am not sure of:
- Where do i specify the username and password to access the sql server from the oracle db to the sql server db
- Having read around on the internet, i can see some people refering to a DSN datasource. I am told that the information that i have is all i need. Is this correct or do i need something else?
- The sid i specified in inithsodbc.ora and tnsnames.ora is actually the sql server database. Is this correct?
But i do a lot of work-arounds to make sure the installation does not make corrupt my OracleAgent,OracleService and OracleDataGatherer. If i just let the installation do its thing i have problems with my libraries, and can't start anything.
The errors are : Procedure entry point 'BlaBla' could not be located in the Dynamic Link library 'AnyName'.
I notice that i have 2 versions of the libraries in OracleHomeBIN (one version 8, one version 11). The programs that start the OracleAgent,Service and DataGatherer call the old libraries but expect to find values that can be found only in new libraries.