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


ADVERTISEMENT

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

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

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

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

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

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

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

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

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

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

Server Administration :: How To Change The Character Set

Feb 24, 2012

what's your method,when you want to change the character set ?

View 3 Replies View Related

Server Administration :: How To Change DB Timezone Parameter

Aug 31, 2010

How to change db timezone parameter. My application team has asked me to change the db timzone parameter by following sql.

ALTER database SET TIME_ZONE = '+10:00';

Is this way is the correct one , and do we have any impact on database and does it require a db bounce.

View 2 Replies View Related

Server Administration :: How To Change Default XML Storage

Sep 21, 2012

As per the bellow the default XML storage has been changed in 11gr2.

docs.oracle.com/cd/E11882_01/appdev.112/e10492/whatsnew.htm

Quote:
Oracle Database 11g Release 2 (11.2.0.2) New Features in Oracle XML DB

The following Oracle XML DB features are new in Oracle Database 11g Release 2 (11.2.0.2).

Default Storage Model for XMLType

The default XMLType storage model is used if you do not specify a storage model when you create an XMLType table or column. Prior to Oracle Database 11g Release 2 (11.2.0.2), unstructured (CLOB) storage was used by default. The default storage model is now binary XML storage.

We have a application which works fine on r1 but not on r2 due to this change, we are going to investigate resolving the issue on the application in the future, in the mean time we need to be able to use the CLOB storage.

Does any one know where we can change this functionality back to the pre 11gR2 change?

View 7 Replies View Related

Server Administration :: Change Database Character Set?

Jan 25, 2013

Currently my oracle database character set is we8mswin1252 and it is only containing English data as well as spatial data (which is in English of course). I would like to change the Database character set so it could accept Arabic characters.

I have checked the below command on a test DB and it worked fine, but I want to know if it's recommended as a best practice when changing the character set to accept arabic and this won't corrupt my old entered Data ?

SHUTDOWN IMMEDIATE
STARTUP RESTRICT
ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256
SHUTDOWN IMMEDIATE
STARTUP

View 11 Replies View Related

Server Administration :: Database Version Change?

Feb 6, 2010

i have a oracle server installed enterprise edition, for some reation i need to degrade the version from enterprise to standard

i need same tablespace,data's everything same as of now.

View 8 Replies View Related

Server Administration :: Can't Change The Parameters Resource_manager_plan

Jul 11, 2011

I can not change the parameters RESOURCE_MANAGER_PLAN, at first, I set the parameters to DAYTIME,but when I restart my db,the parameters hold old values named MAXCAP_PLAN. Why?

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

[code]....

View 5 Replies View Related

Server Administration :: What Will Be The Impact If OS Version Change

Dec 21, 2010

Which config file is used to change the os version(RHEL 4.0 to RHEL 5.5) by OS admin what will be its impact on ORACLE Databases.

View 3 Replies View Related

Server Administration :: 10g Change Disk With Datafiles

Nov 17, 2011

What is best practice to change small disk D:? I am beginner with Oracle. 10g on W2008. 5 datafiles (all indexes,second data file, 2 undotabs)*.dbf (34;30;1;34;12 GB) is on D:. Part of tablespaces (1 data, 1 undo)has files on c:.

I.
1.Shutdown 2008 server.
2.Copy D: image with GHOST to USB, network.
3.Connect new D, create RAID.
4.Restore image to D.
5.Start 2008 server.

II.
1.Stop application.
2.CONNECT AS SYSDBA
3.SHUTDOWN NORMAL or (IMMEDIATE)?
4.Copy files *.dbf at OS level from d: to ... USB disk, network.
5.Shutdown 2008 server.
6.Change disks, create RAID in BIOS.
7.Start W2008.
Is Oracle at this moment in SHUTDOWN mode?
8.Copy back *.dbf to new D: (with directory structure).
9.STARTUP Oracle.

View 1 Replies View Related

Server Administration :: Change SGA_TARGET And SGA_POOL_SIZE Parameters

