Oracle Database 12c Modifications from Vagrant – Getting EM to work

I published a blog on installing a 12c database with vagrant a few weeks back. I just want to update some slight modifications that might be useful for you and help me remember as well.

As oracle user nano .bash_profile in the /home/oracle directory.

vagrant_oracle_database_12102_ee_on_linux--mdash--oracle-db12c-~--mdash--ssh--mdash--116-times-42

You can then source the .bash_profile and add the ORACLE_SID and then export ORACLE_SID.  Connect to the database:

sqlplus / as sysdba

Password = oracle

This allows you to run the following commands to get em working from your desktop machine.

SQL> show parameters dispatchers;

Which should show:

NAME     TYPE VALUE

———————————— ———– ——————————

dispatchers     string (PROTOCOL=TCP) (SERVICE=db1210

2XDB)

max_dispatchers      integer

SQL> select dbms_xdb_config.gethttpsport () from dual;

Which should show:

DBMS_XDB_CONFIG.GETHTTPSPORT()

——————————

0

SQL> exec dbms_xdb_config.sethttpsport(5502);

PL/SQL procedure successfully completed.

SQL> commit;

SQL> select dbms_xdb_config.gethttpsport () from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()

——————————

5502

From your desktop https://10.10.10.9:5502/em

em-express---database-home

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: