Re: Server deinstallation

Randy Harris wrote: 
"Alan Searle" <aj_searle@xxxxxxxxxxxx> wrote in message
news:df4rtf$o99$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxx

As a newcomer to Oracle server, I am experimenting with the
functionality (under Windows 2K) and so have deinstalled and
re-installed several times.

This works OK but I find that, although I try to make sure that all
components are de-installed (i.e. using the Oracle Installer, deleting
the directories and deleting entries from the registry) I find that
previously declared databases/tablespaces are still declaring under
'Services' which means I cannot re-use these names.

So can anyone tell me how to remove these services?  Where is they
controlled?  In the registry?  Or in the Windows environment (under
control panel)?  And do I need to be 'Administrator' on my PC or can I
delete services with a normal user account?

Any tips would be a great help.

Regards,
Alan Searle

To e-mail me just remove the 'xxx' from the e-mail address.

PS: In my documentation the user 'Oracle' is often mentioned.  Is this
account created automatically and, if so, what is the default password?
 And how should I format my login use this account in SQL*Plus?



Alan,


Hi Randy,

You'll find them in the registry:

HKLM\System\CurrentControlSet\Services

They can be safely deleted from there.  You will need Administrator priv.
Then reboot.


Excellent.  That worked fine and I managed to re-install OK.

AFAIK, no 'Oracle' account will get created, either in the database or in
the OS, from installing Oracle server, or from creating a database.  An OS
group - ora_dba will get created.  Your software owner (the account you use
to install the server) will be in that group.  Users sys and system will be
in the database.  You can login to SQL*Plus with those.

OK, yes. And, yes, I would like to log in as SYS but find that the log-in screen that SQL*Plus presents cannot be clicked away. Indeed, I would like to use the log-in syntax: CONNECT SYS AS SYSDBA. How do I put this into the SQL*Plus log-in window?

Many thanks for your help.

Regards,
Alan.
.

Relevant Pages

  • Re: Beginner security questions
    ... Since you've installed with "Windows Only" you may have a few steps to take ... You could try to create a user account on the SQL ... Reinstall sql server in mixed mode (remember to back up your database ...
    (microsoft.public.sqlserver.security)
  • RESTORING CRASHED SITE WEBS
    ... I reformatted and reinstalled Windows 2003. ... access using Windows Security the account returned in the failed login ... RESTORE ALL SQL AND WSS DATABASES ... I put in the database server name and existing ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Hard Drive Crash, Restoring to Original Registered User
    ... programs work except a database I use which is locked, ... Probably doesn't matter what name is used for your Windows account. ... Everytime a new user account is created, and new SID is assigned to it. ... The "registered to" isn't used by your database. ...
    (microsoft.public.windowsxp.general)
  • Re: RESTORING CRASHED SITE WEBS
    ... I reformatted and reinstalled Windows 2003. ... > access using Windows Security the account returned in the failed login ... INSTALL WINDOWS SP1 ... I put in the database server name and existing ...
    (microsoft.public.sharepoint.windowsservices)
  • OLEDB connection to mysql via ASP
    ... Although the following question is not related to a MS flavor database, ... IS related to MS flavored technologies / platforms: ASP and Windows XP. ... I have just installed MySQL via the new windows installer program on my ...
    (microsoft.public.inetserver.asp.db)