- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Can't start oracle db
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 05:02 AM
тАО06-23-2003 05:02 AM
Can't start oracle db
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 05:14 AM
тАО06-23-2003 05:14 AM
Re: Can't start oracle db
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 05:27 AM
тАО06-23-2003 05:27 AM
Re: Can't start oracle db
The required message file consist of a facility and a language string.
$ find $ORACLE_HOME -name "
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/
If the file is not on the system, something went wrong during the installation
or the file might have been removed.
Alexander.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 05:29 AM
тАО06-23-2003 05:29 AM
Re: Can't start oracle db
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 05:34 AM
тАО06-23-2003 05:34 AM
Re: Can't start oracle db
Thanks for your help!
-Bryan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 05:36 AM
тАО06-23-2003 05:36 AM
Re: Can't start oracle db
$ 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 06:00 AM
тАО06-23-2003 06:00 AM
Re: Can't start oracle db
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 07:38 AM
тАО06-23-2003 07:38 AM
Re: Can't start oracle db
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 08:57 AM
тАО06-23-2003 08:57 AM
Re: Can't start oracle db
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2003 10:04 AM
тАО06-23-2003 10:04 AM