Client Tools :: Listener Configuration?

Sep 5, 2012

i have added a new listner on new port on my window 7 system for oracle version 11.2.0.1 and registered some test databases to this new listner , then i am able to access my databases through the toad because i have changed port number in tns entry, but not able to login by sqlplus. is i am missing something? should i have to restart the system or restart the all databases?

View 1 Replies


ADVERTISEMENT

Client Tools :: ORA-12504 / TNS Listener Was Not Given SID In CONNECT_DATA

Sep 25, 2013

i am getting below error.

[Prime@localhost Prime]$ java -classpath /home/Oracle/Middleware/wlserver_10.3/server/lib/weblogic.jar utils.dbping ORACLE_THIN system systesm 10.66.12.70:1521
Error encountered:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)

[code]....

View 2 Replies View Related

Client Tools :: ORA-12505 - TNS - Listener Doesn't Currently Know Of SID Given In Connect Descriptor

Jul 25, 2011

When i'm trying to connect my already-existing database, i get an error: "ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.The Connection descriptor used by the client was: localhost:1521:xe".

i can't loose the builted tables and the information stored in them.My listener.ora file is :

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct10.2.0server)
(PROGRAM = extproc)
[code]....

View 36 Replies View Related

Reg The Configuration Of Listener On OEM?

Jul 24, 2012

We have a listener with the password set to it. We are trying to configure that listener to the OEM grid. However, its not getting configured. The status shows as down.

However, when we try to set up without the password, we are able to configure it on the OEM console.

Need to understand, that if passwords are set to the listener; then won't that get configured over the OEM. or is there something where we are lacking.

View 4 Replies View Related

Oracle RAC Listener Configuration

Dec 6, 2010

i have installed oracle 11g r2 rac with 2 nodes. i want to configure the client side load balancing and server side load balancing. For the client side load balancing the i have configured with the

(FAILOVER=ON) (CONNECT_TIMEOUT=5) (RETRY_COUNT =3).

and to configure server side load balancing i have modified the service as follows:

execute (DBMS_SERVICE.MODIFY_SERVICE (service_name=>'service_name', clb_goal=>DBMS_SERVICE.CLB_GOAL_SHORT);

now i have few questions:
1. for the server side load balancing do we have to configure the REMOTE_LISTENER on each node so that the instance on each node registers with the listeners on other node.
2. if we have 3 nodes does this mean that we have to configure the REMOTE_LISTENER on 3 nodes to register with the listeners on the other remaining 2 nodes.
3. does the listener have to be registered with the vip network address (where the clients usually use to connect).

View 2 Replies View Related

Listener Configuration Terminates Abruptly

Jan 6, 2010

We have an oracle server on windows. It was working fine till today but now it is giving an error. When i try to add a listener configuration using net configuration assistant, it terminates abruptly without givng the finish button. Why does this happen?

I am not able to open the link

[URL]......

It gives an error "Oops! This link appears to be broken"

How can we solve this?

View 3 Replies View Related

Networking And Gateways :: Multiple Home Listener Configuration?

Jul 29, 2011

I have installed Oracle 10g in windows 2003 two times with two different homes. (D:oraclehome and E:oraclehome).Databases db01 and db02 created in these homes respectively. how to configure listener and tnsnames to aceess these databases.

View 7 Replies View Related

Application Express Listener :: Configuration - How To Change From Port 80 To 8080

May 29, 2013

I installed apex and configure the apex listener at port 80 by mistake couldn't pay attention to use port 8080. The installation is complete but the apex is running at URL.... but the login window is invisible on the page. I can just see the name on the tab "Application Express Login" . When i click on the error message at the bottom of the browser, the message says "apex is undefied" line 35.

When I run the server, I get a message "No free port within range 80. How can I change from port 80 to 8080? how to either un-install the listener or change the port 80 to 8080

View 3 Replies View Related

Networking And Gateways :: Stand Alone 11gR2 Database - Listener Configuration

Sep 10, 2013

I have stand alone 11gR2 database. Do I need to configure the listener and have the tnsnames.ora file entries under Grid home and start the listener from Grid home or do I need to start from Oracle database home?

View 5 Replies View Related

Client Tools :: Tools For Load Testing On Oracle - J2EE Application?

Jan 5, 2012

which are recommended Tool for load testing (for performance) on Oracle-J2EE, 3 Tier applications?

Is 'Oracle Application Test Suite' the best for such test where we can simulate numbers of users and their various actions?

Does it come with Oracle Database license or we have to buy it separately?

View 1 Replies View Related

Client Tools :: Basic Tools For Oracle Version Control

Aug 26, 2011

I'm looking for 3 simple things.

1) A reverse engineering tool that I can point to an Oracle schema and get a "baseline" script to re-create that schema from scratch, with decently formatted DDL files (1 per object) neatly organized in a directory tree (by object type) and called in the correct order. Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to populate (insert) those tables as part of the script.

2) a diff tool that I can point to a pair of Oracle instances (source and target) containing a given schema and get a "delta" script to alter the target schema so that it becomes identical to the source schema. If data loss occurs on the target instance (i.e. drop a column) I would like to find a warning comment inserted in the script (e.g. "-- Attention: data migration DML needed here?"). Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to update (delete, update and insert) the data in the target tables to become identical to the contents in the source tables *without* deleting and re-inserting all rows (or dropping, recreating and repopulating the table).

3) I would like the above two tools (that, as you will have recognized, are basic to putting your database design under version control) to be open-source, with a command-line interface and a vibrant community backing them.

View 9 Replies View Related

Data Guard :: Client Failure Failover / Switchover Standby Configuration?

May 10, 2011

After switchover the primary is now standby and standby is now primary, the clients are unable to connect to new primary database.

TNSNAMES.ora file at client side...

prim.world=
(DESCRIPTION_LIST=
(FAILOVER=true)

[Code].....

SQL> conn iq/iq@prim.world
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

SQL> conn sys/ora123@prim.world as sysdba
Connected.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------------------------------------------------------------------
MOUNTED
SQL> select database_role from v$database;
DATABASE_ROLE
--------------------------------------------------------------------------------
PHYSICAL STANDBY
SQL>
--------------------------------------------------------------------------------
It's Oracle 10.2.0.1.0 version....

View 11 Replies View Related

Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?

Feb 21, 2013

The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.

# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com

PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com

I am using SQuirreL Client version 3.4.0

# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =

[code]...

# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.

# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)

# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")

View 10 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related

Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit

Jul 20, 2012

Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?

View 1 Replies View Related

Client Tools :: Install Oracle To Get Latest SQL Plus Working On Client PC

Jul 11, 2012

I need to install Oracle client to get latest sql plus working on client pc as the problem is, i am not able to find out where i can download this , i just need the sql plus as i am not able use many commands because when i installed oracle forms 6i client tool , sql plus 8.0 got installed.

View 4 Replies View Related

Client Tools :: BR*Tools Appearance Not Complete

Jan 16, 2013

I want to use BR*Tools to administer an Oracle database. I have installed BrGUI local, set the JAVA Home variable and edited the brgui.properties file accordingly.I am able to login, but the menues are mising. The login screen is incomplete.

View 5 Replies View Related

Client Tools :: Command Line Tools

Jan 22, 2011

I usually work in oracle using the different editors like toad, plsql developer etc. I felt command line is good utility because of various supporting points. I am not sure what kind of command line tools is available/used. I am using pretty straight command line
(run->cmd, then enter username and password).

The best command line tools available. What is generally used command line tools.

View 1 Replies View Related

Client Tools :: ODBC Instant Client Oracle 10g

Jun 28, 2010

The version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. for Unix AIX 5

I install the ODBC Driver Manager, Basic Instant Client, ODBC Instant Client packages (libsqora.so, odbc_update_ini.sh).

The error:

[oracle@d4 oracle] $ isql OracleODBC-10g user passtemp -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/instantclient_10_2/libsqora.so' : file not found
[ISQL]ERROR: Could not SQLConnect

Configuration

odbcinst.ini
[Oracle10gODBCdriver]
Description = Oracle ODBC driver for Oracle 10g
Driver = /u01/app/oracle/product/10.2.0/db_1/lib/libsqora.so
Setup =
FileUsage =
CPTimeout =
CPReuse =

The documentation explic with exists the file libsqora.so.10.1 but not exists in the ODBC Instant Client packages.

I applied ln -s libsqora.so.10.1 libsqora.so but the connection not function

odbc.ini
[oradns]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
[code].......

View 1 Replies View Related

Client Tools :: How To Connect To Oracle 7 Using Client

Dec 15, 2011

I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.

I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".

View 8 Replies View Related

Client Tools :: Identify Oracle Client

Oct 3, 2011

I would like to know if there is some specific file who identifies the installation of Oracle Client in some machine.

View 4 Replies View Related

Client Tools :: How Can Isqlplus Available For Windows Client

Sep 23, 2010

I have an Oracle server on CentOS 5.4, I can visit isqlplus on server, but I can't visit isqlplus on a windows client. ping works between server and client. I remember client doesn't need to install software via isqlplus, but I am not pretty sure.

View 2 Replies View Related

Listener Could Not Hand Off Client Connection

Nov 20, 2012

I am having Oracle 11g (Release 11.2.0.2.0) running on Windows Server 2007 SP2. I am trying to connect to this server from my system using SQL Plus command prompt. (Dedicated - redirect (client and server are on different computers)

I am getting an error: TNS-12518: TNS:listener could not hand off client connection.

When I checked the listener log in the server machine, these were the errors:
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 203: Unknown error

tnsname.ora entry in the client side(my system)
BAM = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = md1svcvwm01)(PORT = 1521))
)
[code]...

