Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 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
OAS - expired password to Oracle DB
Hello, I have a problem with start of OAS server in test env.
Logs shows that the reason for this was expired password to DB.
DBA team has change this setting to 'never expire', but this doesn't solve the problem.
Do I need to change this password? If yes, what is the procedure?
Thank you in advance.
Tom
Best Answer
-
While they are only sample commands, you definitely don't want to run this one:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Changing the default profile to never expiring passwords isn't something you want in your database. Let your DBAs handle the passwords lifecycle of your schemas.
All you need to know is:
- are the accounts used by OAS locked? If they are, the DBA should unlock them, because it's possible to set a password to never expire on locked accounts.
- have the password been changed? In that case you should update it on the OAS side, looking at documents in MOS (the one posted above is one of the few documents covering how to change passwords in OAS etc.).
3
Answers
-
Hi @Tomasz Antosz ,
Are you talking about RCU schema passwords? If so, did your DBA team change the settings for all the RCU schemas? Are you able to connect to the database using a SQL client (e.g. SQL Developer) using one of the RCU schema and its current password?
0 -
@Tomasz Antosz Please Refer: *** BI Schema Passwords reset steps *
Steps To Reset Oracle Analytics Server Passwords After a Migration (Doc ID 2817923.1)Adding sample commands to perform this using sysdba user for your RCU database:-
SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';OAS_OPSS
OAS_BIPLATFORM
OAS_WLS_RUNTIME
OAS_IAU_APPEND
OAS_IAU_VIEWER
OAS_MDS
OAS_STBALTER USER OAS_OPSS IDENTIFIED BY Welcome1;
ALTER USER OAS_BIPLATFORM IDENTIFIED BY Welcome1;
ALTER USER OAS_WLS_RUNTIME IDENTIFIED BY Welcome1;
ALTER USER OAS_IAU_APPEND IDENTIFIED BY Welcome1;
ALTER USER OAS_IAU_VIEWER IDENTIFIED BY Welcome1;
ALTER USER OAS_MDS IDENTIFIED BY Welcome1;
ALTER USER OAS_STB IDENTIFIED BY Welcome1;ALTER USER OAS_OPSS ACCOUNT UNLOCK;
ALTER USER OAS_BIPLATFORM ACCOUNT UNLOCK;
ALTER USER OAS_WLS_RUNTIME ACCOUNT UNLOCK;
ALTER USER OAS_IAU_APPEND ACCOUNT UNLOCK;
ALTER USER OAS_IAU_VIEWER ACCOUNT UNLOCK;
ALTER USER OAS_MDS ACCOUNT UNLOCK;
ALTER USER OAS_STB ACCOUNT UNLOCK;ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
You can use the commands based on the schemas that have expired or have been locked.
0
