Database 12C EM express配置步骤
(2012-12-20 15:31:27)
标签:
database12cemexpressit |
分类: RDBMS_ORACLE |
按如下步骤在Database 12c里面配置EM Express
add line in tnsnames.ora
inst1= (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=cdb1.example.com)(SERVER=DEDICATED)))
exec DBMS_XDB_CONFIG.SETHTTPPORT(5500);
SQL> show parameter service
NAME
TYPE
VALUE
------------------------------------ ----------- ------------------------------
service_names
string
cdb1.example.com
SQL> alter system set local_listener=inst1 scope=both;
System altered.
SQL> alter system set dispatchers="(PROTOCOL=TCP)" scope=both;
System altered.
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); <--标准文档上此处有错,应该是GETHTTPPORT
BEGIN DBMS_XDB_CONFIG.SETHTTPSPORT(5500); END;
*
ERROR at line 1:
ORA-06550: line 1, column 23:
PLS-00302: component 'SETHTTPSPORT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL> desc dbms_xdb_config
PROCEDURE ADDAUTHENTICATIONMAPPING
Argument
Name
Type
In/Out Default?
------------------------------
----------------------- ------ --------
PATTERN
VARCHAR2
IN
NAME
VARCHAR2
IN
USER_PREFIX
VARCHAR2
IN
DEFAULT
add line in tnsnames.ora
inst1= (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=cdb1.example.com)(SERVER=DEDICATED)))
exec DBMS_XDB_CONFIG.SETHTTPPORT(5500);
SQL> show parameter service
NAME
------------------------------------ ----------- ------------------------------
service_names
SQL> alter system set local_listener=inst1 scope=both;
System altered.
SQL> alter system set dispatchers="(PROTOCOL=TCP)" scope=both;
System altered.
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); <--标准文档上此处有错,应该是GETHTTPPORT
BEGIN DBMS_XDB_CONFIG.SETHTTPSPORT(5500); END;
ERROR at line 1:
ORA-06550: line 1, column 23:
PLS-00302: component 'SETHTTPSPORT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL> desc dbms_xdb_config
PROCEDURE ADDAUTHENTICATIONMAPPING