Reset or Update Admin Password

You can use these steps to reset or change your Admin password.

Steps to Update the Admin Password on OCI node

Follow the steps to access the WebLogic console on OCI - see Access WebLogic Console on OCI.

Note:

If the Admin user doesn't want to enable permanent access to WebLogic port, they can create a temporary tunnel as mentioned below, to access the WebLogic console:

For a stack with public IP, open command shell and run the following command to open tunnel:

ssh -L 7002:private_IP:7002 target

where target is alias for ssh opc@target.

For example:

ssh -L 7002:10.xx.xx.xx:7002 target

The .ssh/config file looks like this:

Host target
      Hostname private_ip
      User opc               
      StrictHostKeyChecking=no
      IdentityFile private_key_for_stack
      ProxyCommand ssh targetbastion -W %h:%p
 Host targetbastion
      HostName public_ip
      User opc               
      StrictHostKeyChecking=no               
      IdentityFile private_key_for_stack

For example:

Host target
      Hostname 10.xx.xx.xx
      User opc
      StrictHostKeyChecking=no
      IdentityFile C:\xxxxx\privateKey.pem
      ProxyCommand ssh targetbastion -W %h:%p
Host targetbastion
      HostName 140.xx.xx.xx
      User opc
      StrictHostKeyChecking=no
      IdentityFile C:\xxxxx\privateKey.pem

(For 19c through 19.3.0.4.5) If stack has only a private IP, then in Host targetbastion, set bastion host with a public IP. Otherwise, use stack public IP.

(For 19.3.0.5.6) for a stack with a private IP only, create Bastion and create a session for the node, as described in Access Oracle Essbase Using SSH. Then copy the ssh command and do the following:

Replace <privateKey> -> path to the private key (from the SSH key pair used to create the session).
Remove -p 22 from command wherever it occurs.
Add -L 7002:private_ip_stack:7002 after ProxyCommand.

Sample ssh command:

ssh -i <privateKey> -o ProxyCommand="ssh -i <privateKey> -W %h:%p -p 22 ocid1.bastionsession.oc1.**.***@host.bastion.***.oci.oraclecloud.com" -p 22 opc@private_ip_stack

New edited ssh command:

ssh -i <privateKey> -o ProxyCommand="ssh -i <privateKey> -W %h:%p ocid1.bastionsession.oc1.**.***@host.bastion.***.oci.oraclecloud.com" -L 7002:private_ip_stack:7002 opc@private_ip_stack

For example:

ssh -i C:\***\privateKey.pem -o ProxyCommand="ssh -i C:\***\privateKey_org.pem -W %h:%p ocid1.bastionsession.oc1.phx.***@host.bastion.us-phoenix-1.oci.oraclecloud.com" -L 7002:10.100.100.100:7002 opc@10.100.100.100

You can then log in to WebLogic console (with open tunnel):
```
https://localhost:7002/console
```

Log in to WebLogic Server Admin Console.
On the home page, under Domain Structure, select Security Realms.
Under Summary of Security Realms > Realms, select myrealm.
Under Settings for myrealm, select Users and Groups tab.
Under Users, select or click on your WebLogic admin username, for example, WebLogic or admin (for Marketplace).
Select Passwords tab.
Enter the new password twice, and click Save.
Go to essbase_domain > environment > servers.
In the Control tab, select both servers, and then perform shutdown. You can do a force shutdown if no tasks are being processed.
Follow the steps to ssh using the private key. See Access Oracle Essbase Using SSH.
After ssh, change user to oracle:
```
sudo su oracle
```

Run the following command:

sh /u01/config/domains/essbase_domain/esstools/bin/start.sh

In the prompt for WebLogic user and password, enter the admin's user name and changed password. It is registered in the appropriate boot.properties file.

Steps to Reset the Admin Password for Instance on OCI

Follow the steps to ssh using the private key. See Access Oracle Essbase Using SSH.
After ssh, change user to oracle:
```
sudo su oracle
```

Set domain home variable:

export DOMAIN_HOME=/u01/config/domains/essbase_domain

Then switch to domain directory:
```
cd $DOMAIN_HOME
```
Stop the servers using:
```
$DOMAIN_HOME/esstools/bin/stop.sh
```

Move old AdminServer data to different location:

mv $DOMAIN_HOME/servers/AdminServer/data $DOMAIN_HOME/servers/AdminServer/data_old

Set the environment variables:
```
. $DOMAIN_HOME/bin/setDomainEnv.sh
```
Reset the password using the following command. Remember to substitute the appropriate username and password.
```
cd $DOMAIN_HOME/security
```
```
java weblogic.security.utils.AdminAccount <adminuser> <newpassword> .
```

Start Essbase services. You'll be prompted for the admin/password on startup and your changed password will be registered in the appropriate boot.properties file.

$DOMAIN_HOME/esstools/bin/start.sh

For example:

opc@testhost> ssh -i <privatekey> -o ProxyCommand="ssh -i <privatekey>  -W %h:%p -p 22 ocid1.bastionsession.XXXXX" -p 22 opc@10.XX.XX.XX
Last login: Fri Feb 11 07:38:13 2022 from 10.XX.XX.XX
Welcome to Oracle Essbase on OCI 19.3.0.5.6-SNAPSHOT
Running Oracle Essbase 19.3.0.5.6 (Build 042)
Effective kernel version is 5.4.17-2136.302.7.2.2.el7uek.x86_64
[opc@essxx-1 ~]$ sudo su oracle
[oracle@essxx-1 opc]$ export DOMAIN_HOME=/u01/config/domains/essbase_domain
[oracle@essxx-1 opc]$ cd $DOMAIN_HOME
[oracle@essxx-1 essbase_domain]$ $DOMAIN_HOME/esstools/bin/stop.sh
Stopping domain; Using domainHome: /u01/config/domains/essbase_domain ...
------stop script output ----
Stopping all managed servers and system components ...
Stopping ess_server1 (Original State:RUNNING) ...
..
Stopped ess_server1
------stop script output ----


[oracle@essxx-1 essbase_domain]$ mv $DOMAIN_HOME/servers/AdminServer/data $DOMAIN_HOME/servers/AdminServer/data_old
[oracle@essxx-1 essbase_domain]$ . $DOMAIN_HOME/bin/setDomainEnv.sh
[oracle@essxx-1 essbase_domain]$ cd $DOMAIN_HOME/security
[oracle@essxx-1 security]$ java weblogic.security.utils.AdminAccount admin pwdxxx.
[oracle@essxx-1 security]$ $DOMAIN_HOME/esstools/bin/start.sh
--- start output---
Requesting credentials ...
Enter Weblogic login details at prompt
Weblogic Username: admin
Weblogic Password:
--- start output--- 
NodeManager (essxx-1:9556): RUNNING

Name            Type            Machine                   Status
----            ----            -------                   ------
ess_server1     Server          essxx-1.app.essxx.oraclevcn.com RUNNING
AdminServer     Server          essxx-1         RUNNING