Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN startup fails after shutdown succeeds

783661Jul 9 2010 — edited Jul 23 2010
Oracle 11g, new at Oracle after inheriting this server (Windows 2008). I'm trying the basic RMAN to get a consistent backup of each of the two databases, with Backup / Recovery Manual notes:
RMAN> SHUTDOWN IMMEDIATE
RMAN> STARTUP FORCE DBA;
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP MOUNT;

then do the backup, then ALTER DATABASE OPEN and I'm back in business.
This works as expected on the test database. But on the production database I get:

RMAN> shutdown immediate
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

RMAN> startup force dba

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 07/09/2010 11:31:55
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Then I restart database service, listener service, and application service to get working again.
ORA-12514 advice said "llsnrctl services" to find which services are known.

The working test db shows up in the response with these 2 entries:
Service "UC4TEST" has 2 instance(s).
Instance "UC4TEST", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "uc4test", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:7 refused:0 state:ready
LOCAL SERVER

The erroring production db shows up with just one entry:
Service "uc4" has 1 instance(s).
Instance "uc4", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:16 refused:0 state:ready

I'm trying to find what this might mean, that there's not a second entry.

ORA-12514 code also says check llstener.log. My listener.log is 860MB (this may indicate some problem?), I haven't found my way into it yet. The databases are about 2GB and 4GB, just a few users, seems an awfully big listener log for a pretty small server

So what does the Listener not know, and why, and how I tell it? I thank you for any suggestions.
This post has been answered by ebrian on Jul 12 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2010
Added on Jul 9 2010
12 comments
3,691 views