| |
Linux server host enough, and testers need a new Oracle environment ,, so be prepared to do the testing on Oracle Linux host already have established a second example above. This Oracle server resource is sufficient, and therefore directly above the multi-instance structures to meet the needs of testers.
1, using vnc remote tools go, dbca given as follows:
[Oracle @ ptest4 ~] $ dbca
No protocol specified
[Oracle @ ptest4 ~] $ exit
2, need to set the display window:
[Root @ ptest4 ~] # export DISPLAY = localhost: 1
[Root @ ptest4 ~] #
[Root @ ptest4 ~] # xhost +
access control disabled, clients can connect from any host
[Root @ ptest4 ~] # su - oracle
[Oracle @ ptest4 ~] $ dbca
3. Create a step
3.1 Database Configuration Assistant
Graphical interface starts. Title by indicating the name of the step number and steps. In step name Welcome Welcome window, just click next.
Select Custom Database, and then the next step
Global Database Name box: Enter the name of the previously determined database
SID box: automatically appear and the same content database name as the database instance name, single-instance cases have not been altered
3.2 continues to default
3.3 atabase Credentials
Use Different Administrative Passwords
Form Password and Confirm Password columns were User Name column SYS, SYSTEM, DBSNMP and SYSMAN user to enter a password and repeat input (such as a password is set too simple, before the next pop-up window will be prompted to confirm accept the security risk).
sys password and system settings can be modified after the establishment of the database.
3.4 Database File Locations
Storage Locations: Select Use Common Location for All Database Files
Database File Location box: input / oracle / pddev1
3.5 Recovery Configuration
Specify Fast Recovery Area
If the previous Management Options step choose automatic backup, leave the check, and at the bottom:
Fast Recovery Area box: Modify the fast recovery area directory name
Fast Recovery Area Size box: adjust the size of the Fast Recovery Area
3.6 Enable Archiving
According to the actual needs of whether the archive log decide whether to choose (an important production system must open the archive, test systems are generally closed archive save server space)
Click next to the Edit Archive Mode Parameters ..., the pop-up window:
Automatic Archiving: Keep the default check
Archive Log File Format box: modified to% t_% s_% r.arc
Archive Log Destinations table: the first row of input / oracle / pddev1 / archivelog
Click OK to return to the main window
Database Content
Database Components page
3.7 and then continue to the next step
3.8 Initialization Parameters
Memory allocation of 20% (in small test library so some of the production of such libraries can be allocated 40% to 60% larger, etc.), select the character set utf8 compatible options
3.9 then the next step
Click the File Location Variables, which you can see some basic parameter information, returns, and then direct the next step,
3.10 then the next step, select Generate Database Creation Scripts
The default is / oracle / app / oracle / admin / powerdes / scripts, and then choose to click the Finish button, and then on the pop-up screen after clicking the OK button, you are given that the / etc / oratab reading error, can ignore.
4. Verify that two instances of oracle
[Oracle @ ptest4 admin] $ sqlplus / as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Fri May 22 17:02:07 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v $ database;
NAME
---------
POWERDES
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[Oracle @ ptest4 admin] $ sqlplus sys / syspddev @ pddev1 as sysdba;
SQL * Plus: Release 11.2.0.1.0 Production on Fri May 22 17:02:21 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v $ database;
NAME
------------------
PDDEV1
SQL>
The default sqlplus / as sysdba login is first started instance, if you want to log in a second instance, you need to specify the name of tnsping, sqlplus sys / pwd @ PDDEV1 as sysdba;
5, on the multi-instance random start automatically
- Assuming an instance is itsm, the other is a test
export ORACLE_SID = itsm
sqlplus / as sysdba
startup
quit
export ORACLE_SID = test
sqlplus / as sysdba
startup
quit
PS: start automatically, you can set in /etc/rc.local, add the following content
- Start the default database instance first
su - oracle < lsnrctl start
sqlplus / as sysdba
startup
quit
EOF
- Start a second instance of the database
su - oracle < export ORACLE_SID = test
sqlplus / as sysdba
startup
quit
EOF |
|
|
|