GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL Plus
Go To First  |  Previous Question  |  Next Question 
 SQL Plus  |  Question 96 of 132    Print  
4)what is the process of connecting to Database manually in oracle Database

  
Total Answers and Comments: 2 Last Update: February 24, 2006     Asked by: kiranbtech01 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 09, 2006 03:18:56   #1  
rajat dey        

RE: 4)what is the process of connecting to Database ma...

in oracle 7.1.6

unix enviournment

sqldba lmode y

connect internel

statup

oracle 7.3.4 and 8i

svrmgrl

connect internel

statup

in 9i

sqlplus /nolog

connect /as sysdba

startup

u can use option like alter database open

startup mount /nomount


 
Is this answer useful? Yes | No
February 24, 2006 02:58:07   #2  
Shankar        

RE: 4)what is the process of connecting to Database ma...

The startup of database depends on the nature of Oracle server :

Incase Of Enterprise Server and Unix Environment :

Go to Unix and type the following commands :

sqldba lmode y

connect internal

startup

This will start the Oracle Instance.

Incase Of Workgroup Servers and Unix Environment :

Start the Listeners in One of the Sessions of the Unix Server

Go to Unix and type the following commands :

svrmgrl

connect internal

(This will prompt for a password Type d password as Manager)

startup

This will start the Oracle Instance.


 
Is this answer useful? Yes | No

 Related Questions


 Sponsored Links

 
Related Articles

Welcome to GeekInterview

GeekInterview.com is an Open Database where you can share interview quesitons, comment/answer any questions without any registration just by providing name and optional email address. Your email address will not be displayed on the site. If you have any specific questions is not on the site, email u
 

C Sharp Interview Questions Updated

Thanks to the site visitor Mike for sending the C# Interview Questions.  You can find the latest questions here. C# Interview QuestionsPlease use the "Submit Questions" , if you would like to share any questions from you interviews.
 

Best Answers to the 201 Most Frequently Asked Interview Questions

The most crucial part of your job search is knowing how to respond to the toughest interview questions u because the best candidate doesn't necessarily get the job....the best interviewee does! You need Microsoft Reader for Desktop and Laptop PC to read this. Please note that you can just read the b
 

50 Common Problems With Resumes and Cover Letters

The Resume Makeover: 50 Common Problems With Resumes and Cover Letters: This guide offers readers vital career information but with a solution-oriented approach. "No matter how much you think you know about writing resumes, you'll learn something new. I'd recommend this book to anyone conductin
 

Executive Resumes

Advice for upper-level managers and executives. Browse through sample executive resumes.by ResumeEdge.com - The Net's Premier Resume Writing and Editing ServiceExecutive resume formats generally have: A more conservative appearance. A separate area showcasing Career Accomplish
 

Fearless Interviewing - How to Win the Job by Communicating with Confidence

A job interview is one of life's most stressful and challenging experiences. Fearless Interviewing presents a strategic approach to interviewing, one that tips the scales back in favor of the job applicant. It provides useful advice on all aspects of the interviewing process, including how to: Produ
 

201 Killer Cover Letters

Job-search guide provides online job-search techniques and tips for transferring skills across industries. Includes sample letters for every possible job-hunting situation, tips on customizing and targeting letters for maximum impact, and techniques for using the cover letter to overcome 'objectiona
 

201 Best Questions To Ask On Your Interview

Packed with 201 proven questions, including examples of some of the smartest and dumbest interview questions from hundreds of recruiters, job coaches, hiring managers, and Fortune 500 human resources professionals, this hands-on guide gives you the edge you need. Publisher: McGraw-Hill; ISBN: B00006
 

Oracle Apps 11i ERP Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief history of ERP, Why is it necessary, Market Leaders and the future of ERPWhat is ERP? Enterprise Resource Planning or ERP is an industry term for integrated, multi-module application software packages that are designed to serve an
 

Oracle Apps 11i - Overview of popular ERP Products

This tutorial explains about different ERP Products and how they are being used in the industry. Oracle E- Business SuiteOracle E-Business Suite is the industry's only complete and integrated set of enterprise applications, working together seamlessly to streamline every area of your business—
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape