Home » RDBMS Server » Server Administration » DB control in Oracle10g
DB control in Oracle10g [message #216576] Mon, 29 January 2007 08:43 Go to next message
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
Re: DB control in Oracle10g [message #216598 is a reply to message #216576] Mon, 29 January 2007 11:21 Go to previous messageGo to next message
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.
Re: DB control in Oracle10g [message #216667 is a reply to message #216576] Mon, 29 January 2007 19:44 Go to previous messageGo to next message
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
Re: DB control in Oracle10g [message #216686 is a reply to message #216667] Mon, 29 January 2007 22:09 Go to previous messageGo to next message
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
Re: DB control in Oracle10g [message #219161 is a reply to message #216686] Tue, 13 February 2007 07:41 Go to previous messageGo to next message
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
Re: DB control in Oracle10g [message #219176 is a reply to message #219161] Tue, 13 February 2007 08:59 Go to previous messageGo to next message
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
icon6.gif  Re: DB control in Oracle10g [message #226317 is a reply to message #219176] Fri, 23 March 2007 04:35 Go to previous messageGo to next message
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
Re: DB control in Oracle10g [message #226323 is a reply to message #226317] Fri, 23 March 2007 04:43 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
b_kareem@sify.com wrote on Fri, 23 March 2007 05:35
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


The OP was asking for how to start the database from Database Control. How is this going to help him/her ?
Previous Topic: Oracle Quiz Answers
Next Topic: Can't execute dbconsole
Goto Forum:
  


Current Time: Mon Dec 05 14:57:07 CST 2016

Total time taken to generate the page: 0.19901 seconds