Home » RDBMS Server » Server Administration » Installation of 11gR2 on Windows (Oracle 11gR2, Windows)
Installation of 11gR2 on Windows [message #508726] Tue, 24 May 2011 04:44 Go to next message
geobraik
Messages: 34
Registered: April 2011
Member
Hi,
I referred the document http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r1/prod/install/dbinst/windbinst2.htm#o for installation of Oracle 11gR2 on windows 2008. I didnt create oracle user after the installation.
But later when I saw the document http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/prod/install/wininst/wininst_otn.htm#a I got a doubt that is the user oracle is to be created and to be added to ora_dba group.

Please clear my doubt.
I have created the database also after the installation. Since I didnt create the oracle user will it cause any problem? What shall I do now? Please suggest

Thanks in advance,
Geobraik
Re: Installation of 11gR2 on Windows [message #508876 is a reply to message #508726] Tue, 24 May 2011 14:34 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Create the oracle user, either local or network.
Grant administrator and "run batch jobs" privileges.
Add the user (local or network) to local ora_dba group.

If you want to execute sql scripts in batch command without having to provide (hard-code) a user_id and password, you need to create an equivalent database user "identified" externally.
HTH

[Updated on: Wed, 25 May 2011 00:50] by Moderator

Report message to a moderator

Re: Installation of 11gR2 on Windows [message #508905 is a reply to message #508726] Wed, 25 May 2011 04:24 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
geobraik wrote on Tue, 24 May 2011 15:14
Hi,

But later when I saw the document http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/prod/install/wininst/wininst_otn.htm#a I got a doubt that is the user oracle is to be created and to be added to ora_dba group.

Please clear my doubt.
I have created the database also after the installation. Since I didnt create the oracle user will it cause any problem? What shall I do now? Please suggest

Thanks in advance,
Geobraik



You should read it proper first.Quote:
Post Installation Tasks

For additional functionality within DB Control, functionality such as starting and stopping the database, an operating system user must belong to the ORA_DBA group. An existing user can be used or a new user can be created.
Quote:
will it cause any problem

No, nothing will happen.

Sriram



Previous Topic: how to recreate lobindex?
Next Topic: Deleting unwanted SYS shema objects
Goto Forum:
  


Current Time: Fri Nov 29 06:49:04 CST 2024