viernes, 13 de noviembre de 2015

CONSOLA 12C DB EXPRESS

The DB Express runs entirely with pl/sql code within the XDB schema. It’s XDB that leverages its features to enable a web-based console, and it’s embedded by default in the database.
To enable it, it’s necessary to check that the parameter dispatchers is enabled for XDB:

PgSQL

1

2

3

4

5

SQL>showparameterdispatchers

NAMETYPEVALUE

----------- ------ -----------------------------------

dispatchersstring(PROTOCOL=TCP)(SERVICE=CLASSICXDB)

and then set an https port unique on the server:

PgSQL

1

2

3

4

5

SQL>execdbms_xdb_config.sethttpsport(5502);

PL/SQLproceduresuccessfullycompleted.

SQL>

If you’ve already done it but you don’t remember the port number you can get it with this query: