Selasa, 24 Januari 2012

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 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...

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...
 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Online Project management