Networking And Gateways :: Find Out Users Hostname Who Are Connecting To Database Remotely

Apr 22, 2010

i got to find out the users hostname who are connecting to database through remote,i tried with v$session bt it is showing null values in the terminal column.how to find out ?

View 8 Replies


ADVERTISEMENT

Networking And Gateways :: Connect Remotely Database?

Jul 14, 2010

i have a inventory system and trying to connect remote database one by one throught two static ips. If first ip is not ping then go to 2nd ip only when open the login.fmx page

following examples are my tnsnames.ora

IP1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.12)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

IP2.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.13)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

i am not understand what i write the code on-logon trigger

View 8 Replies View Related

Networking And Gateways :: Connecting To Database Outside Network?

Feb 14, 2011

i want to connect to a database that is out side my network and my application is running on forms 6i and database version is 10g .

View 2 Replies View Related

Networking And Gateways :: Connecting Developer 6.0 To 10G Database

Mar 19, 2010

Can currently connect to a 9.2.0.1 database using Oracle Developer 6.0 with the following connect string:

C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@GMS3B.TEST.COM[/email]

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:

C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST[/email]
C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST.TEST.COM[/email]

I did add the entry for the 10G database to TNSNAMES.ora:

NJZTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = njzainettest.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = njztest)
)
)

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.

View 6 Replies View Related

Networking And Gateways :: Connecting Two Oracle Database In Different Server?

Jul 13, 2012

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.

View 39 Replies View Related

Networking And Gateways :: Connecting Oracle To SQL Server Via Database Link?

May 24, 2011

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]

To connect the above i made the following changes

$ORACLE_HOME/hs/admin/inithsodbc.ora
---------------------------------------
HS_FDS_CONNECT_INFO = data_extract
HS_FDS_TRACE_LEVEL = 0
$ORACLE_HOME/network/admin/tnsnames.ora
---------------------------------------
sqlserver.db =
(DESCRIPTION =

[code]....

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?

View 10 Replies View Related

Networking And Gateways :: DBCA Installation And Remotely From Off-shore?

Sep 22, 2011

Iam facing a issue on DBCA Installation, when i tried remotely from off-shore. Steps I followed

a. I Connected a onsite desktop through a remote desktop connection (RDP) by using Corp-VPN from off-shore.
b. In the Remote Desktop, again by using production / Model VPN , connected the server which i need to Install DBCA
c. Using X11-Forwarding of putty, Started the DBCA installation.
d. Applied all the Parameters and on Finally clicking Finish to Start the database Creation, Finish button not responding and i can't continue the DBCA Installation.

View 1 Replies View Related

Networking And Gateways :: Find List Of Database Links?

Jul 2, 2011

There is a user account called 'BALA' in my database.I want to find out the database links that uses this 'BALA' account.

View 2 Replies View Related

Networking And Gateways :: Connecting Two ORACLE Servers

Aug 8, 2006

I know how to create a database link between two oracle servers, but problem is that SID is same for both servers, Is there any other way to connect two servers without using only 'SID' ..here are TNSNAMES.ORA FILE i HAVE

D.w=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST=ff.ffc.pic.com)
(PORT = 1521)
[code].......

Is there any other way rather that this

Create database link a connect to username identified by password using 'SID';

Any alternative like using SID.A.w or how I can differentiate these two SID s.

View -1 Replies View Related

Networking And Gateways :: Connecting A Client To Oracle?

Aug 15, 2010

Im trying to connect a benchmarking application (benchmark factory) from my windows 32bit laptop to Oracle on my linux desktop.

When connecting I am supplying the following details: (im getting the error: ORA 12170 : TNS connect timeout occurred)

User/Schema : matt
Password: ****
Host: 192.168.1.9
Port: 1521
SID: orcl
Connect as : SysDBA
Connect Using: Instant Client (selected from a drop down)
----------------------------------------------------

when i use the following command:

tail -100 /home/matt/app/matt/diag/tnslsnr/localhost/listener/alert/log.xml

i get these results:

[matt@localhost ~]$ tail -100 /home/matt/app/matt/diag/tnslsnr/localhost/listener/alert/log.xml
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:26:29 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:26:36.708+01:00' org_id='oracle' comp_id='tnslsnr'

[code]....

I have been told client is not getting to the listener because listener is only listening on 127.0.0.1.

unless & until DB server is configured with a routable IP#, no remote client will succeed.

View 7 Replies View Related

