windows 2003 srv r2 sp2 and oracle 10g

[Database Administrator]

Hello!!

I've got a windows 2003 srv r2 sp2, and I just installed oracle 10g.
Only EM doesn't work, it shows Ready! , but it's only a blank page.
ISQL Plus works fine, also SQL Plus, and SQL plus console mode also
works fine.

What could I do to make EM works?

Thanks.

[Database Administrator]

On 7 Apr 2007 01:34:39 -0700, jmaycas@hotmail.com wrote:

>Hello!!
>
>I've got a windows 2003 srv r2 sp2, and I just installed oracle 10g.
>Only EM doesn't work, it shows Ready! , but it's only a blank page.
>ISQL Plus works fine, also SQL Plus, and SQL plus console mode also
>works fine.
>
>What could I do to make EM works?
>
>Thanks.

Likely you have a faulty install. Dbcontrol still relies, IIRC, on
Oracle Intelligent Agent, and Oracle Http Server/Apache.
You probably need to verify whether both work, and have been
configured correctly.
Likely OIA hasn't been configured correctly, because the Navigator
Tree relies upon the services OIA should discover.

If you are using a DHCP address for your server, make sure you have a
local loopback connector configured.

Hth
--

[Database Administrator]

On Apr 7, 4:34 am, jmay...@hotmail.com wrote:
> Hello!!
>
> I've got a windows 2003 srv r2 sp2, and I just installed oracle 10g.
> Only EM doesn't work, it shows Ready! , but it's only a blank page.
> ISQL Plus works fine, also SQL Plus, and SQL plus console mode also
> works fine.
>
> What could I do to make EM works?
>
> Thanks.

In addition to the suggestions provided by Sybrand, make certain that
you are attempting to access the Enterprise Manager Database Control
web interface with the correct port number - each database on the same
server will have a different port number.

Additionally, the database must be registered to be accessible, and
the OracleDBConsole service must be running. To register the
database, open a (DOS) command prompt and register the database with
the following command, substituting the correct information for each
TYPE_ entry (enter all on one line):
TYPE_FULL_PATH_TO_ORACLE_HOME_HERE\bin\emca.bat -config dbcontrol db -
silent -DB_UNIQUE_NAME TYPE_DB_SID_HERE -PORT TYPE_LISTENER_PORT_HERE -
EM_HOME TYPE_FULL_PATH_TO_ORACLE_HOME_HERE -LISTENER LISTENER -
SERVICE_NAME TYPE_DB_SID_HERE.TYPE_DB_DOMAIN_HERE -SYS_PWD
TYPE_SYS_PASSWORD_HERE -SID TYPE_DB_SID_HERE -ORACLE_HOME
FULL_PATH_TO_ORACLE_HOME_HERE -DBSNMP_PWD TYPE_DBSNMP_PASSWORD_HERE -
HOST TYPE_SERVER_NAME_HERE -LISTENER_OH FULL_PATH_TO_ORACLE_HOME_HERE -
LOG_FILE c:\emConfig.log -SYSMAN_PWD TYPE_SYSMAN_PASSWORD_HERE

The above command should have executed automatically if the database
were created with the Database Configuration Assistant. Note that you
can also use the old Java based Enterprise Manager from the 10g client
CD to manage many of the same types of operations as the web based
Enterprise Manager Database Control - in some ways it is much easier
to use.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

[Database Administrator]

(Hello again, Mr. Hooper! You answered my question last Feb. 2007 about
how to find out Oracle round trips. The subject was "How to count round
trips from ADO via OraOLEDB to Oracle?")

Is there a way to find out which HTTP port is currently in use by the
database control? The install/portlist.ini file lists the ports
established at install time, but one of my ports isn't working anymore.
The "status" option on the emctl program doesn't report ports. The
displayConfig option on emca seems to apply only to clusters, but I'm
not using any clusters.

More to the point, how can I find out why the HTTP port used by Oracle
Enterprise Manager Database Control is no longer working for one of the
databases on this server?

-- Phil Davidson
phil _at_ ivorycc _dot_ com
phil _at_ phildavidson _dot_ com

In comp.databases.oracle.server, "Charles Hooper"
wrote:

....

In addition to the suggestions provided by Sybrand, make certain that
you are attempting to access the Enterprise Manager Database Control
web interface with the correct port number - each database on the same
server will have a different port number.

....

[Database Administrator]

On Jan 7, 1:17*pm, Phil Davidson wrote:
> (Hello again, Mr. Hooper! You answered my question last Feb. 2007 about
> how to find out Oracle round trips. The subject was "How to count round
> trips from ADO via OraOLEDB to Oracle?")
>
> Is there a way to find out which HTTP port is currently in use by the
> database control? The install/portlist.ini file lists the ports
> established at install time, but one of my ports isn't working anymore.
> The "status" option on the emctl program doesn't report ports. The
> displayConfig option on emca seems to apply only to clusters, but I'm
> not using any clusters.
>
> More to the point, how can I find out why the HTTP port used by Oracle
> Enterprise Manager Database Control is no longer working for one of the
> databases on this server?
>

On the Windows platform, open a command prompt and type:
netstat -a -o >c:\ports.txt

The above will generate a list of all ports, including the listening
ports (State will show Listening); open the file in Notepad. The
Windows PID will also be listed, which is the process ID that is
listening on the port. In the Task Manager, edit the columns
displayed to include the PID, so that you can determine the name of
the process that opened the port and is listening on that port. On my
system, the Enterprise Manager Database Control process name is listed
as Java, and most seem to have a port in the range of 5500 and above,
although ports in and around 1158 may also be used.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

[Trellian]

I had the same problem, and it turned out to just be a problem with the browser security settings. in IE, go to "Tools|internet options|Local Intranet" and add your fully qualified machine name to the list of sites, eg http://orcl.mycompany.local:5500/em

Occams Razor.

Good Luck
Adrian Velcich