4)what is the process of connecting to Database manually in oracle Database

Questions by kiranbtech01

Showing Answers 1 - 2 of 2 Answers

rajat dey

  • Feb 9th, 2006
 

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

  Was this answer useful?  Yes

Shankar

  • Feb 24th, 2006
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions