Monday, March 14, 2016

Password Recovery of Weblogic 11g


1. Navegate to:
    cd $DOMAIN_HOME/bin

2. Set the environment
    . setDomainEnv.sh

3. Change the directory
    cd $DOMAIN_HOME\security

4. Backup the file
    mv DefaultAuthenticatorInit.ldift DefaultAuthenticatorInit_old.ldift

5. Create user and password for AdminServer
    java weblogic.security.utils.AdminAccount NewUser NewPasswor .

6. Edit boot.properties with the data new

7. Rename or Delete the next directory
    $DOMAIN_HOME\server\AdminServer\data\ldap

8. Start AdminServer

Saturday, March 12, 2016

Install Gnome Desktop on Text Install - Solaris 11

Login onto the console with root user and use the following commands:

pkg install slim_install
svcadm enable gdm

And if you want to run the deskstop:

startx

Monday, February 22, 2016

Generating SSH Key DBAAS



With puttygen tool you can create your private, public, and open ssh keys for Cloud instances, here the procedure:

1.- Open tool

PuTTY Key Generator

2.- Select SSH-2 RSA

PuTTY Key Generator parameters

3- Bits:

PuTTY Key Generator parameters

4- Generate:
Generate button

5- Draw stg for randomness

Generating key - status

6.- Copy key

Generated public key

7.- Set the key pass phrase to create a private key

Key passphrase fields

There is no way to recover a passphrase if you forget it.



8.- Save it (PPK Extension)


9.- If you need to create a compatible SSH key for commands, export it as open ssh.

Save private key in OpenSSH format

10.- Create public key by copy-paste the content of the generated key,point 6, in a txt file and save it.

Note: Not the private key

Public key for pasting

Public key pasted into text editor


More information:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_QS/oracle_database_cloud_service_dbaas_quick_start.html#section1




Access DBAAS through SSH


Sometimes you are required to enter to a machine node to make some administrative tasks, you cannot do in web consoles, so you need to enter with SSH.

With a client like MobaXterm, Putty, or whatever SSH Client you have do the following

Remote Host: Here you put the public ip
User: oracle | opc

oracle for common administrative tasks
opc user if you need root privilege using sudo command

Port: Use the default (22)

In auth section use the private key that you create when you configured your database service, you create 3 keys:

1.- Private Key
2.- Public Key
3.- SSH Key

Here you select your private key

Click in OK

Click in connect session







There you go ! 

DBAAS Useful Links


Here I share useful links when you have provisioned with database as a service:

The main requirements is that you have DB Enterprise Edition and service and listeners up and running:

Links:

EM
https://public-ip:5500/em/shell#/config/show_params
system/pwd

Database Monitor
https://public-ip/dbaas_monitor/
DBAAS_MONITOR/pwd

APEX
https://public-ip/ords/pdb1/f?p=4050:3:8030913058308:::::

INTERNAL (always)
ADMIN/pwd

GlassFish
https://public-ip:4848/common/index.jsf
admin/pwd

Make sure you have database instance up and running

For instance:

https://dbaas.oraclecloud.com/dbaas/faces/dbRunner.jspx username and password provided when Oracle granted your access.




And also in Compute Services.

https://computeui.us.oraclecloud.com/mycompute/faces/instances.jspx

Check if Instance and Network services are up and runnig.


If not restart the network services in update option


There you go!

Monday, January 25, 2016

Overview Business Intelligence Cloud Service

Oracle has driven BI Cloud strongly, that's why I share you a very good link if you want to learn about BI Cloud Service

Main topics:

Explore Data in Visual Analyzer Projects
View Reports in Dashboards and Analyses
Getting Started with Analyses
Getting Started with Dashboards
Prepare Data and Models for Exploration and Reporting
Getting Started with Data Loading
Getting Started with Data Modeling
Manage Your BI Cloud Service

https://docs.oracle.com/cloud/latest/reportingcs_use/reportingcs_tutorials.htm

Monday, November 23, 2015

Change JAVA default location of Linux




When you install a product for example 12 C versions Oracle when you are running the installer this ask you for a specific JAVA version and there is no other way to set that if you don't install it, even when set JAVA_HOME, JRE_HOME, JDK_HOME, (Or I haven't find it yet)
So, download the JAVA version you want and move it to:

/usr/lib/jvm/jdk1.7.0_79 (for example)

To set your JAVA version and associate it to java command, then configure the JAVA command, with root privileges run:

sudo update-alternatives --install "/usr/bin/java" "java" "/usr/lib/jvm/jdk1.7.0_79/bin/java" 1
sudo update-alternatives --config java

Optionally you can set:

export JAVA_HOME=/usr/java/jdk1.7.0_79
export JRE_HOME=/usr/java/jdk1.7.0_79/jre
export JDK_HOME=/usr/java/jdk1.7.0_79

In your bash_profile.

Restart bash or reboot.

Note:

When you install java with rpm  option, this is installed in /user/java/(java_version)

Annexed:

Remove-->

sudo update-alternatives --remove "java" "/usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java"