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
sqlplus / as sysdba
sql > alter user APEX_040000 account unlock;
sql > conn APEX_040000/password;
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
/
sql > alter user...
Selasa, 24 Januari 2012
Sabtu, 21 Januari 2012
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 :
Than...
Jumat, 13 Januari 2012
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,...
Kamis, 12 Januari 2012
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 fi...