From the command prompt, I use sqlplus bamtest10/bamtest10@BAM to connect where in I am getting the errors.

View 4 Replies View Related

Connect From A Remote Client / Received Error Of No Listener

Dec 24, 2007

We installed Oracle 10g on one of our servers and configured the listener to host=localhost. Here's our listener.ora file:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
[code]...

After restarting the listener, we could connect using the connect identifier from the local server. However, when trying to connect from a remote client we received the error of "no listener". In the remote client the identifier is defined with host=ip_address. TNSping from the client to the host was successful.

When we changed listener.ora to host=up_address we could connect ONLY from the remote computer. Only after changing the host in tnsnames.ora file to the IP as well - we could connect from both the local server and the remote client.

I usually use host=localhost in the listener file (and the local tnsnames file) and never had this problem before.

View 1 Replies View Related

Networking And Gateways :: Listener Could Not Hand Off Client Connection

Nov 25, 2010

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

View 1 Replies View Related

Server Administration :: Database Down - Listener Could Not Hand Off Client Connection

Apr 12, 2013

Unable to connect to database getting below error

sqlplus sys/oracle@server_name/orcl

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 12 11:07:15 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12518: TNS:listener could not hand off client connection

Below is alertlog entry

Completed: alter database open
Thu Apr 04 17:06:19 2013
db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this

[code]...

View 6 Replies View Related

ORA-12523 - Listener Couldn't Find Instance Appropriate For Client Connection

Aug 13, 2013

emca -repos create - ran clear
emca -config dbcontrol db - failed with following:

SEVERE: Error Loading TransX:Listener refused the connection with the following error:
ORA-12523, TNS:listener could not find instance appropriate for the client connection

lsnrctl status
*************************************************************************
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
Start Date 13-AUG-2013 15:39:06
Uptime 0 days 0 hr. 26 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
[code]....

View 2 Replies View Related

Client Tools :: How To Add Value From Sqlplus

May 14, 2013

I want to add a value from sqlplus.

My scenario is like that i want to add the following value

select count(*) x from tab1

i need to connect several database, and each time i need to add with previous one. like that

connect a/a@db1;
select count(*) x from tab1;

then when i connect another db

connect b/b@db2;
select count(*) x from tab1;

x will add with previous one.

View 6 Replies View Related

Client Tools :: How To Connect To Sql Plus

Nov 18, 2010

I have to connect to sql*plus to get explain plan.When I conect in Toad, the credentials are as:-
User/schema :- TestDb
Password :- TestDb

Under direct tab:-
Host :- 172.17.252.96 Port :- 1521

Service Name :- xe

I am not able to connect to sql*plus using:-

Username :- TestDb
Password :- TestDb
Host String :- 172.17.252.96

Not sure how to login when I have IP address

I also tried login as:-

Username :- TestDb
Password :- TestDb
Host String :- xe

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved