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

This article focuses on "how to solve the problem of silent installation of oracle 12c". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to solve the problem of silent installation of oracle 12c.

1: be sure to create a monitor first, and then build a database, otherwise an error will be reported:

[oracle@tvy-mysql-cdsp-01 database] $dbca-silent-createDatabase-responseFile / media/database/response/dbca.rsp

[WARNING] [DBT-06801] Specified Fast Recovery Area size (2780 MB) is less than the recommended value.

CAUSE: Fast Recovery Area size should at least be three times the database size (2730 MB).

ACTION: Specify Fast Recovery Area Size to be at least three times the database size.

[FATAL] [DBT-07505] Selected listener (LISTENER) does not exist.

ACTION: Specify an existing listener.

Second, when the memory is greater than 4G, automaticMemoryManagement=FALSE is required.

[oracle@tvy-mysql-cdsp-01 database] $dbca-silent-createDatabase-responseFile / media/database/response/dbca.rsp

[WARNING] [DBT-06801] Specified Fast Recovery Area size (2780 MB) is less than the recommended value.

CAUSE: Fast Recovery Area size should at least be three times the database size (2730 MB).

ACTION: Specify Fast Recovery Area Size to be at least three times the database size.

[FATAL] [DBT-11211] The Automatic Memory Management option is not allowed when the total physical memory is greater than 4GB.

CAUSE: The current total physical memory is 125GB.

Three: users can only be created in a specific pdb database, not in cdb, unless you create a public user (must start with the letter + #)

Create user c##liuwenhe identified by test

Or you'll make a mistake!

SQL > create user liuwenhe identified by "liuwenhe#123"

Create user liuwenhe identified by "liuwenhe#123"

*

ERROR at line 1:

ORA-65096: invalid common user or role name

SQL > alter session set container=BHDB_PDB

Session altered.

SQL > create user liuwenhe identified by "liuwenhe#123"

User created.

Fourth: oracle 19c can not dynamically register monitoring (reason unknown) solution: use static registration curve to save the country

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = bhdb_pdb)

(ORACLE_HOME = / data/u01/app/oracle/product/12.2.0.1/db_1)

(SID_NAME = bhdb)

)

(SID_DESC =

(GLOBAL_DBNAME = bhdb_pdb2)

(ORACLE_HOME = / data/u01/app/oracle/product/12.2.0.1/db_1)

(SID_NAME = bhdb)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = slave15.happycfc.net) (PORT = 1521))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

)

Five: the lower version of the client connects to the higher version of oracle 12c, and the connection fails due to the incompatibility of the version.

Oracle11g client, link to Oracle12C 2.* database service, version incompatibility problem

Using PLSQ to report an error

Oracle12c connection problem ORA-28040

Solution:

Add the following statement to the configuration file

Vi $ORACLE_HOME/network/admin/sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

Explanation:

SQLNET.ALLOWED_LOGON_VERSION_SERVER: controls the client version that can connect to 12c databases (client-> orace 12c db)

SQLNET.ALLOWED_LOGON_VERSION_CLIENT: controls which versions of the database 12c databases can connect to (orace 12c db-> other versions of oracle db), for example, controls which versions of oracle libraries can be connected to through DB LINK.

This parameter is used to limit the minimum client version that can connect to the database server, for example, the setting value is 10, that is, the client version above 10g can connect to the database server. The default value is used when not specified, resulting in a lower version unable to connect to a higher version of the database. To put it bluntly, to solve the compatibility problem is to let the higher version of the database service also allow the lower version of the database to connect.

Six: install oracle 18c. Oracle wants you to extract the installation package to the $ORACLE_HOME directory, otherwise the following error will be thrown during silent installation.

. / runInstaller-silent-responseFile / data/oracle18c/oracle_software/install/response/db_install2.rsp-ignorePrereqFailure

Launching Oracle Database Setup Wizard...

[FATAL] [INS-35954] The installer has detected that the Oracle home location provided in the response file is not correct.

CAUSE: The Database Oracle home is the location from where the installer is executed. It has been detected that the value set in the response file is different (/ data/oracle18c/product). Value expected is: / data/oracle18c/oracle_software

ACTION: It is not required to specify ORACLE_HOME in the response file for Database installation. Alternatively, set it to the location of the installer (/ data/oracle18c/oracle_software).

Solution: when decompressing, decompress directly to oracle_home:

Unzip LINUX.X64_193000_db_home.zip-d $ORACLE_HOME

Seven: oracle 18c begins to change the path of the answer file, as follows:

Software $ORACLE_HOME/install/response/db_install.rsp

Monitor $ORACLE_HOME/assistants/netca/netca.rsp

Build a database $ORACLE_HOME/assistants/dbca/dbca.rsp

At this point, I believe you have a deeper understanding of "how to solve the problem of using oracle 12c silent installation". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.