Oracle Port On Localhost Machine?

Oct 14, 2011

How to know the oracle port no on localhost machine.

View 1 Replies


ADVERTISEMENT

Localhost Doesn't Work In Listener.ora Or Tnsnames.ora

Jul 29, 2010

I want to be able to use "localhost" in my tnsnames.ora and listener.ora files but for some reason its not working.

just concentrating on the listener, when I have the following in my listener.ora the database doesnt register with the listener:

########################################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))
########################################

This is even after using the "alter system register" command. I'm checking whether my database is registering using "lsnrctl services".

With the following in listener.ora all is fine:

########################################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.152)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))
########################################

So why wont it work with localhost?! I'm running Oracle 11G on XP Pro.

View 7 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

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

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

Networking And Gateways :: Port Forwarding In Oracle 10g

Sep 8, 2012

i want to online my oracle 10g database but when i make connection string then i don't know what the port i set. I set default port 1521 but it not work on client site .

View 4 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

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

Forms :: Transfer Data From Oracle 9i To Serial Port?

Feb 14, 2012

I want to transfer data from Oracle form 9i to serial port.

Serial port is connected to electric board to show.

View 2 Replies View Related

Networking And Gateways :: Oracle Tomcat Conflict Port 8080?

Apr 29, 2010

I have a problem: Oracle is working on port 8080 used by tomcat. Then two applications are conflicting.

View 2 Replies View Related

Forms :: Communication Form Serial / Parallel Port Via Oracle?

Jun 14, 2005

I want to connect a biometric device with my system, through serial port / parallel port. And want to permit only valid users to the system.

View 18 Replies View Related

Restrict Client Connections To Just Two Specific IPs Over Oracle Listening Port?

Jan 18, 2013

I was asked if it was possible to restrict which users / or client IP's connect to my Oracle 11.2 database. I guess I could just shutdown the listener and have me and one other DBA connect to it via SSH / LOCALHOST but I was wondering if there was a more DBA specific way to restrict client connections to just two specific IP's over the Oracle listening port?

View 5 Replies View Related

Forms :: Install Oracle 5i On XP Machine

Oct 30, 2012

I am getting below error when I try to install Oracle Form5i on XP machine.

"OS_ERROR while translating path from $"

View 1 Replies View Related

Windows :: Oracle 10g On Virtual Machine 2003 X64

Jul 9, 2010

Does already installed Oracle 10g (10.2.0.1) on a windows 2003 server x64? Do you notice strange behaviors, any errors after the installation?

Does already installed Oracle 10g on a windows virtual machine? Are there any prerequisites?

View 9 Replies View Related

RAC & Failsafe :: Multiple Oracle Home Machine On Two Node ENV?

Mar 6, 2012

I have two node RAC database running on linux machine (Oracle10G SE), our requirnment is to install new oracle binaries for Oracle10G EE on diffrent home location.after install Oracle10G EE binaries on new oracle home , i want to point our existing database to new Oracle10G EE home to adotp a features of Oracle10G EE features.

But at the same time i dont want to deinstall our Oracle10G SE binaries.So it is possible to rollback our process to point our database back to Oracle10G SE from Oracle10G EE in case anything going wrong.

View 1 Replies View Related

Forms :: Get Client IP Address And Machine Name In Oracle 10g Without Webutil

Sep 26, 2013

How can we get client ip address and machine name in oralce forms 10g without webutil.

View 3 Replies View Related

Accessing Oracle On VirtualBox From Host Virtual Machine?

Jul 18, 2013

I have a Host system of windows 8, installed the Virtual Box Latest edition.The guest OS is the oracle Linux that came with the Pre-Built Developer VMs from Oracle.The VM is set to HOST ONLY network setting. Now, the thing is that i want to access the Oracle in the guest machine from my windows host machine.the guest OS shows the IP address as 192.168.56.101. I can ping the IP address from the HOST machine, but cannot connect theSQL developer to the oracle in the guest OS from the host machine. It keeps on saying the Network adapter cannot connect. do not say that install the oracle in window itself. I actually want to do the same on my macbook pro as that is my primary machine.

View 10 Replies View Related

Windows :: Installing Oracle 10g On Win 2008r2 64 Bit On HP ML110 G7 Machine

Jun 29, 2012

we are having problem installing oracle 10g on windows 2008r2 64 bit on a HP ML110 G7 machine.

we have 10203_vista_w2k8_x64_production_db.zip
downloaded from oracle site.

