PL/SQL :: Find Database Server IP Address And Port Number

Aug 21, 2012

Is it possible to find the Ip address and Port number of a database server in Oracle 10g version?

actually i wanta to connect it through Putty.

View 7 Replies


ADVERTISEMENT

SQL & PL/SQL :: Get Port Number In Database With Query?

Mar 5, 2010

How to get a port number in database with a sql query.

View 10 Replies View Related

Server Administration :: Change Port Number?

Feb 6, 2013

When I created a new oracle database the port number was 1521 (default), but I want to change it to 1522.

View 4 Replies View Related

Security :: How To Find User And IP Address From Oracle Database

Jun 19, 2013

Last week we have realized that a user who connects through SQL Developer(as nothing wrong found in application server logs) has made a serious change in the database which created a real mess. The user has done some mischief in some calculations by making some inserts and updates in some important tables in our production database.

How can I find which user or from which IP the change is made.

View 6 Replies View Related

Server Administration :: How To Find Out Number Of CPUs Allocated To Specific Database

Aug 1, 2011

when we ran SELECT statement against CUBE, we got below wait event: resmgr: cpu quantum.Further, we checked below 2 parameters :

NAME VALUE
------------------------- --------------------------------------------------
resource_limit TRUE
resource_manager_plan SCHEDULER[0x12B943C]:DEFAULT_MAINTENANCE_PLAN
[code]....

It has been found that these sessions did not get enough CPU to process the request. how to find out how many CPU has been allocated to this database ?

> uname -a
Linux dukedmts03db02.corp.cox.com 2.6.18-128.1.16.0.1.el5 #1 SMP Tue Jun 30 16:48:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

how to analyze how much % of CPU being utilized for a specific session ?

View 4 Replies View Related

Server Administration :: Single Port For Database

Apr 8, 2013

what will be the advantages and disadvantages of configuring database on only one port number for connecting the database server.

View 1 Replies View Related

Listener Port Number?

Mar 8, 2008

I have local development Oracle 9i database in my Windows XP. I see it uses TNS Listener port 1521. For some reason it must be using port 8080 also or in the background because it seems to not let my local web container (Apache Tomcat which uses Port 8080) on the same workstation work when it (TNS Listener) is turned on. how I edit the Listener port number and if I do change the port number what other things do I need to change such as the OEM login settings to the local database

View 1 Replies View Related

Port Number For Oracle RAC

Sep 18, 2013

I have a two node RAC setup using SCAN, and I have two databases on it. Can they have the same port number?

View 7 Replies View Related

Server Administration :: IP Address / Host Name Or Domain Of Oracle Database Servers

Mar 27, 2012

Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.

View 3 Replies View Related

How To Change Listener Port Number

Sep 16, 2013

ENV: Oracle 10gR2, RHEL 64bit on ASM (10gR2): 

Current listener port is 1521. I have been asked to change it to 10526

I tried changing the port number in the listener.ora file and then restarting the listener but the I start getting "ORA-12541: TNS: no listener" error. If I change it back to 1521 and restart the listener, I am able to connect to the database. What else do I need to do to change the port #? After I change the port and restart, here is what I tried to test: $ sqlplus user/password@sid...ERROR:ORA-12541: no listener Enter user-name: When I rollback the port# change, I am able to login. 

View 18 Replies View Related

Enterprise Manager :: Oracle Port Number

Feb 10, 2012

While connecting my oracle with My JDBC driver . i got an SQLException:

