Shulou(Shulou.com)06/01 Report--

Configure Oracle environment variables

1. Edit .bash _ profile

[oracle@FDB] $vi ~ / .bash_profile

2. Make the configuration file effective

[oracle@FDB] $. .bash _ profile

Create a parameter file initFDB.ora and a password file orapwFDB

1. The corresponding directories for parameter files and password files are as follows

2. Create the parameter file initFDB.ora and create the corresponding directory. (FDB is the instance name)

[oracle@FDB ~] $vi initFDB.ora

Add the following to the parameter file:

Db_name='FDB'

Memory_target=1G

Processes = 150

Audit_file_dest='/u01/app/oracle/admin/FDB/adump'

Audit_trail = 'db'

Db_block_size=8192

Db_domain='us.oracle.com'

Db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

Db_recovery_file_dest_size=2G

Diagnostic_dest='/u01/app/oracle'

Dispatchers=' (PROTOCOL=TCP) (SERVICE=ORCLXDB)'

Open_cursors=300

Remote_login_passwordfile='EXCLUSIVE'

Undo_tablespace='UNDOTBS'

Control_files = (/ u01qaphort oradataUniverse control 1.ctlandqu01andapplicaloradataplicoradata / u01qqoraclecontrol oradata)

Compatible = '11.2.0'

Create the corresponding file directory for the parameter file:

[oracle@FDB dbs] $mkdir-p / u01/app/oracle/admin/FDB/adump

[oracle@FDB dbs] $mkdir-p / u01/app/oracle/oradata/FDB

3. Create an Oracle password file

[oracle@FDB dbs] $orapwd file=orapwFDB password=oracle entries=30

4. Connect to the database to create spfile and start to nomount

[oracle@FDB dbs] $export ORACLE_SID=FDB

[oracle@FDB dbs] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 9 16:12:29 2020

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected.

SQL > create spfile from pfile

File created.

SQL > startup nomount

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.