jUDDI's Lab: database

How to resolve "Several ports (8005, 8080, 8009) required by Tomcat Server at localhost are already in use"

Hi
Apache tomcat server default port is 8080. sometime Follow error occur when you running apache tomcat server "Several ports (8005, 8080, 8009) required by Tomcat Server at localhost are already in use" I can change port 8080 into server.xml for tomcat config. It is easy
so I will found What process running use in 8080?
If you are running on windows try this in the command line prompt: >netstat -a it's show all process You will find process with 8080 port

>netstat -aon It's show allo process with PID

Go to Task manager and find process by PID from process list. You'll know what process using port 8080. In my machine Oracle Database Express used to 8080 port. Default insttallation setting up port 8080.
How to change Oracle Database Express default port? Try this in the command line prompt:

>sqlplus / as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on Mi Jan 25 11:44:33 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL> -- get current status
SQL> select dbms_xdb.gethttpport as "HTTP-Port"
            , dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port   FTP-Port
---------- ----------
     8080          0


You can change the http port and the ftp port to whatever you

like (keep in mind that you need special privileges for ports < 1024 on Unix/Linux systems).


SQL> -- set http port and ftp port
SQL> begin
 2    dbms_xdb.sethttpport('80');
 3    dbms_xdb.setftpport('2100');
 4  end;
 5  /

PL/SQL procedure successfully completed.

SQL> select dbms_xdb.gethttpport as "HTTP-Port"
            , dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port   FTP-Port
---------- ----------
       80       2100

thanks Juddi

Oracle Database 11g Installing and create database on windows

I decided i wanted to post oracle database 11g install on window os. My laptop is running on windows 64 bit. I made screenshot for each step. i inserted those screenshot the post. next time I will post some information to install oracle db 11g on linux and Windows and Linux oracle db GUI install type is almost same.

1. You need to download oracle database 11g set up. You can download here
2. Go to install folder. execute setup.exe.

3. If you want to update you check it or unckeck

4. select one from these three install options:
a. create database and install db software
b. only install database install
c. you can upgrade an existing database
select a option.

5. Select Desktop class option.

6.You will perform a basic installation with a starter database. Enter mydb for the Global Database Name and oracle for Database Password and Confirm Password. Then, click Next.