Aug 31, 2010

When I was going through the Enterprise Manager Grid Control, I found an error due to which I looked at the trace file and it said:

ORA-07445: exception encountered: core dump ACCESS_VIOLATION unable_to_trans_pc PC:0x7C81BD02 ADDR:0x49444E49 UNABLE_TO_READ]

I searched and found that it has something to do with the SGA parameters. I saw that the shared_pool_size and the sga_target paramters are set to 0...Also there are certain SQLs hanging at some point. I thought I should change the above mentioned parameters.

My question now is, can I use the Alter System statements from the SQL Plus to change these parameters, and do they change immediately or do I need to reboot the Oracle instance for those changes to take effect? I would like to do:

alter system set sga_target=400m;
alter system set shared_pool_size=200m;

would these work and take effect immediately?

View 5 Replies View Related

Server Administration :: Trying To Change Tablespace And Datafile Properties On Fly

Aug 21, 2011

This facility has one last 10g database and a very problematic tablespace and last datafile associated with it. The tablespace was set up with INITIAL_ EXTENT of 131,072 (128K) instead of the more 'normal' 4,194,304 (4M) and NEXT_EXTENT of 262,144 (256K) instead of 4,194,304 (4M).

More worryingly, the datafile has INCREMENT_BY set to 1 (8K) instead of 1,280 (10M) or 2,048 (16M).Has anyone ever updated sys.ts$.dflinit and sys.ts$. dflincr to modify the INITIAL_EXTENT and NEXT_EXTENT, and sys.file$.inc to modify the INCREMENT_BY?

View 7 Replies View Related

Server Administration :: How To Alter / Change Size Of Tablespaces

Feb 26, 2013

1-how can i alter/change the size of tablespaces?.

2-is any changing in tablespace size will effect the over all performance?

Tablespace ; Size (MB); Free (MB); % Free; % Used
------------------------------;----------;----------;----------;----------
USERS ; 5; 4; 80; 20
SYSAUX ; 600; 140.875; 23; 77
UNDOTBS1 ; 640; 114.125; 18; 82
SYSTEM ; 700; 28.3125; 4; 96
TEMP ; 64; 0; 0; 100

View 4 Replies View Related

Server Administration :: Uncommit Change And Redo Record?

Feb 22, 2013

SQL> update t set a = 1 where b = 2; -- must have redo record
2 rows updated.
SQL> rollback;

the above redo record that uncommit changed must be written from redo buffer to the online redo logfile. why Oracle write the redo record that uncommit changed to the online redo logfile ? when it will be used?

View 10 Replies View Related

Server Administration :: Renaming Datafile - Change Name In OS Level Also

Nov 3, 2012

While renaming the datafile.

1) ALTER TABLESPACE .... OFFLINE;

2) CHANGING THE DATAFILE NAME IN OS LEVEL;

3) ALTER TABLESPACE .... RENAME DATAFILE 'FILE_OLD' TO 'FILE_NEW';

4) ALTER TABLESPACE .... ONLINE;

In the above steps, I HAD FORGOTTON TO FOLLOW THE 2ND STEP.

At the step of 3rd, i got error message, now i am not able to change the name in OS level Also.

View 19 Replies View Related

Server Administration :: Change Parameter Value In Oracle 11gR2?

May 11, 2012

I want to change cursor_sharing, open_cursors and session_cached_cursors parameter values for SPFILE (Only SPFILE) using SQL Query.

I have found following SQL Queries, but I don't know these queries are only for SPFILE or not.

ALTER SESSION SET cursor_sharing='EXACT';
ALTER system set open_cursors=2500;
ALTER SESSION set session_cached_cursors=70;

I need SQL Queries only for SPFILE.

View 3 Replies View Related

Server Administration :: Change Character Set For Oracle 8i Databases?

Aug 15, 2013

How to change Character set for oracle 8i database. Is there anyway to change the Character set without affecting the current database.

View 11 Replies View Related







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