public class Orajdbc {
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection
[code]......

i am successfully connected by type 1 odbc driver but while i want to connect it with "ojdbc6.jar" file then i got this exception i already added that jar file to my Environment variable ClASSPATH ..

How to find port number of my Oracle Service?

View 1 Replies View Related

How To Change Port Number Of Email Alert Notification

Nov 24, 2010

I want to configure the Email Alert Notification in OEM.

In OEM --> Setup --> Notifications Methods --> I am able to see a provision to enter SMTP Address, but there is no port number.

Due to some security policies, my company has opened only Port Number : 9925 for SMTP and blocked Port number : 25.

When I click on "TEST MAIL SERVERS" button, it gives me a error that :

"Test failed with message : Could not connect to SMTP Host , Port No. 25" .

Now I want to change this port number 25 to 9925.

View 5 Replies View Related

Forms :: Finding Out Port Number And Oracle ID For Compilation?

May 21, 2010

Is there any way i could figure out what is the current port number used in an existing setup of oracle forms in a linux server.

Is there any specific oracle id i should use to compile oracle forms on server?

View 5 Replies View Related

Networking And Gateways :: Changing Of Listener Port Number?

Feb 14, 2013

i have a listener configured on default port 1521 and i wanted to change it. i did following:-

1. stop the listener through lsnrctl stop

2.change the port number in tnsnames.ora and listener.ora and save both files.

3.now i start the listener as lsnrctl start

4.it started successfully but saying that it cannot register to instance.

5.i connect sqlplus / as sysdba and execute "Alter system register" and "System Altered"

but even then the listener is not registering.

View 13 Replies View Related

Networking And Gateways :: What Is Meaning For Port Number In Listener.ora File

Aug 12, 2013

what is meaning for port number,in listener.ora file associated with ? is there any difference for port number in windows & in linux server.,?

View 3 Replies View Related

SQL & PL/SQL :: Find Out IP Address For All Currently Connected Users In V$session

Apr 6, 2010

I need a query to find out IP Adress for all currently connected users in V$session.

View 7 Replies View Related

SQL & PL/SQL :: Get MAC Address And Insert Number In Table?

Jan 20, 2008

Having oracle DB 10gR2 .(each network card will use its own MAC address )

how can i get MAC address and insert the number in table? or something else unique for every machine ?

View 11 Replies View Related

Networking And Gateways :: Change Default Port Number Of Listener - Instance Registration

Feb 19, 2013

i am trying to chnage the default port number of listener but facing problems in instance registration. i did as follows:

1. stop the listener as lsnrctl stop (default listener).
2. chnage the listener.ora and tnsnames.ora with desire port numbers (1526) as follows:-
[code]
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

[code]...

but i didnt get the reason of aforsaid error and my instance is not registering

View 5 Replies View Related

Data Guard :: Find Out Number Of Standby Databases Configured For Primary Database From OS Level?

Nov 14, 2013

How can find the number of standby databases configured for primary database from os level

View 9 Replies View Related

Server Administration :: Find Maximum Number Of Concurrent Logins Over A Period Of 1 Month

Nov 18, 2011

Need to find out what the maximum number of concurrent logins are over a period of 1 month. We need to do this as we may need to buy more licences.

View 4 Replies View Related

Listener Port Conversion To Static Port

Mar 2, 2012

For every connection, oracle listener creates a unique dynamic port. Is this can be made static port for all connection? This a query raised in our penetration testing.

Listener log Sample :

02-MAR-2012 17:40:28 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.3.12)(PORT=3773))
02-MAR-2012 17:39:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.84)(PORT=38192))

View 2 Replies View Related

Reports & Discoverer :: How To Find Page Number And Total Number Of Pages

Jan 26, 2010

i am using oracle developer 6i report builder i required this type of query

example

if (:page number LIKE '1')
then
srw.set_text_color('darkred');
end if;

return (TRUE);
end;

but page number is not my table database item how can i use builtan page &<pagenumber> use for conditional format.

View 34 Replies View Related

SQL & PL/SQL :: Count A List Of Number Value And Find Maximum Number?

May 21, 2010

how do I count a list of number value eg 1,1,1,1,3,3,6,4 and find the one with maximum number which is 1

View 5 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related

SQL & PL/SQL :: Display Office Address / House Address And Emp ID In Single Query?

Feb 23, 2013

I have two tables emp , emp address as below

emp table :
emp_id emp_name,
1 rajesh
2 suresh

emp address table :

emp id emp_addresstype emp address
1 O kukatpally
1 H Hitech
2 O Kolkata
2 H hydar nagar

I need the query to display the Office address & House address & emp id in single query

ex: 1,Kukatally,hitech
2,kolkata,hydarnagr

View 3 Replies View Related

Opening Of Port 1521 For Database Connectivity Through Firewall?

Nov 8, 2012

we have a database available in UNIX machine A which can be connected from client in UNIX machine B through port 1521.
If we give ping command from UNIX machine A to B or B to A, 0% packet loss, means connection established properly through firewall in port 1521.

Now we are setup one more UNIX machine C and installed a client here. This machine is available in different group, means if i give ping command from machine C to A, 100% packet loss. But from machine A to C, connection established with 0% packet loss.Because of this, when we tried to connect to a database from client in Machine C to database in Machine A, we got "time out" error.

My query is:
1. Is this because of not opening of port 1521 through firewall?
2. If so, is it enough to open port 1521 through firewall when we connect from machine C to A?
3. Any additional setup is required in firewall apart from opening of ports?

Environment:
Oracle 11.2.0.3
UNIX AIX 5.3/6.1

View 2 Replies View Related

Forms :: Change Port 1521 In 6i And Oracle Database 8.1.7?

Jun 4, 2011

How can we change Port 1521 in forms 6i and oracle database 8.1.7

View 1 Replies View Related

Server Administration :: Find Whether Database Link Is Being Used?

Jul 26, 2011

I am having database A and database B and I am inserting into database b by selecting some records from database a using db link.Is there any way to find whether database link is being used?

View 6 Replies View Related

Server Administration :: Find Database Is Corrupted Or Crashed

Mar 3, 2012

how will you find your db is Corrupted or crashed. how will u recover it.

View 2 Replies View Related

Server Administration :: Find Out Active Schemas In 9i Oracle Database?

Dec 9, 2010

findout and to fill up the excel which lists down the Database schemas and states whether they have in active / or not.

Active state may be determined whether it has been used for the last 3 months or so. The last updated time may be a good indicator of the same.

View 2 Replies View Related







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