Home » RDBMS Server » Enterprise Manager » Problem starting database. (10g, RHEL4)
Problem starting database. [message #310568] Tue, 01 April 2008 12:41 Go to next message
molloybe
Messages: 5
Registered: March 2008
Junior Member
First post, so hopefully i'm putting this in the right forum.

I'm pretty new to both Oracle and Redhat and recently installed Oracle 10g on my home machine. After the installation everything worked, and I could use the URL to login to Enterprise Manager. I'm currently working through getting everything to startup at boot. The problem I just ran into is a little odd though, after logging in, starting the listener, logging into sql, starting/mounting the database, i get nothing when i try to use the Enterprise Manager URL. It's not giving any sort of Invalid URL/Can't Connect error...it's just loading a blank screen. Any help would be greatly appreciated.
Re: Problem starting database. [message #310769 is a reply to message #310568] Wed, 02 April 2008 06:28 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You need to start the dbconsole process:
emctl start dbconsole
Re: Problem starting database. [message #310919 is a reply to message #310568] Wed, 02 April 2008 19:01 Go to previous messageGo to next message
molloybe
Messages: 5
Registered: March 2008
Junior Member
I tried that, and I still seem to be having a problem. I'm sure i'm missing something obvious. Embarassed

All my status checks look ok:
------------------------------------------
emctl status dbconsole
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://localhost.localdomain:5500/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------
Agent is Running and Ready
------------------------------------------
lsnrctl status
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
------------------------------------------

But i'm still not getting anything other than a blank page. I was getting a message about "EM Daemon is not running" with the dbconsole status, but that's gone away.

thanks again for any help.
Re: Problem starting database. [message #310923 is a reply to message #310919] Wed, 02 April 2008 19:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Do you have iptables running?
Re: Problem starting database. [message #311599 is a reply to message #310923] Sat, 05 April 2008 00:09 Go to previous messageGo to next message
molloybe
Messages: 5
Registered: March 2008
Junior Member
I did have it running, but the firewall was disabled. I've turned it off since, but i'm still having the same problem.

I did notice this when i run dbstart though:
---------------------------------------------------------
SQL*Plus: Release 10.1.0.2.0 - Production on Sat Apr 5 01:02:44 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> ERROR:
ORA-12162: TNS:net service name is incorrectly specified

SQL> ORA-12162: TNS:net service name is incorrectly specified
SQL>
Database "" warm started.

SQL*Plus: Release 10.1.0.2.0 - Production on Sat Apr 5 01:02:44 2008

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

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162275532 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Release 10.1.0.2.0 - Production

Database "orcl" warm started.
---------------------------------------------------------

I'm guessing that those errors and the "Database "orcl" warm started" message may be something worth investigating?
Re: Problem starting database. [message #313764 is a reply to message #311599] Mon, 14 April 2008 08:26 Go to previous messageGo to next message
Mahyaa
Messages: 3
Registered: April 2008
Junior Member

It's just a guess and sorry , it's not related to oracle .
Have you tried checking if it listed in "trusted" list of IE ?

I had the same problem with Windows 2003 and that was the reason .

Good Luck

Re: Problem starting database. [message #313880 is a reply to message #310568] Tue, 15 April 2008 00:24 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

POst the output of,

lsnrctl status
emctl status dbconsole
Re: Problem starting database. [message #315203 is a reply to message #310568] Sat, 19 April 2008 21:34 Go to previous messageGo to next message
molloybe
Messages: 5
Registered: March 2008
Junior Member
lsnrctl status:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.1.0.2.0 - Production
Start Date 19-APR-2008 22:27:52
Uptime 0 days 0 hr. 1 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log File /app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=5500)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-----------------------------------------------------------

emctl status dbconsole:

TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://localhost.localdomain:5500/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /app/oracle/product/10.1.0/db_1/localhost.localdomain_orcl/sysman/log
Re: Problem starting database. [message #315204 is a reply to message #310568] Sat, 19 April 2008 21:51 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

in SQL plus run ,

alter system register;

and paste the output of lsnrctl status
Re: Problem starting database. [message #315206 is a reply to message #315203] Sat, 19 April 2008 22:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
DB console can start regardless of your listener status or database status. In addition, trying to register the database isn't going to do any good in your case.

Try to change your listener port to 1521 and stop/start your listener and then stop/start dbconsole again.
Re: Problem starting database. [message #315208 is a reply to message #310568] Sat, 19 April 2008 22:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I just answer that his
Quote:
lsnrctl status
command. It is not showing any available service. Alter alter system register it will show the available service.

And I considered myself his Datbase control is ok after getting the message,
Quote:
Oracle Enterprise Manager 10g is running.
Re: Problem starting database. [message #315209 is a reply to message #315208] Sat, 19 April 2008 22:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Arju wrote on Sat, 19 April 2008 23:27
Alter alter system register it will show the available service.

Not unless the OP has the appropriate database parameter set for the listener.

[Updated on: Sat, 19 April 2008 22:33]

Report message to a moderator

Re: Problem starting database. [message #317828 is a reply to message #315204] Sat, 03 May 2008 23:57 Go to previous message
molloybe
Messages: 5
Registered: March 2008
Junior Member
Sorry it's taken me so long to respond to everybody's suggestions...i was away for a few weeks.

I tried the alter system register command, but the lsnrctl status stayed the same.

I also tried switching my port to 1521. (As far as I know, the only places i need to change that are in listener.ora and tnsnames.ora, correct?) But unfortunately, i'm still having the same problem.
Previous Topic: I wanted to connect Enterprise manager with HTML
Next Topic: OEM error VBO-1508
Goto Forum:
  


Current Time: Tue Dec 06 04:51:53 CST 2016

Total time taken to generate the page: 0.12438 seconds