OraFAQ Forum: Server Administration » DB control in Oracle10g

Home » RDBMS Server » Server Administration » DB control in Oracle10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB control in Oracle10g [message #216576]

Mon, 29 January 2007 08:43

muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai

Member

Hi,

I have installed oracle 10g in my machine. I started the EM database control and displayed the database screen of it. When i pressed startup button for the instance, it prompted for OS username & password. In my machine I didnt give any password for the osuser. In this case how to startup the instance from the database control in 10g.

Thanks in advance.

Regards
Murali

Report message to a moderator

Re: DB control in Oracle10g [message #216598 is a reply to message #216576]

Mon, 29 January 2007 11:21

aciolac
Messages: 242
Registered: February 2006

Senior Member

I have not big experience in 10G, but if to think - for starting database there are not necessary OS username/password - enough to be connected to database with the ORACLE username/password( AS SYSDBA). Verify yet once all - try to connect as sysdba to database, and try to start database.

Report message to a moderator

Re: DB control in Oracle10g [message #216667 is a reply to message #216576]

Mon, 29 January 2007 19:44

muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai

Member

Hi,

I am aware that we can start the database from command line. My problem is with database control loaded in internet explorer.

Regards
Murali

Report message to a moderator

Re: DB control in Oracle10g [message #216686 is a reply to message #216667]

Mon, 29 January 2007 22:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI,

you have to give "LOGON AS AN BATCH JOB" privs TO OS user.
start------->control panel--------->administrative tools---->local security policy---->user right and assignments --->"LOGON AS AN BATCH JOB".

add your OS for above privs.

and then try to connect.

regards
Taj

Report message to a moderator

Re: DB control in Oracle10g [message #219161 is a reply to message #216686]

Tue, 13 February 2007 07:41

muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai

Member

Hi,

I am using windows xp home edition. I am unable to find local security under administrative tools. Please let me know how to find it in windows XP OS.

Regards
Murali

Report message to a moderator

Re: DB control in Oracle10g [message #219176 is a reply to message #219161]

Tue, 13 February 2007 08:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
First I am not using Windows XP home edition.so i don't know more about XP HOME Features.
or
Oracle Database not support WINDOWS XP HOME EDITION.
It is support only windows XP PROFESSIONAL.

regards
Taj

Report message to a moderator

Re: DB control in Oracle10g [message #226317 is a reply to message #219176]

Fri, 23 March 2007 04:35

b_kareem@sify.com
Messages: 5
Registered: March 2007
Location: india

Junior Member

Logon to your window as administartor

open your dos prompt

set oracle_sid=dbname

sqlplus /nolog

connect / as sysdba
--it show connect to ideal instance

startup nomount
alter database mount
alter database open

Report message to a moderator

Re: DB control in Oracle10g [message #226323 is a reply to message #226317]

Fri, 23 March 2007 04:43

ebrian
Messages: 2794
Registered: April 2006

Senior Member

b_kareem@sify.com wrote on Fri, 23 March 2007 05:35

The OP was asking for how to start the database from Database Control. How is this going to help him/her ?

Report message to a moderator

Previous Topic:	Oracle Quiz Answers
Next Topic:	Can't execute dbconsole

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:40:43 CDT 2024