This discussion is archived
7 Replies Latest reply: Oct 23, 2012 11:54 AM by orafad RSS

Uninstall/Install Question

902014 Newbie
Currently Being Moderated
I have a Oracle 11g R2 XE installed in my PC. I also have a licensed VB2010 Ultimate(free from class). I have made three systems using this database, 1 using php and 2 using .net.

My question is, if I uninstalled my database and then reinstall it, will it affect my the systems I made(I already backed-up my tables etc.)?

for example, the components for my oracle-vb connection.


Thank you!


P.S.

Why I need to uninstall? Because I got locked out of the System account:, I can't change my password.
C:\Users\Davide>SQLPLUS system/secret@127.0.0.1:1521/XE

SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 23 10:26:31 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-28001: the password has expired


Changing password for system
New password:
Retype new password:
ERROR:
ORA-01017: invalid username/password; logon denied
  • 1. Re: Uninstall/Install Question
    rp0428 Guru
    Currently Being Moderated
    >
    Why I need to uninstall? Because I got locked out of the System account:, I can't change my password.
    >
    So connect as sys and change the System password to something else.
    sqlplus /nolog
    conn / as sysdba
    alter user system identified by newPassword;
  • 2. Re: Uninstall/Install Question
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    The process to change passwords is documented - http://docs.oracle.com/cd/E17781_01/server.112/e18804/users_secure.htm#ADMQS227

    HTH
    Srini
  • 3. Re: Uninstall/Install Question
    902014 Newbie
    Currently Being Moderated
    I created a local connection using sql developer and now i get:

    jdbc-oci:112030 error when i access the sysdba connection.

    i also tried to reset the system password, but i still get the error.

    can u pls answer my 1st question, i just want to start from zero. thank you

    Edited by: m.davide on Oct 22, 2012 8:11 PM
  • 4. Re: Uninstall/Install Question
    orafad Oracle ACE
    Currently Being Moderated
    Please redo steps from rp0428 above. This time use copy-paste to show us exactly what you did and how it responded.
  • 5. Re: Uninstall/Install Question
    902014 Newbie
    Currently Being Moderated
    C:\Users\Davide>sqlplus /nolog
    
    SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 23 17:05:04 2012
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    SQL> conn / as sysdba
    ERROR:
    ORA-12560: TNS:protocol adapter error
    I this error when I don't specify the other parameters on ms-dos (example: C:\Users\Davide>sqlplus system/secret@127.0.0.1:1521/XE)

    I forgot to mention, OS authentication doesn't work since I'm on a domain and I can't alter the domain settings since I'm not friends with my system admin.

    I really need to reinstall.
    m.davidewrote:

    My question is, if I uninstalled my database and then reinstall it, will it affect my the systems I made(I already backed-up my tables etc.)?

    for example, the components for my oracle-vb connection.
    Thank you!
  • 6. Re: Uninstall/Install Question
    Udo Guru
    Currently Being Moderated
    I forgot to mention, OS authentication doesn't work since I'm on a domain and I can't alter the domain settings since I'm not friends with my system admin.
    I understand your system admin somehow - installing a(nother) DBMS on a domain machine yourself can cause him a lot of pain too, especially...
    SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 23 17:05:04 2012
    when you already have a different Oracle Database (client?) installation on your machine.
    I guess your ORACLE_HOME is set to that installation instead of your XE, which is why you probably get
    ORA-12560: TNS:protocol adapter error
    You could try to add your XEs parameters to your regular Oracle environment (if you can access it) or you can reset your ORACLE-parameters to point to your XE instance. Possibly you have more luck than.
    Note that you usually need local admin rights for installing XE, so reinstalling might not be an option for you.

    -Udo
  • 7. Re: Uninstall/Install Question
    orafad Oracle ACE
    Currently Being Moderated
    m.davide wrote:
    SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 23 17:05:04 2012
    Is this on a different machine, or what's installed alongside XE?

    Please post output from command:

    path

    SQL> conn / as sysdba
    ERROR:
    ORA-12560: TNS:protocol adapter error
    That does not work likely because (you work local to the database instance and) PATH is not set properly for working within the Oracle home. (Of course, the Windows service for the instance need to be available as well.)
    I forgot to mention, OS authentication doesn't work since I'm on a domain and I can't alter the domain settings since I'm not friends with my system admin.
    Well, I guess you have a setting need adjusting for os auth to work in your environment.

    I really need to reinstall.
    Why? There must be some other reason. What will you do the next time you need to change a password?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points