View 3 Replies View Related

Unable To Start Oracle Database 11g On Linux Machine?

Nov 12, 2012

Issue : NOT able to start the Oracle Data Base 11g on Linux machine

I've successfully installed Oracle-DB-11g on my Linux machine.

Note : I haven't declared or exported any variable(s) , actually I'm not sure how and where to do this.

View 1 Replies View Related

Forms :: Store Report Output In Client Machine Through Oracle 11g

Aug 24, 2011

i am generating report from oracle forms using web.show_document .pdf output is coming in seperate url.entire piece of code is working fine.now i want to store this pdf out put in client machine whether path will be specified by user.

View 3 Replies View Related

Server Administration :: Oracle Normal And Application DB In Single Machine

Apr 26, 2012

I have already installed oracle 10g version in my Desktop. Now i want to install APPLICATION SERVER 10g version.

Should I Un install the Normal Database.
Or else can I have both in a single machine.

View 1 Replies View Related

Open Excel File From Oracle Directory On Local Machine

May 31, 2013

I have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .

View 1 Replies View Related

Installation :: Oracle 10g Client Install Skips - Windows 7 Machine

Nov 15, 2013

I have Oracle 11g database home in my 64 bit Windows 7 machine. However, now i would like to install Oracle 10.2.0 client as well. I tried giving a separate location.

But for some reason, whenever i start the Setup and run the Administrator Type, the installation just skips without giving any errors. It just creates the inventory folder in the specified path.  It goes to the Product-Specific Prerequisite Checks and exits without giving any warnings or errors. 

View 15 Replies View Related

Database Auto Start With Machine On And Shutdown With Machine Shutdown

Sep 2, 2012

i install oracle 10g on linux on perform the following step but my database is not auto start with the machine

Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.

The scripts are,
$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbshut

Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.

-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.

In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.

If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.

Automate Startup/Shutdown of Oracle Database on Linux

Step 01: Be sure that oratab file is correct and complete.

Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.

Database entries in the oratab file have the following format:

$ORACLE_SID:$ORACLE_HOME:Y
Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.

If in my database there is two database named arju and arjudup then my oratab file will contain the entry like,
arju:/var/opt/oracle/product/10.2.0/db_1:Y
arjudup:/var/opt/oracle/product/10.2.0/db_1:Y
where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.

Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.

a) Login as root.
b) Change directories to /etc/init.d
c) Create a file called dbora and chmod it to 750.

# touch dbora
# chmod 750 dbora
d)Edit the dbora file and make the contents of it like below.

[Code].....

View 1 Replies View Related

Client Tools :: Oracle / Crystal Reports On Windows 7 64Bit Machine?

Feb 1, 2011

I recently got a new PC at work which is Windows 7 64 bit.

We run lots of crystal reports(1000's) that pull data from an oracle back end.

I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.

However, when I use crystal to access the TNS Name it gives me the following error.

[URL]

My path variable on the PC has "C:oracleproduct10.2.0client_1BIN;".

I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.

View 7 Replies View Related

Client Tools :: How To Configure SQL DEVELOPER Via Virtual Machine Oracle Database

Mar 21, 2012

i have oel installed on my parallel Virtual machine.

i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.

my os is windows7 32 bit.

View 13 Replies View Related

Best Way To Change Language Of Windows Oracle Client Machine Edit Registry

Jun 29, 2012

We have installed oracle client on Windows machine and despite selecting language as English

when look in registry shows NLS_LANG as

AMERICAN_AMERICA.WE8MSWIN1252.

What is the best way to change language of Windows oracle client machine edit registry.

View 2 Replies View Related

Installation :: Oracle Database 11gR2 On Virtual Box on Windows 32bits Machine

Oct 31, 2013

I have an issue during the database configuration using DBCA at 85% it blocs, then it displays an error asking to reconfigure ORACLE_UNQNAME.

View 6 Replies View Related

Oracle 11g - Java Virtual Machine Could Not Find Main Class Program Will Exit

Jul 26, 2013

In my Organization I am trying to install oracle ODTwithODAC112030 but one Error showing that is java virtual machine could not find main class program will Exit. 

Server Configuration Dell power Edge r510 Windows 2003 64 bit serv PAck 2 Citrix Presentation server 4.5 .

View 1 Replies View Related

RAC & Failsafe :: ORACLE Server Failover Parameters In Windows Server Machine.config File

Jan 17, 2012

working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.

View 6 Replies View Related







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