ERROR : Invalid Login Credentials ( APEX 4.0 )

Hi,

APEX 4.0

First of all this causes maybe :
1. you input incorrect password
2. you input incorrect user
3. you input incorrect workspace
4. account was lock by something

in this session i'll give solution for number 4 cause.

first thing to do is :
you must login to sql

1. sqlplus / as sysdba
2. sql > alter user APEX_040000 account unlock;
3. sql > conn  APEX_040000/password;
4. sql >

   begin
   wwv_flow_api.set_security_group_id(p_security_group_id=>10); 
   wwv_flow_fnd_user_api.create_fnd_user( 
     p_user_name => 'admin2', 
     p_email_address => 'dev@null.com',
     p_web_password => 'admin2') ; 
   end;
   /
   commit
   / 

5. sql > alter user APEX_040000 account lock;

then

login to apex_admin
http://test.test.local:7780/pls/apex/apex_admin

user :admin2
pass :admin2



maybe for first time login
it mus be reset password
then go to workspace task position in right of your screen

choose find a user.

then




choose image pencil to edit your user :
look for Account Privileges see Account Availability is must be "locked" change to "unlocked"
then try again in APEX home.

Thanks.

Read more »

Connect to SQLPLUS : ERROR: ORA-12560: TNS:protocol adapter error ( WINDOWS )

Problem :

Causes :

Not set Enviroment

Solution :

set your ORACLE_HOME and your PATH
set ORALE_HOME="your oracle path"
set PATH=%ORACLE_HOME%\bin;%PATH%


example :

set ORACLE_HOME=C:\product\11.2.0\dbhome_1
set PATH=%ORACLE_HOME%\bin;%PATH%

pict :

Thanks.

Read more »

error adadmin

problem :

$ adadmin
-bash: adadmin: command not found

even you execute enviroment file.

how to solve :

put this in your .bash_profile

AD_TOP=/u01/CRP/apps/apps_st/appl/ad/12.0.0; export AD_TOP
APPL_TOP=/u01/CRP/apps/apps_st/appl/; export APPL_TOP
COMMON_TOP=/u01/CRP/apps/apps_st/comn; export COMMON_TOP
ORACLE_HOME=/u01/CRP/apps/tech_st/10.1.2; export ORACLE_HOME
IAS_ORACLE_HOME=/u01/CRP/apps/tech_st/10.1.3; export IAS_ORACLE_HOME

PATH=$PATH:$HOME/bin

export PATH

and then

$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib/

now you can execute

$ adadmin

if you meet this error :

 Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                     Oracle Applications AD Administration

                                 Version 12.0.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

AD Administration error: Unable to get value of ORACLE_SID or TWO_TASK.

AD Administration error:
Unable to get database name.

how to solve :
ORACLE_SID=CRP;export ORACLE_SID

and problem solve.


Thanks.

Read more »

ORACLE R12 Troubleshooting On OEL 5.5

if you find an error :

The requested
URL /OA_HTML/AppsLogin was not found on this server.

( view By Mozzila)

this how to solve :

This problem occurred because wsrp_service.wsdl was owned by root but the services were being started by applmgr.

Ensure that the file
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/server-wsdl/wsrp_service.wsdl

it shows it is owned by root. Somebody started the services of Apps as root user.

Changed the owner of the file to Apps Owner.

Restarted the service.

Everything works fine.

Read more »