Networking And Gateways :: Changing Standard Port 1521

Dec 13, 2011

Is it possible to change oracle's standard port 1521 ?

View 1 Replies


ADVERTISEMENT

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

Networking And Gateways :: Listener Configured At Non-Default Port?

May 16, 2011

I have configured oracle listener at Non-Default port 1526.

Is it mandatory to mention LOCAL_LISTENER parameter at pfile?

LOCAL_LISTENER='listenerr_alias'

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

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

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

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

Networking And Gateways :: TNS Listener Service Won't Start After Changing (Logon As) Setting

Mar 22, 2010

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.

View 2 Replies View Related

Application Express :: Changing Row Color Of Standard SQL Report

Feb 2, 2013

change the color of a row in APEX SQL report. Change Colour of Row - Oracle APEX SQL Report...It's a bit outdated, and trying to figure out how to get to this page: URL.....where I can conditionally set background color.

I am using theme 13 (legacy) and made a copy of the report region. Edited it but cannot find an equivalent section of that apex 3.1 screenshot.

View 4 Replies View Related

Networking And Gateways :: How To Set Oracle Gateways 11g For Mssql

Feb 21, 2010

I want connect mssql in oracle by orale Gateways 11g

my environment:
windows Wista
oracle 11.1.0.7.0
Oracle Database Gateways 11.1.0.7.0
SQL SEVER2008

these soft in one computer.

my steps :

1. set initdg4mssql.ora
2.set listener.ora
3. set tnsnames.ora
4.start lsnrctl
5.use SYSTEM/ORACLE@DZCDB

logined. create dblink and test.

but it's error. i want to know where is the error.

View 1 Replies View Related

Networking And Gateways :: TNS Could Not Found

Jun 26, 2013

I am working on people-soft, currently i am installing it but i found this error

ORA-12154: TNS:could not resolve the connect identifier specified

/*---------------------------------------------*/
this is listener.ora
# listener.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadminlistener.ora
# Generated by Oracle configuration tools.

HRCS9 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

SID_LIST_HRCS9 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db)
(PROGRAM = extproc)
)
)

/*---------------------------------------------*/
tnsnames.ora
# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

HRCS9 =
(DESCRIPTION =

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))

)

(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
/*----------------------------------------------------*/
sqlnet.ora
# 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 1 Replies View Related

Networking And Gateways :: Can Same DB Run On Different Hosts

Oct 8, 2012

I have one production server with oracle 11g R2 DB. I have to change Server Hardware and thats why I have to install oracle 11g R2 DB on New hardware and test it. I had installed DB with software only option and copied the cold backup of production server. The hostname and ip address of both the servers are different. I had change the "db_domain" parameter into init.ora with the hostname.Now my question is that can the same db runs on the same network with different hosts. Change of "db_domain" parameter into the init.ora is enough or i have to follow some other procedure.

View 12 Replies View Related

Networking And Gateways :: Two Different Listeners In Same Server

Jan 24, 2005

I´m working with Oracle 9.2.0 / HP-UX and I need to configure two different listeners for the same server using different IP address.

View 12 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 :: How To Change Listerner.ora Name

Dec 12, 2011

How to change listerner.ora name ? I want to have something like that application.ora instead of listener.ora.

View 9 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 :: Restart Server And Nothing Changes

Mar 28, 2011

My client get the error Ora-12514 when he tries to connect to the db.Well;

1) we restart the services: "OracleServiceOrcl" and listener but nothing changes
2) We restart the server and nothing changes
3) We checked the dump and he was done on March,26th. No db export yesterday. Is there any link with the clock change of this week-end (location of the server: France)?
4) The lsnrctl services listener command run successfully but it doesn't mention the instance ORCL.

View 12 Replies View Related

Networking And Gateways :: License Required To Use OID 11g

Apr 11, 2012

Im planning to install OID. I will use it for Oracle Net name resolution and Enterprise User Security.

How is this product licensed? Is it included in a enterprise rdbms license?

View 2 Replies View Related

Networking And Gateways :: MS Access To Oracle DB

Jul 13, 2010

I have an Access DB which I'm using to connect to an Oracle DB at work. There are several Oracle DB's that I can connect to using Access but this one I'm not able to connect to. I get the Oracle error ORA-25153 Temporary Table Space is empty.

I don't have the ability to make changes to the Oracle DB only to read and query.

View 1 Replies View Related

Networking And Gateways :: ORA-03114 And ORA-03135?

Jul 5, 2012

When I run the below query, the session got the below errors exactly after 1 hour. I checked profile, resource limit, and sqlnet.expire_time. The SQLNET.EXPIRE_TIME value is 10. Except expire time there is time limit in profile and resource. I dont know how this session is losting connection exactly after 1 hour. What could be the issue here and what else need to check it?

14:34:09 SQL> << DELETE query >>
ERROR:
ORA-03114: not connected to ORACLE
DELETE FROM amsoftinstall

[code]...

SQL> select * from V$RESOURCE_LIMIT;

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- ---------------------------------------- -------------------------
-------
processes 37 49 150 150
sessions 44 56 170 170

[code]...

SQL> select * from USER_RESOURCE_LIMITS;

RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED

[code]...

View 1 Replies View Related

Networking And Gateways :: TNS-12542 / Address Already In Use

Aug 23, 2007

I'd got this error, TNS-12542, address already in used on my multithreaded application.

After finding some documents about this error, it happen because other application used same port as my listener. But i'd assured that only my listener, but it didn't happen in the first running process, but after some processes (hundreds of processes).

View 4 Replies View Related

Networking And Gateways :: ISP Concept In Oracle?

May 29, 2012

what is ISP concept in Oracle10g???

View 2 Replies View Related

Networking And Gateways :: DBCA Installation Through VPN

Sep 22, 2011

I am facing a issue on DBCA Installation, when i tried from off-shore.

a. When Iam connecting a server using production / Model VPN , and try to start Installing DBCA Using X11-Forwarding of putty,
b. DBCA installation Started but its tooo Slow, it takes more than 3Hrs (Started at 9AM and ends at 11.17AM)
c. First time it fails and second time its went to success, Whereas when i take alog of server ping request - I am getting a frequent "Requested time out" due to network fluctuation.

So let me know is the network fluctuation affects the Installation through VPN, if So how to overcome and is any workaround on that ?

View 4 Replies View Related

Networking And Gateways :: Two Oracle Installs 10G And 11G

Jun 6, 2011

We're deploying a new product release however this build uses Oracle 11G. We want to perform a side by side install for testing purposes. These are low usage systems so installing another Oracle build will not hinder the system.

We intend to test for a couple of weeks and migrate data, then uninstall the 10G. I'm in the process of installing 11G now, the 10G is up and running. I don't want to impact the 10G install. I'm installing 11G in /home/oracle/oracle11G directory. I would like to use 1 Listener.ora file. I've broken down the install bellow.

10G
SID "processing"
Oracle home /home/oracle/oracle10g
/mnt/Oracle/Oracle10GData
/mnt/Oracle/OracleRedoLog

11G
SID "processing11G"
Oracle home /home/oracle/oracle11g
/mnt/Oracle/Oracle11GData
/mnt/Oracle/Oracle11GRedoLog

I've copied the listener.ora file bellow.

LISTENER_PROCESSING =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST= X (PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.2)(PORT = 1521))
[code].......

LISTENER_PROCESSING2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = X (PORT = 1522))
[code]......

Do I need to specify the databasename for Processing2? Also the front end boxes (managers) are two different servers so Processingweb1 and processingweb2.

View 1 Replies View Related

Networking And Gateways :: Oracle Gateway For MS SQL Server

Mar 11, 2013

I want to connect ORACLE-11gR2 that is on linux with an MS sql server. DO i need to use some third party drivers like easy soft ? Can i configure the database gateway without any third party drivers ?

Secondly if my oracle is on linux, can i configure the gateway on a seperate windows machine(that will connect to linux oracle and ms sql server) as i have found the gateway installation setup only for windows version.

View 3 Replies View Related

Networking And Gateways :: Connect Time Fail Over?

Mar 12, 2010

I would like to implement connect time fail over from my JDBC thin client. The client will try to first connect with dedicated connection mode, if the connection time crosses more than two seconds, then connection will be opened with shared mode. To implement this, I have put the following connection string in my JDBC URL. I am able to connect to database with this URL, however it seems fail over does not work. Is it because, my database listener is not configured with dynamic service registration. If I implement the dynamic service registration, is fail over going to work? Note, I want to fail over in the same database instance but with different listener.

(DESCRIPTION_LIST =
(FAILOVER = TRUE)
(LOAD_BALANCE = FALSE)

[Code].....

View 11 Replies View Related

Networking And Gateways :: Listener Dynamic Registration

Jan 3, 2012

Which parameters are required in init file for 'Dynamic Listener Registration'? (for default port/ protocol). I understand that Local_listener is required only if we are using not default protocol, port.

Also which cases we need listener.ora file? I understand we need it for 'Duplicate Database' using RMAN as well as for 'Data Guard'. what else will need it?

View 4 Replies View Related

Networking And Gateways :: Deletion Of LDAP Entry

Nov 25, 2010

We had an escalation wherein one of team members accidentally deleted an LDAP entry for a database. We use Oracle Net Manager to add/delete the connect descriptor.

Are there any logs using which we can find out as to who deleted the entry.

View 1 Replies View Related







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