加载中…
个人资料
  • 博客等级:
  • 博客积分:
  • 博客访问:
  • 关注人气:
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

Database 12C EM express配置步骤

(2012-12-20 15:31:27)
标签:

database

12c

em

express

it

分类: 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
 ON_DENY                        NUMBER                  IN     DEFAULT
PROCEDURE ADDAUTHENTICATIONMETHOD
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAME                           VARCHAR2                IN
 DESCRIPTION                    VARCHAR2                IN
 IMPLEMENT_SCHEMA               VARCHAR2                IN
 IMPLEMENT_METHOD               VARCHAR2                IN
 LANGUAGE                       VARCHAR2                IN     DEFAULT
PROCEDURE ADDDEFAULTTYPEMAPPINGS
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 VERSION                        VARCHAR2                IN     DEFAULT
PROCEDURE ADDHTTPEXPIREMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PATTERN                        VARCHAR2                IN
 EXPIRE                         VARCHAR2                IN
PROCEDURE ADDMIMEMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 EXTENSION                      VARCHAR2                IN
 MIMETYPE                       VARCHAR2                IN
PROCEDURE ADDSCHEMALOCMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAMESPACE                      VARCHAR2                IN
 ELEMENT                        VARCHAR2                IN
 SCHEMAURL                      VARCHAR2                IN
PROCEDURE ADDSERVLET
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAME                           VARCHAR2                IN
 LANGUAGE                       VARCHAR2                IN
 DISPNAME                       VARCHAR2                IN
 ICON                           VARCHAR2                IN     DEFAULT
 DESCRIPT                       VARCHAR2                IN     DEFAULT
 CLASS                          VARCHAR2                IN     DEFAULT
 JSPFILE                        VARCHAR2                IN     DEFAULT
 PLSQL                          VARCHAR2                IN     DEFAULT
 SCHEMA                         VARCHAR2                IN     DEFAULT
PROCEDURE ADDSERVLETMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PATTERN                        VARCHAR2                IN
 NAME                           VARCHAR2                IN
PROCEDURE ADDSERVLETSECROLE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SERVNAME                       VARCHAR2                IN
 ROLENAME                       VARCHAR2                IN
 ROLELINK                       VARCHAR2                IN
 DESCRIPT                       VARCHAR2                IN     DEFAULT
PROCEDURE ADDTRUSTMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PATTERN                        VARCHAR2                IN
 AUTH_NAME                      VARCHAR2                IN
 TRUST_NAME                     VARCHAR2                IN
 USER_PREFIX                    VARCHAR2                IN     DEFAULT
PROCEDURE ADDTRUSTSCHEME
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAME                           VARCHAR2                IN
 DESCRIPTION                    VARCHAR2                IN
 SESSION_USER                   VARCHAR2                IN
 PARSING_SCHEMA                 VARCHAR2                IN
 SYSTEM_LEVEL                   BOOLEAN                 IN     DEFAULT
 REQUIRE_PARSING_SCHEMA         BOOLEAN                 IN     DEFAULT
 ALLOW_REGISTRATION             BOOLEAN                 IN     DEFAULT
PROCEDURE ADDXMLEXTENSION
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 EXTENSION                      VARCHAR2                IN
FUNCTION CFG_GET RETURNS XMLTYPE
PROCEDURE CFG_REFRESH
PROCEDURE CFG_UPDATE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 XDBCONFIG                      XMLTYPE                 IN
PROCEDURE DELETEAUTHENTICATIONMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PATTERN                        VARCHAR2                IN
 NAME                           VARCHAR2                IN
PROCEDURE DELETEAUTHENTICATIONMETHOD
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAME                           VARCHAR2                IN
PROCEDURE DELETEDEFAULTTYPEMAPPINGS
PROCEDURE DELETEHTTPEXPIREMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PATTERN                        VARCHAR2                IN
PROCEDURE DELETEMIMEMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 EXTENSION                      VARCHAR2                IN
PROCEDURE DELETESCHEMALOCMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SCHEMAURL                      VARCHAR2                IN
PROCEDURE DELETESERVLET
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAME                           VARCHAR2                IN
PROCEDURE DELETESERVLETMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAME                           VARCHAR2                IN
PROCEDURE DELETESERVLETSECROLE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SERVNAME                       VARCHAR2                IN
 ROLENAME                       VARCHAR2                IN
PROCEDURE DELETETRUSTMAPPING
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PATTERN                        VARCHAR2                IN
 NAME                           VARCHAR2                IN
PROCEDURE DELETETRUSTSCHEME
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAME                           VARCHAR2                IN
 SYSTEM_LEVEL                   BOOLEAN                 IN     DEFAULT
PROCEDURE DELETEXMLEXTENSION
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 EXTENSION                      VARCHAR2                IN
PROCEDURE ENABLECUSTOMAUTHENTICATION
PROCEDURE ENABLECUSTOMTRUST
PROCEDURE ENABLEDIGESTAUTHENTICATION
FUNCTION GETFTPPORT RETURNS NUMBER
FUNCTION GETHTTPPORT RETURNS NUMBER
FUNCTION GETHTTPREQUESTHEADER RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 HEADER_NAME                    VARCHAR2                IN
PROCEDURE GETLISTENERENDPOINT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 ENDPOINT                       NUMBER                  IN
 HOST                           VARCHAR2                OUT
 PORT                           NUMBER                  OUT
 PROTOCOL                       NUMBER                  OUT
PROCEDURE SETDEFAULTTYPEMAPPINGS
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 VERSION                        VARCHAR2                IN
PROCEDURE SETDYNAMICGROUPSTORE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 IS_DYNAMIC                     BOOLEAN                 IN     DEFAULT
PROCEDURE SETFTPPORT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NEW_PORT                       NUMBER                  IN
PROCEDURE SETHTTPCONFIGREALM
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 REALM                          VARCHAR2                IN
PROCEDURE SETHTTPPORT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NEW_PORT                       NUMBER                  IN
PROCEDURE SETLISTENERENDPOINT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 ENDPOINT                       NUMBER                  IN
 HOST                           VARCHAR2                IN
 PORT                           NUMBER                  IN
 PROTOCOL                       NUMBER                  IN
PROCEDURE SETLISTENERLOCALACCESS
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 L_ACCESS                       BOOLEAN                 IN
FUNCTION USEDPORT RETURNS XMLTYPE

SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);  
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> exec DBMS_XDB_CONFIG.SETHTTPPORT(5500);

PL/SQL procedure successfully completed.

SQL>

0

阅读 收藏 喜欢 打印举报/Report
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有