Networking And Gateways :: Connecting 32 Bit Client On 64 Bit Server

Feb 15, 2011

I am having difficulty in making the 32 bit Oracle client connection to an existing 64 bit DB. The 64 bit SQL*Plus will connect just fine, but when trying to configure the 32 bit client I can never get a successful TEST of the connection. It always returns "No TNS Listener". I have tried several things, but may be way off base. To name a couple ...

1) Stopped the 64 bit listener so my 32 bit listener can use Port 1521 ... no success
2) Tried naming the 32 bit listener to LISTENER32 to not conflict with the original LISTENER name ... no success

If there is a documented way to make this work, I would surely like to be pointed to the "how to" of this item. I need this as a commercial application I have that connects to the DB requires the 32 bit client.

View 1 Replies View Related

Networking And Gateways :: Connecting Forms To New Express 10g Server?

Dec 5, 2011

I have recently installed Oracle Express 10g Server on my local PC. I can successfully connect to this while bypassing the TNSNAMES from SQLTools, I can't however connect to this from Forms 10g or while using SQLTools with TNSNAMES. How do I configure my TNS names to use this server?

View 2 Replies View Related

How To Limit Users From Connecting To Database

Aug 14, 2012

i have a database nd only 10 users must allowed to access db at any point of time and sessions per user must be 1.that is only 10 users must be able to access the database.

View 6 Replies View Related

Connecting To DB Remotely Through Toad Using Oracle Instant Client?

May 5, 2013

trying to connect to DB remotely through Toad..

"instantclient" already downloaded and configured as below :

dll files like "oci.dll,... etc" are here : C:Oracleinstantclientinstantclient_11_2
Created both tnsnames.ora & listener.ora are here : C:Oracleinstantclient
etworkadmin

And did the below in user/system variables :

User Variables :
=========
TNS_ADMIN with value "C:Oracleinstantclient
etworkadmin"

System Variables :
===========
TNS_ADMIN with value "C:Oracleinstantclient
etworkadmin"
ORACLE_HOME with value "C:Oracleinstantclient"
Path edited and added this value "C:Oracleinstantclientinstantclient_11_2"

But i am still facing the below error :

ORA-12541: TNS:no listener

View 21 Replies View Related

PL/SQL :: How To Create New Users Remotely

Feb 27, 2013

I've been issuing commands like these by using a session on my guest Oracle VM that is hosted by Windows 8.

sqlplus / as sysdba
create user PocketGuide3rdEd identified by top-secret-password ;
grant connect to PocketGuide3rdEd ;
grant create table to PocketGuide3rdEd ;
grant create view to PocketGuide3rdEd ;
grant create trigger to PocketGuide3rdEd ;
grant create sequence to PocketGuide3rdEd ;
grant unlimited tablespace to PocketGuide3rdEd ;

I've discovered that I cannot do "sqlplus / as sysdba" remotely. Is there a way I can create another account like sysdba that can issue the above commands from windows so I don't have to log into the oracle guest VM?

View 4 Replies View Related

Networking And Gateways :: How To Find Out The Listener Password

Mar 24, 2011

How to find out the listener password in oracle?

View 3 Replies View Related

Networking And Gateways :: How To Find All The Objects Referring To DB Link

Aug 10, 2012

We have two schemas which earlier used to be separate databases. There were DB links created to access the objects from one schema to the other schema when they were separate databases.

Since now they are just 2 separate schema with in the same Database, we would like to remove the DB Links and create synonyms to access those objects. These DB links were used in code in many places, it is becoming tough to find a way to implement this.

how to find all the objects that are using these objects or all the places these DB likns were being used.

View 1 Replies View Related

Networking And Gateways :: Listener Could Not Find Available Handler For Requested Type Of Server

Jun 20, 2010

I have ora-12520. I run Oracle 11g on Red Hat 4 64 bit. Actually I have RAC but one node is down and I work only with up one (connection string point directly to listener of running node). I run test with not too big loading. select count(*) from v$sessions gets ~ 200 in maximum loading, but after half minutes I get this error in my logs. Each time, lsnrctl services show that all is right. It shows one service with one handler. I see nothing in alert.log. This is very strange, I know, and I'm sure that this is an actual alert.log because, I see there other events in actual time. Most important: I have SESSION parameter set to 600 and PROCESSES set to 400 so this must be enougha...

View 3 Replies View Related

Networking And Gateways :: Database Link From 11g To 10g?

Jul 5, 2012

I am trying to create a database link from the 11g database to the 10g database using:

create database link ORCL10R2 connect to <username10g> identified by <password10g> using <db10g>;

It Returns

Database link created.

select sysdate from dual@ORCL10R2 returns error:
ERROR at line 1:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

what changes I need to make to tnsnames and listener at both servers.

View 8 Replies View Related

Networking And Gateways :: Cannot Connect To Database

Nov 2, 2011

I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files

tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
[code]....

# 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.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

View 19 Replies View Related

Networking And Gateways :: How Many Listener Supported In One Database

May 30, 2010

How many listener we can have in one database? How many users can be support by one listener?

View 3 Replies View Related

Networking And Gateways :: Controlling Database Access?

Nov 22, 2010

i want to restrict particular ips ,for that i specified

TCP.VALIDNODE_CHECKING= YES
AND
TCP.INVITED_NODES=(IPADDRESS)

in sqlnet.ora file but whenever i connect to database from the particular specified IPADDRESS , the database allows the connection to happen ( doesnot restrict it),

View 1 Replies View Related

Networking And Gateways :: Unable To Connect To Database?

Feb 1, 2012

I am getting beloww error very frequently in database log and not able to connect to the database.

************************
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 01-FEB-2012 18:00:34
Tracing not turned on.
Tns error struct:
ns main err 12535

TNS-12535: TNS:operation timed out
ns secondary err 12606
nt main err 0
nt secondary err 0
nt OS err 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.1.24)(PORT=65503))
WARNING: inbound connection timed out (ORA-3136)
Wed Feb 01 18:00:44 2012
*****************

View 2 Replies View Related

Networking And Gateways :: Database Link Is Not Working

Feb 15, 2010

Database version:10.2.0.3
Operating System:Microsoft Windows XP

I have two database TEST and TEST2 on same windows machine. In TEST database i have created one database link that access one schema in other TEST2 database. but when i passed select command to access object in TEST2 through Database link it is hanging indefinitely.

command that i have used to create Database link: create database link scott connect to scott identified by tiger using 'TEST2'

This is sqlnet.ora Entry:

SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
TNSNAMES.ORA entry:
TEST2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SSIPL-LAPTP-052)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
[code]....

View 3 Replies View Related

Networking And Gateways :: Create A Database Link?

Mar 11, 2010

I am trying to create a database link using this syntax:


CREATE PUBLIC DATABASE LINK remote
USING 'remote';

where 'remote' is the service name. It creates it successfully giving the message "External database Created"

Note: I am doing using TOAD

But when i am trying to query something like

select * from scott.employee@remote

it gives an error:
ORA-12154: TNS:could not resolve the connect identifier specified

But the 'remote' db entry exists in the tnsnames.

View 14 Replies View Related

Networking And Gateways :: Unable To Connect To Database

Jun 27, 2011

am getting this message when am connecting to a database :

ora-12519:Message 12519 not found;product=RDBMS80 facility = ORA

am not getting this message all the time, sometimes am connected without any problem sometimes i get this message and i have to try again several times until am connected

i searched the net and my database provider guided me to this log URL.....

how to set my ORACLE_HOME environment variable.

View 9 Replies View Related

Server Administration :: Query To Find Hostname For Oracle Session

May 20, 2010

How I can find the hostname for an oracle session id?

View 4 Replies View Related

SQL & PL/SQL :: To Find Time At Which Query Fired By Any Of Users In Database

Oct 25, 2010

I have 10 users in my database, I need to find the time at which a query is fired by any of the users in the database. provide the query for this? I think i have to use V$sql,v$sqlarea or v$sql.

View 1 Replies View Related

Networking And Gateways :: Connect Remote Database Without Providing SID?

Apr 5, 2010

i need to connect to a remote database located on a different server using sqlplus without using database name in connect string.

e.g. if mydb1 (located on another database server on network)

sqlplus username/password

i am able to do this on local database but not on the remote database

View 7 Replies View Related

Networking And Gateways :: Database Link Not Working Between Oracle 9i And 11g

May 20, 2011

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

[oracle1@dev11g dbs]$ orapwd file=/backup/ora11gsoft/odb/OH1/dbs/orapwwbdata
ignorecase=n password=dev entries=5

Following steps performed on Oralce 9i Database

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';

Database link created.

SELECT * FROM SSA.SSMASTER@SSA11G;

And the hangs for ever.

View 4 Replies View Related







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