How to change Oracle XE default hostname and DB ports

How to change Oracle XE default hostname and DB ports

Stop listener in command window:
lsnrctl stop
Modify ORACLE_HOME/app/oracle/product/10.2.0/server/NETWORK/ADMIN/listener.ora
LISTENER =
(DESCRIPTION_LIST =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <port number>))
 )
)
Change the PORT to the number wanted. Also modify PORT in tnsnames.ora and save.
Start listener:
lsnrctl start
Run SQL Plus to add local listener for that port, then change HTTP listening port:
conn system/password;
alter system set local_listener = "(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port number>))";
exec dbms_xdb.sethttpport(<port number>);
alter system register;
disc;
If "set local_listener" is omitted, you probably will get get "ORA-12514: TNS:listener does not currently know of service requested when openning SQL Plus with sqlplus system@xe

alter system register" is also important as it reregisters the DB and all services with the listener. Otherwise you can find the port is not listening with netstat -an. Also you can verify with lsnrctl status, and a line like following should be there:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=nnnn))(Presentation=HTTP)(Session=RAW))
Confirm:
select dbms_xdb.gethttpport as "HTTP Port",
dbms_xdb.getftpport as "FTP Port" from dual;

Ref: http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/network.htm#BHCCDEIH

Comments

Post a Comment

Popular posts from this blog

React JS

Enable Intellisense for React component in VS code Run below command: npm i @types/react --save-dev How to write the scripts in package.json file NPM is package manager used to install delete and update JavaScript packages on your machine. NPX is package executor and it is used to execute JavaScript packages directly without installing it. To build scripts in package.json file use scripts sections, "scripts" : {     "build" : "parcel build index.html" ,     "start" : "parcel index.html"   }
Read more

WaterMark behavior in ADF

Image
How to create watermark/placeholder effect for input component in ADF What is watermark behavior A watermark typically appears as light gray text within an input or textarea element whenever the element is empty and does not have focus. This provides a hint to the user as to what the input or textarea element is used for, or the type of input that is required. For example, a search input space sometimes appears at the top of the page, giving the user quick access to the search functionality. Oftentimes you will see the word "Search" in light gray text in that space, and when the user clicks into the entry space, the word disappears. That is an example of a watermark.    How to implement 1)     Create your tag library First step is to create tab lib in your project. Just select New à WebTier à JSP à JSP tag library ·          Select deployable or project based option   ·          Provide tag lib file name URI and version details  
Read more

WebLogic Application Deployment & Shared Library

Image
In an enterprise application deployment scenario, there are many cases where some libraries are used/referenced by multiple applications. It would indeed be a bad design to include such common libraries with every application deployed on the WebLogic server. Not only does it prevent redundancy of resources on the server, it also consumes valuable space & deployment time - especially when the libraries are huge. WebLogic server offers the shared library concept using which EARs, JARs, EJBs and WARs can be shared across applications in a WebLogic domain. Let us now see how to package and deploy a shared library in WebLogic server; Step 1: Create a folder structure as shown below Step 2: Copy all the libraries (in this case JAR files) that you would want to share across applications to the lib folder under WEB_INF Step 3: Create a file under META_INF folder by name "MANIFEST.MF" Step 4: Contents of the MANIFEST.MF file are shown below Manifest-Version: 1.
Read more