Skip to main content

Posts

Showing posts from January, 2013

ORA-28000: the account is locked for SCOTT

First time you try to login as scott/tiger, it would throw an error as shown below,



To get rid of this error, login as SYSTEM for password use the password that was speficied during step3 of this installation process.
Once logged in, use the sql statement below to unlock scott user.

Once this is done, login as scott tiger and it should work. It might as to change the old password with a new one, In this case use "tiger" as old password.

IBM/AIX RISC System/6000 Error: 13: Permission denied

While starting listener on Oracle Applications through adalnctl.sh exited with,

adalnctl.sh: exiting with status 1

Following was found in the log file.

LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production on 25-JAN-2013 03:49:52

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=XXX)(Port=1626))
TNS-12224: TNS:no listener
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
    IBM/AIX RISC System/6000 Error: 79: Connection refused
Starting listener process APPS_XXX.

LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production on 25-JAN-2013 03:49:55

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Starting /oraapp/ncrmprd6ora/8.0.6/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production
Log messages written to /oraapp/XX/8.0.6/network/admin/apps_XX.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=XXX7)(PORT=1…