...
| No Format |
|---|
[oracle@source ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 31 23:25:18 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options CDB$ROOT@ORCL> |
c. Reset the passwords for system and sys as they will expire in 7 days.
| No Format |
|---|
CDB$ROOT@ORCL> alter user system identified by oracle;
User altered. |
| No Format |
|---|
CDB$ROOT@ORCL> alter user sys identified by oracle;
User altered. |
d. Connect to the PDB.
| No Format |
|---|
CDB$ROOT@ORCL> ALTER SESSION SET container = pdb1; |
de. Unlock and alter the OE schema. Run the following SQL.
| No Format |
|---|
ALTER USER oe IDENTIFIED BY oe; ALTER USER oe ACCOUNT UNLOCK; GRANT ALTER SESSION, CONNECT, CREATE MATERIALIZED VIEW, CREATE VIEW, QUERY REWRITE, RESOURCE TO oe; GRANT EXECUTE ON DBMS_LOCK TO oe; ALTER USER OE QUOTA UNLIMITED ON USERS; |
ef. Logout of the database.
| No Format |
|---|
SQL> exit |
3. By default the listener is not setup to automatically register services. Setup the listener so that it automatically supports services.
...