Shulou(Shulou.com)05/31 Report--

Editor to share with you what ORACLE 12c common problems are, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Server sqlnet.ora plus

SQLNET.ALLOWED_LOGON_VERSION=8

Rebuild the password, new and old version compatibility issues, or upgrade oracle client

Alter user sys identified by "password"

Pdb does not start by default when the server is restarted

SQL > col name format A10

SQL > select name, open_mode from v$pdbs

NAME OPEN_MODE

ORCLPDB MOUNTED

SQL > alter pluggable database orclpdb open

The plug-in database has changed.

SQL > select name, open_mode from v$pdbs

NAME OPEN_MODE

ORCLPDB READ WRITE

Create a hr instance

SQL > @ C:\ app\ Administrator\ virtual\ product\ 12.2.0\ dbhome_2\ demo\ schema\ human_res

Ources\ hr_main.sql

Specify password for HR as parameter 1:

Enter value for 1: hr

Specify default tablespeace for HR as parameter 2:

Enter value for 2: user

Specify temporary tablespace for HR as parameter 3:

Enter value for 3: temp

Specify log path as parameter 4:

Enter value for 4: C:\ app\ Administrator\ virtual\ product\ 12.2.0\ dbhome_2\ log

Alter session set container=ORCLPDB

SQL > select con_id, dbid, guid, name, open_mode from v$pdbs

CON_ID DBID GUID NAME OPEN_MODE

# # 5A872545AC274801A748D0A39B5F513A PDB$SEED READ ONLY

# # 707A628103304A948B8250B57DDE09FD ORCLPDB MOUNTED

SQL > alter session set container=ORCLPDB

2

The session has changed.

SQL > startup

The plug-in database is open.

SQL > select con_id, dbid, guid, name, open_mode from v$pdbs

CON_ID DBID GUID NAME OPEN_MODE -

# # 707A628103304A948B8250B57DDE09FD ORCLPDB READ WRITE

SQL > alter pluggable database close

2

The plug-in database has changed.

SQL > select con_id, dbid, guid, name, open_mode from v$pdbs

CON_ID DBID GUID NAME OPEN_MODE -

# # 707A628103304A948B8250B57DDE09FD ORCLPDB MOUNTED

SQL > alter pluggable database open read only

2

The plug-in database has changed.

SQL > select con_id, dbid, guid, name, open_mode from v$pdbs

CON_ID DBID GUID NAME OPEN_MODE -

# # 707A628103304A948B8250B57DDE09FD ORCLPDB READ ONLY

SQL > alter pluggable database open read write

Alter pluggable database open read write

*

An error occurred on line 1:

ORA-65019: pluggable database ORCLPDB is open

SQL > alter pluggable database close

The plug-in database has changed.

SQL > alter pluggable database open read write

The plug-in database has changed.

SQL > select con_id, dbid, guid, name, open_mode from v$pdbs

CON_ID DBID GUID NAME OPEN_MODE

# # 707A628103304A948B8250B57DDE09FD ORCLPDB READ WRITE

SQL > alter pluggable database open read write RESTRICTED

The plug-in database has changed.

SQL > select con_id, dbid, guid, name, open_mode from v$pdbs

CON_ID DBID GUID NAME OPEN_MODE

# # 707A628103304A948B8250B57DDE09FD ORCLPDB READ WRITE

The above is all the content of the article "what are the frequently asked questions on ORACLE 12c". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.