- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Checking whether an oracle instance is configu...
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
тАО08-28-2001 06:09 PM
тАО08-28-2001 06:09 PM
I have a question on checking whether an oracle instance is configured or not. Given the instance name, I can check whether the instance is running or not using svrmgrl. If the given instance is not running, next thing I need to do is to check whether the instance is configured for oracle or not. For this I currently check whether the init$ORACLE_SID.ora file is present or not. But, I do not find this very efficient as presence of this file just does not mean that the oracle instance is configured completely. Is there any other way of checking this?
Regards,
Vinu
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2001 08:31 PM
тАО08-28-2001 08:31 PM
Re: Checking whether an oracle instance is configured or not
and it hard to say that it is proper configure or not !!
then you just check for all oracle process of that instance was all up is enough.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2001 11:09 PM
тАО08-28-2001 11:09 PM
Re: Checking whether an oracle instance is configured or not
I just do a; ps -ef |grep pmon
(or smon)
as these processes get started as the database is opened.
Then you get a list of all your running databases on your machine.
I miss the svrmgrl message from Oracle7 that said; "Connected to an idle instance."
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2001 02:31 AM
тАО08-29-2001 02:31 AM
Re: Checking whether an oracle instance is configured or not
To check if the instance is running :
#su - oracle
#svrmgrl
SVRMGR>connect internal
SVRMGR> select instance_name from v$instance;
Will reports the oracle active instance .
Magdi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2001 02:36 AM
тАО08-29-2001 02:36 AM
Re: Checking whether an oracle instance is configured or not
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2001 02:57 AM
тАО08-29-2001 02:57 AM
Re: Checking whether an oracle instance is configured or not
you can check if datafiles exists for this database.
If you know nothing at all about this database, you will have to check the init.ora file for references to control files and alert files (background_dump_dest directory).
regards,
Thierry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2001 03:56 PM
тАО08-29-2001 03:56 PM
Solutioninstallation) for an entry for the SID. If it is there and
the third field is Y then you may have problems starting
and stopping the system if the database isn't configured.
The init
files used by the database. The init
$ORACLE_HOME/dbs is usually a soft link back to
a real file in $ORACLE_HOME/admin/
If the database has been configured then all the
files in the entry control_files will have been created.
The direcory $ORACLE_HOME/admin/
should contain the database create scripts. One
script should have a create database entry listing
the database files. If these exist the database
has been configured.
If the create scripts aren't found look files
like system01.dbf, temp01.dbf, redo01.dbf, and redo02.dbf in the directories where the control files were created. If these are there then the database
has been configured.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2001 08:57 AM
тАО08-30-2001 08:57 AM
Re: Checking whether an oracle instance is configured or not
One or more databases may in the past have been "configured" at some time in the past, but if all the required files are not still there then you cannot start up the instance fully.
You can search the system for the relevant files all you like, but the only sure-fire way is to try to start up the instance and see if it works.
export ORACLE_SID=
svrmgrl
connect internal
startup
Good luck
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-04-2001 03:29 AM
тАО09-04-2001 03:29 AM
Re: Checking whether an oracle instance is configured or not
export ORACLE_SID=instance_name
svrmgrl
connect internal
select * from v$instance;
select status,database_status from v$instance;
From OS you can use
#ps -ef|grep ora|grep
Thanks
G Manikandan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-04-2001 08:21 AM
тАО09-04-2001 08:21 AM
Re: Checking whether an oracle instance is configured or not
Check your /etc/oratab file
...jcd...