Oracle XE SYSTEM account locked: unlock the SYSTEM user

In some scenarios the SYSTEM user becomes locked after lots of trial of username and password. At that time you can do the following to unlock the same

Nvaigate to the SQL plus containing folder
and run the following in the cmd propmt window opened from that location
  1. > SQLPLUS SYS\ORACLE AS SYSDBA
    

    2. 

  2. 
Run the following command:
    

    > ALTER USER SYSTEM ACCOUNT UNLOCK;

OR

> ALTER USER SYSTEM IDENTIFIED BY <any password>;


    

    3. 

  3. 
Test the connection as follows:
    

    > CONNECT HR/HR
    

    4. 



































Comments











Post a Comment



















Popular posts from this blog










About View Popup Applet in the Standard Interactivity Mode Siebel Applications




















Image







 Notice  Please note that the About View popup is used just for testing purposes in  the Standard Interactivity Siebel clients. This is intended as help for  developers who want to find out the names of views/applets they are working on.    Background   The About View popup applet provides details of the screen, view, business  object, applet, and business components, currently being displayed in the Siebel  application window.  This technical note describes how to implement this functionality in the  Siebel customer facing applications.  Implementation   The About View dialog box could be invoked through a button in the frame view  bar of the Siebel application.  The button will invoke the “AboutView” method  (“About View (SWE)” command) that displays the About View dialog box.  The following needs to be configured in Siebel Tools:  1. Siebel Customer Facing Application:  First the user needs to determine the template used for the frame view bar of  the customer facing application...








Read more










Use Generate List functionality: FS Verify Entitlement





















   The Following are the details of creating a list based on a search spec:           Business Service Name      Method         FS Verify Entitlement      GenerateList               Input         Name      Type      Value         Business Component      Literal      <BC Name>         Business Object      Literal      <BO Name>         Field List      Literal      "<field name1>","<field name2>"         Search Spec      Expression      "<search spec>"               Output         Process Property      Data Type of Process property      Output Argument         <Property Name>      Hierarchy      Lists         The following are the details of step where we obtain the values in the List:           Business Service Name      Method         FS Verify Entitlement      GetNextItem               Input         Name      Type      Value         Field Name      Literal      <Field Name1>         Lists      hierarchy(obtained t...








Read more