Oracle 11g Admin Password Recovery

-
I have seen that the problem of forgetting Admin password in Oracle 11g is common. Many students came to me for resetting their passwords so i am creating this blog so that u can recover your admin password.

Step1: Open Command Prompt

Stpe2:  Type sqlplus /nolog

Step3: Type connect /as sysdba

 Step4:Type alter user sys identified by oracle; 

(Here oracle is password)

Step5: now try connecting again as shown below.

connect sys as sysdba

pas: oracle

 

 

For Details watch Video.

Comments

Post a Comment

Popular posts from this blog

Custom Authentication in Oracle APEX

-
Image
 Custom Authentication in Oracle APEX  This blog demonstrate the steps for Custom Authentication in Oracle APEX. Step1: We Need a table Login.      CREATE TABLE   "LOGIN"    (            "LOGIN_PK" NUMBER(7,0) NOT NULL ENABLE,                 "ENTITY_OWNER_FK" NUMBER(7,0) NOT NULL ENABLE,                 "ENTITY_FK" NUMBER(2,0) NOT NULL ENABLE,                 "USERNAME" VARCHAR2(20) NOT NULL ENABLE,                 "PASSWORD" VARCHAR2(20) NOT NULL ENABLE, "EMAIL" VARCHAR2(50),   CONSTRAINT "LOGIN_PK" PRIMARY KEY ("LOGIN_PK") ENABLE,         ...
Read more

"Navigating the Oracle APEX Frontier: A Transformative PhD Expedition"

-
Image
My five-year journey of pursuing a Ph.D. in Oracle APEX has been filled with both challenges and invaluable learning experiences. I decided to write this blog to share my insights and to help those who are considering a Ph.D. and are in search of a compelling research topic.   Where did the idea come from? It all started with a simple Online Test Application on a Local Area Network (LAN) using Oracle APEX . The idea of pursuing a Ph.D. in Oracle APEX first came to me in 2011-12.During that time, I developed an application to conduct online MCQ tests for students, designed to run on the LAN. Using a standard computer with minimal configuration, I installed Oracle APEX and set up the application so that students could access the MCQ test on the intranet, allowing us to generate results instantly. ...
Read more

Display Dynamic TextField in APEX based on Table Columns.(APEX_ITEM.TEXT)

-
Image
This blog will demonstrate steps to display TextField dynamically based on Table Columns in Classic Report and insert data into database. Oracle APEX has a large collection of API in which APEX_ITEM.TEXT is used in this example while if you want to explore in detail just click on following link. https://docs.oracle.com/cd/E14373_01/apirefs.32/e13369/apex_item.htm#AEAPI192 Step1: Create a Classic Report based on SQL Query. In this demo i have used a Emp table. So my query look like as follows.     select EMP.EMPNO as EMPNO,               EMP.ENAME as ENAME     from EMP EMP and Result will look like as shown in following figure. Now If we need to display a textbox against each employee name we need to add one dynamic APEX_ITEM.Text. So now our query will change as follows. select  EMP.ENAME as ENAME,    APEX_ITEM.TEXT(01,null,NULL,2,NULL,'Emp_Salary') AS Salary,    APEX_ITEM.HIDD...
Read more