Saturday, 15 March 2014

ORA-28000 and ORA-01017 issue when connecting to hr schema in Oracle 11g XE


After successfully installing Oracle XE 11g , i tried connecting to hr schema from my JDev
and faced couple of issues.  I am pretty sure this is very common workaround and you can get plenty of resource but i am just trying to place it  in one place so that it will help for beginner.


Issue1: ORA-28000: the account is locked 

solution:

From your command prompt, type
sqlplus "/ as sysdba"

Once logged in as SYSDBA, you need to unlock the hr account
SQL> alter user hr account unlock;
SQL> grant connect, resource to hr;


Issue2:ORA-01017 Invalid Username/Password 

solution: alter user hr identified by hr DEFAULT tablespace users temporary tablespace temp account unlock; 

Issue3: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

solution:  Start the OracleXE database first after that try to connect. 

issue 4: ORA-01031:insufficient privileges

suppose you created new workspace in Oracle XE  with user 'hrconnect' and if you hit with above issue  when you are trying to create any db object like table, sequence etc . You actually need to grant the privilege to user, so following steps will help you

open the sql command prompt and login as sysdba

step1: connect system/<password> as sysdba
 Step2: grant CREATE TABLE to hrconnect; OR 
             grant CREATE SEQUENCE to hrconnect; etc


How to work with FOD Schema in Jdeveloper for ADF

If you are following ,
http://www.oracle.com/webfolder/technetwork/tutorials/obe/jdev/obe11jdev/ps1/dvt_graph/gant_chart_pivot_table.htm#o

and downloaded fod schema, and trying to build project using fod schema,

below properties in build.properties need to point to exact location

# Base Directory for library lookup
middleware.home=D:/Oracle/Middleware11.1.7 -> Jdev installation directory


jdeveloper.home=${middleware.home}/jdeveloper -> JDev home directory

I am using XE to install FOD schema, 

If you look at , following information in build.properties file,

# Information about the default setup for the demo user.
db.adminUser=system
db.demoUser=FOD
db.demoUser.password=fusion
db.demoUser.tablespace=USERS

db.demoUser.tempTablespace=TEMP

we need fod user with password fusion in our XE, to do that,

Go to command prompt, connect as sysdba
sqlplus "/ as sysdba"

create user fod identified by fusion;


grant connect, resource to fod;