Wednesday, February 15, 2012

Resetting OBIEE 11g weblogic admin password

Hi All,

Steps to Resetting weblogic User Password:
1)
Login into WLS (Web logic Server)Administration Console as Administrator privileges
http://ServerIP(or)localhost:7001/console/login/LoginForm.jsp
in the Domain Structure -> click the Security Realms -> myrealm -> User and Groups
-> Select weblogic user (Double click the user which you want to change the password) -> Password
Enter the new and confirm password.
2)
Stop all the bi services and change (before take a backup of Current RPD, Catlog, boot.properies and change it that password) it password and save it.
3)
Go to weblogic Enterprise Manager and deploy RPD (just new changed password RPD file) here you must put it u r new changed RPD password then click apply and restart services.
4)

Down all the bi services then find it boot.properites files then set it your new password and restart all bi services. Then it will work with new password (RPD, Presentation services, weblogic Console/EM and Catalog).
Some more refernce method:

http://linora64.blogspot.com/2011/07/reset-obiee-11g-weblogic-admin-password.html

Thanks

Deva

Saturday, February 11, 2012

How to create a new Catalog in OBIEE11g

Hi
  1). Go to localDrive:C:\OBIEE11G\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
2). Open your instanceconfig.xml file
3). Find <CatalogPath> and </CatalogPath> tags
4). Write the new catalong name that you want to create (suppose sh_new) then your tag should look like this
<CatalogPath>C:\OBIEE11G\instances\instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/obirep</CatalogPath>
5). Save the file and start/re-start the BI presentation service
6). It automatically creates the obirep catalog, once we start our presentation service and you need not to create anything manually..



Note:
Catalog Manager is useful in managing your reports and give permissions to the users and folders..
As per the name implies you can understand that it's used to manage the catalog that you have...
The list of things that we can do with catalog manager are: (as per my knowledge)
1). Rename the report names, dashboard names, and other stuff
2). Used to give permissions for particular folders or particular objects for particular users..
3). copy and move the reports to other folders
4). copy and move the reports to other machine's catalog which are in network and accessible.
5). Can modify the XML for reports and prompts presents in this catalog if you know the XML

Via Em and Catalog manger careting new catalog is very strange.some times it works and some times not working its throwing like this error while crating in Catalog manager

file:///?\C:\OBIEE11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\obirep\root.atr could not be accessed.
file:///?\C:\OBIEE11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\obirep\root.atr could not be accessed.
also EM unable to create new catalog issues. so better to above suggested methods its works fine.

Thanks
Deva