Hey there folks...
Oracle EE 11gr2
Enterprise Manager 11.2.0.1.0
Linux
Ok so UC Berkeley in its infinite wisdom has decide to switch to that POS gmail.
Gmail apparently MUST have SSL / TSL to have messages delivered to berkeley accounts.
I have searched far and wide to figure out why under the notification configuration in EM has no selection for any secure protocol.
The EM Console is secured and only works with SSL via HTTPS. It is just a default certificate and not an issued one.
I have looked at the SYSMAN schema: MGMT_NOTIFY_EMAIL_GATEWAY and there is not even a column for any secure protocol only the following columns are there:
CREATE TABLE SYSMAN.MGMT_NOTIFY_EMAIL_GATEWAY
( MAIL_HOST VARCHAR2(128 BYTE) NOT NULL ENABLE,
EMAIL_ADDRESS VARCHAR2(256 BYTE) DEFAULT '' NOT NULL ENABLE,
EMAIL_NAME VARCHAR2(64 BYTE) DEFAULT '' NOT NULL ENABLE,
SMTP_USER VARCHAR2(256 BYTE) DEFAULT '',
SMTP_PWD VARCHAR2(256 BYTE) DEFAULT '',
SMTP_PORT NUMBER DEFAULT 25,
PRECEDENCE NUMBER DEFAULT 1,
CONSTRAINT MGMT_NOTIFY_EMAIL_GATEWAY_PK PRIMARY KEY (MAIL_HOST)
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE SYSAUX ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE SYSAUX ;
So how does one implement SSL / TSL on this? Is there something I missed on the original install ?
All suggestions appreciated.
Edited by: FlyingGuy on May 17, 2013 5:06 PM