OraFAQ Forum: Enterprise Manager » Problem starting database.

Home » RDBMS Server » Enterprise Manager » Problem starting database. (10g, RHEL4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem starting database. [message #310568]

Tue, 01 April 2008 12:41

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.

Report message to a moderator

Re: Problem starting database. [message #310769 is a reply to message #310568]

Wed, 02 April 2008 06:28

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You need to start the dbconsole process:

emctl start dbconsole

Report message to a moderator

Re: Problem starting database. [message #310919 is a reply to message #310568]

Wed, 02 April 2008 19:01

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.

Report message to a moderator

Re: Problem starting database. [message #310923 is a reply to message #310919]

Wed, 02 April 2008 19:39

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Do you have iptables running?

Report message to a moderator

Re: Problem starting database. [message #311599 is a reply to message #310923]

Sat, 05 April 2008 00:09

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?

Report message to a moderator

Re: Problem starting database. [message #313764 is a reply to message #311599]

Mon, 14 April 2008 08:26

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

Report message to a moderator

Re: Problem starting database. [message #313880 is a reply to message #310568]

Tue, 15 April 2008 00:24

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

POst the output of,

lsnrctl status
emctl status dbconsole

Report message to a moderator

Re: Problem starting database. [message #315203 is a reply to message #310568]

Sat, 19 April 2008 21:34

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

Report message to a moderator

Re: Problem starting database. [message #315204 is a reply to message #310568]

Sat, 19 April 2008 21:51

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

Report message to a moderator

Re: Problem starting database. [message #315206 is a reply to message #315203]

Sat, 19 April 2008 22:17

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.

Report message to a moderator

Re: Problem starting database. [message #315208 is a reply to message #310568]

Sat, 19 April 2008 22:27

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.

Report message to a moderator

Re: Problem starting database. [message #315209 is a reply to message #315208]

Sat, 19 April 2008 22:32

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

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.

Report message to a moderator

Previous Topic:	I wanted to connect Enterprise manager with HTML
Next Topic:	OEM error VBO-1508

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 18:03:20 CST 2024