Oracle Patchset Issue

[dontinou]

OK got a little farther:

- I found the alert.log, see attached (alert_orcl_startup_error.txt) for what I get when I run startup
- I was able to get the instance up if I run startup upgrade, see attached log (alert_orcl_startup_upgrade_noerror.txt)
- I figure why not try to recreate the EM repository, it gets farther now, but it keeps telling me I'm not giving it the right password!! (I am sure I am)
- EM page obviously still cannot talk to the db instance
- Trying to run a normal startup after running startup upgrade (after a shutdown) still does not work

Here's the output:

D:\oracle\product\10.2.0\db_1\BIN>emca -config dbcontrol db -repos recreate

STARTED EMCA at Dec 27, 2010 3:34:37 PM EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
This will remove the existing configuration and the default settings and perform a fresh configuration

----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Listener port number: 1521
Password for SYS user:
Password for SYS user: Dec 27, 2010 3:34:53 PM oracle.sysman.emcp.DatabaseChecks validateUserCredentials
SEVERE: Enterprise Manager Configuration is not supported in database restricted mode.

Password for DBSNMP user:

Dec 27, 2010 3:35:38 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
WARNING: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Dec 27, 2010 3:35:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
WARNING: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Password validation failed. Some of the possible reasons may be:

1) Invalid username/password.
2) Password file may be missing or configured incorrectly.
Password for DBSNMP user:
Password for DBSNMP user: Dec 27, 2010 3:35:48 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
WARNING: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Dec 27, 2010 3:35:51 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
WARNING: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Password validation failed. Some of the possible reasons may be:

1) Invalid username/password.
2) Password file may be missing or configured incorrectly.
Password for DBSNMP user:

------

So my questions are:

1. What does it mean when I have to start the database with startup upgrade?

2. Why did this happen after the 10.2.0.5 patchset upgrade when everything was fine before?

3. How do I get the database back to normal?

Thanks!!