1748245 Members
3812 Online
108760 Solutions
New Discussion юеВ

Can't start oracle db

 
Bryan_46
Advisor

Can't start oracle db

Hello,

I am having a problem starting my oracle db. When I try to connect to the db vi svrmgrl, I get this message:

$ svrmgrl

Oracle Server Manager Release 3.0.6.0.0 - Production

Message 4505 not found; No message file for product=SVRMGR, facility=MGR

Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.6.0.0 - Production

SVRMGR> connect system/manager
ORA-01034: ORACLE not available
SVRMGR>
Message 37 not found; No message file for product=SVRMGR, facility=MGR

From what I have read in the forums, this 4505 error would indicate that I do not have my $ORACLE_HOME env variable set, or that $ORACLE_HOME/bin is not in my path. This is not the case, I have done both of these things as well as set the $ORACLE_SID=openview. I get the message that I have already created the db when using the opcdbsetup command, but it quickly fails there after with a similar error as when I try to start it manually. Does anyone have any clue as to what could be the problem here?

Any help would be appreciated, THANKS!
9 REPLIES 9
Massimo Bianchi
Honored Contributor

Re: Can't start oracle db

Hi,
from the name this is oracle for openview, correct?


with which user did you installed the db ?
are all the files properly accessible ?

Also have a look at the NLS_LANG, because it points to a directory, and if it is not accessible you can have such problems.

HTH,
Massimo
Alexander E. Ivanov
Frequent Advisor

Re: Can't start oracle db

Hi,

The required message file consist of a facility and a language string.

.msb

$ find $ORACLE_HOME -name ".msb"

If the required filename exists on the system, the environment variable
ORACLE_HOME might not be correct. Under normal circumstances the required file
for the facility 'MGR' should be under $ORACLE_HOME/svrmgr/mesg/.msb.

If the file is not on the system, something went wrong during the installation
or the file might have been removed.

Alexander.
Bryan_46
Advisor

Re: Can't start oracle db

WOW! As I looked at your suggestion, I tried to do a chgrp -R dba * in my $ORACLE_HOME directory and I received hundreds of error messages "No such file or directory" from the $ORACLE_HOME/link directory. It seems like everything is a link to /cdrom in that directory (which is not currently mounted). Are these just left over from the installation of oracle for openview, or should there be actual files there?

Another point was the NLS_LANG env variable. I have it set to american.america.WE8ISO8859P1 right now. I tried american_america.WE8ISO8859P1 and a few other with no success. Where do I find these directories that NLS_LANG points to? It could be that they don't exist, but I don't know where to look to verify.....


Thanks,
Bryan
Bryan_46
Advisor

Re: Can't start oracle db

I think that perhaps something went wrong with the installation. I am going to try uninstalling everything, then reinstalling. I will repost when I am finished with the results.

Thanks for your help!

-Bryan
Steven Gillard_2
Honored Contributor

Re: Can't start oracle db

Problems locating the message catalog files are usually either ORACLE_HOME or NLS_LANG setting problems. Try using the oerr command, it may give some more detailed information, eg:

$ oerr mgr 4505
4505, 0, "Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved."

Also, to start the database you must "connect internal". Connecting as the system user won't work if the DB isn't running.

What is the similar message you get when running the opcdbsetup command?

Regards,
Steve
Massimo Bianchi
Honored Contributor

Re: Can't start oracle db

Hi,
sorry, i did a little mistake (too few sleep).

I intended to indicate the ORA_NLS* family,
here, is mine.
ORA_NLS=/oracle/D01/817_64/ocommon/NLS_723/admin/data
ORA_NLS32=/oracle/D01/817_64/ocommon/NLS_733/admin/data
ORA_NLS33=/oracle/D01/817_64/ocommon/nls/admin/data
NLS_LANG=AMERICAN_AMERICA.WE8DEC

Check also this directory.

As for the link: i never had a "link" directory, but sound quite strange.
Usually all software must be local and installed.

HTH,
Massimo





Martin Johnson
Honored Contributor

Re: Can't start oracle db

From your Oracle user, do:

set | grep ORACLE
set | grep NLS

you should see something like:
ORACLE_BASE=/opt/OV/oracle
ORACLE_HOME=/opt/OV/oracle/products/8.1.7
ORACLE_SID=openview
ORACLE_TERM=hp

ORA_NLS33=/opt/OV/oracle/products/8.1.7/ocommon/nls/admin/data

If you do "ll $ORACLE_HOME" you should see a list of directories.

Verify that you can see the directories. Otherwise your Oracle variables are not set up correctly.

HTH
Marty
twang
Honored Contributor

Re: Can't start oracle db

The error is consistent with $ORACLE_HOME/bin not being set in the PATH variable.
To ensure that the whole set of environment variables are being set before calling svrmgrl.
Try export following variables, then issue svrmgrl and see,
$ export ORACLE_SID=PROD
$ export ORACLE_HOME=/app/oracle/product/8.0.6
$ export PATH=$PATH:$ORACLE_HOME/bin
$ svrmgrl
Bryan_46
Advisor

Re: Can't start oracle db

Well, it appears that something must have gone wrong with the installation. After the reinstall I have some problems, but not the same ones. Thank all of you for your help!