Showing posts with label SAMPLEAPP. Show all posts
Showing posts with label SAMPLEAPP. Show all posts

Thursday, January 16, 2014

OBIEE Live demo from Oracle

Oracle has now made available a live OBIEE 11g environment for anyone who wishes to try it out.

Follow the link below to Oracle OBIEE sample app page:

http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

and click on 'Try it Live'


http://slc02okm.oracle.com:7780/analytics

This would take you to OBIEE login page, which will have user name and password listed (i.e. 'Prodney\Admin123'). I have seen that link does not work at times.



Well as this is a demo environment only,  I would not rely too much on it, but could be a stop gap arrangement till have one installed on your local machine.



Friday, January 25, 2013

OBIEE 11g BI Server not starting due to expired password

I installed sampleapp v207, and after few days, BIServer and Presentation Services do not start up. WLS Admin Server throws an error that password in expired. This really referrs to OID password, which needs to be changed.



This is a known bug for sampleapp v207. Issue is caused due to OID password expiry set to a default period of 120 days. In order to reset the default password and also set password expiry to never expire, do the follow.

Open a terminal inside SampleApp v207 image and execute the following commands. Then, restart opmn and all services should come up.

# Following commands resets password expiry parameter to 0 (never expire).
# It also sets passwords of orcladmin, oiduser1 & oiduser2 to default Admin123).

export ORACLE_HOME=/home/oracle/oid/Oracle_IDM1
export ORACLE_INSTANCE=/home/oracle/oid/bioid2
export LDAP_PRMS="dn: cn=default,cn=pwdPolicies,cn=Common,cn=Products,cn=OracleContext,dc=us,dc=oracle,dc=com\nchangetype: modify\nreplace: pwdmaxage\npwdmaxage: 0"
export LDAP_PWD="cn=Users,dc=us,dc=oracle,dc=com\nchangetype: modify\nreplace:userpassword\nuserpassword:Admin123"
cd /home/oracle/oid/Oracle_IDM1/
echo "Admin123" | ./ldap/bin/oidpasswd connect=OIDDB unlock_su_acct=true
echo -e $LDAP_PRMS | ./bin/ldapmodify -D cn=orcladmin -w Admin123 -h localhost -p 3060
echo -e "dn: cn=orcladmin,"$LDAP_PWD | ./bin/ldapmodify -D cn=orcladmin -w Admin123 -h localhost -p 3060
echo -e "dn: cn=oiduser1,"$LDAP_PWD | ./bin/ldapmodify -D cn=orcladmin -w Admin123 -h localhost -p 3060
echo -e "dn: cn=oiduser2,"$LDAP_PWD | ./bin/ldapmodify -D cn=orcladmin -w Admin123 -h localhost -p 3060
cd –

This solution does work..!!