[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 14985
  • Last Modified:

Unlocking Accounts in Oracle 10g

Hey folks i have alittle problem, I just installed oracle RDBMS and i forgot to unlock scott account, is there any way i can unlock this?

thanks in advance
0
Eaddy Barnes
Asked:
Eaddy Barnes
  • 2
2 Solutions
 
radja7Commented:
alter user SCOTT  account unlock;
0
 
Eaddy BarnesITAuthor Commented:
i cant login using the sql*plus program, what do u suggest i do to login and run that script?
0
 
radja7Commented:
if you have access to server console, try:
sqlplus /nolog
connect / as sysdba
alter user SCOTT  account unlock;
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now