Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle Business Intelligence 11.1.1.9
I have a need to rename an username in Business Intelligence (Analytics). Is it possible?
Best Answer
-
I succeeded in going offline. You have to be on the server (I used MobaXTerm so I was failed).
2
Answers
-
Refer :
How To Execute Bulk Rename Accounts Using runcat.sh/runcat.bat (renameAccounts) (Doc ID 2437991.1)
1 -
Hi @Staniša Avdalović ,
Welcome to the Oracle Analytics community!
You can use the Catalog Manager (UI or command-line) to rename users.Section 17.3, "About Catalog Manager"
./runcat.sh -cmd renameAccounts -helpAs you may know, OBIEE 11g is very old, we recommend you make plans to update to Oracle Analytics Server(via OBIEE 12c) at your earliest convenience before it becomes an issue to migrate :-)
Migrate from Oracle Business Intelligence 11g
Thank you for your question!
2 -
Thanks for the answers. I will take a look.
0 -
I tried to change username and in the catalog manager username is change. At the other side in weblogic console username hasn't been changed! Beside it I couldn't sign in again.
0 -
Do you notice any errors in the sawlogs? Have you attempted to refresh the users' GUIDs?
After taking proper backup, You need to run the following command:
./runcat.sh -cmd renameAccounts -old ABC -new XYZ -online http://<ip>:9704/analytics/saw.dll -credentials boot.txt
Boot.txt is a credentials properties file that should be placed in a location accessible by OBI. Edit the file and include the following content:
login=username (Example: weblogic)
pwd=password
Here, username refers to the OBIEE Administration user, and password is the corresponding password. This should ideally work.
0 -
At the other side in weblogic console username hasn't been changed!
No command will rename the account in WebLogic if that's where you defined it. You have to do the renaming there, and I believe there isn't such a thing as renaming in WebLogic, and renaming is done by creating a new user with the right username and deleting the old one. Then the catalog manager rename does the job required in the catalog.
OBIEE 11g still was fully based on GUID, and those can go out of sync (mostly when migrating catalogs across environments). It's way too many years since last time I worked on a 11g to remember if the renameAccounts command in the catalog manager did handle the renaming preserving the GUID or a refresh was needed. I would guess you don't need it (maybe).
Your issue with the login is because you are now in a mixed state: WebLogic only knows of the old account, your catalog only knows of the new account.
2 -
That's correct.
0 -
I was thinking of making a new user and deleting the old one, but I don't know how to copy dashboards and reports from the old user to the new one.
In the Catalog Manager I can see renaming user. As you can see I cannot access users's folder!
0 -
How can I refresh the users' GUIDs?
0 -
Please refer (Take proper backups if following the steps):
OBIEE 11g: How to Refresh GUIDs on a single node OBIEE 11g ? (Doc ID 2181811.1)
OBIEE 11g: How To Refresh the GUIDs and Perform a Web Catalog Validation - Cluster/Scale-Out - the Reasons to do it, Preventing Inconsistencies and Process Detail (Doc ID 1493912.1)
Also, on your other query : By default Administrator does not get access to users content as users content is meant to be confidential. Please Refer :
OBIEE 12c: How To Update Object Ownership In The Catalog After A User's Name Has Been Modified (Doc ID 2759123.1)
OBIEE: Weblogic User Does Not Have Access To Other User Folders Using "Admin View" (Doc ID 2234422.1)
An Administrator User Cannot Modify Owned Items That Were Created By Another User In Oracle Analytics (Doc ID 2957146.1)
0
