After the database is created, because the sid of the two databases is different, the default sid is used by default in the Oracle configuration file during system installation, that is, the started database is
After the database is created, because the sid of the two databases is different, the default sid is used by default in the Oracle configuration file during system installation, that is, the started database is
Alas, the project requires Oracle. I really don't want to use this large database for computers with low memory and CPU clock speed.
No way. I may need to use my computer during review. I have to configure the database first.
It is very convenient to install Oracle, because openSUSE supports SUSE Enterprise Edition. The official version provides an rpm package (orarun). After installing this package, slightly modify some environment variables, other kernel parameters are automatically modified. The specific installation method is as follows:
After running Oracle (the startup script installed by orarun can be found in/etc/init. d/run Oracle or directly start with rcOracle), all parameters will be modified, Oracle users and dba user groups will be created, as long as the database/install/oraparam. in ini, you can change the authenticated system version to your own system. After you log on to the Oracle user and run the Oracle Installation program, all Chinese characters will be garbled. The simplest way is to set the language of the Oracle user to English (export LANG = us_EN ), in this way, the installation language becomes English.
After installation, because the sid of the default database I created is different from that in the project configuration file, I want to create a new database. You can use the Oracle Wizard to create a database by logging on as an Oracle user and using dbca. To avoid garbled characters, you can set the language to English.
After the database is created, because the sid of the two databases is different, the default sid is used by default in the Oracle configuration file during system installation, that is, the database started is the default database. To use the newly created database, you must first change the environment variable Oracle_SID and use the export command to temporarily change Oracle_SID to the newly created sid. Then you can use sqlplus to log on and start the database, use lsnrctl to start database listening. You can also use emctrl to start dbconsole, so that you can perform database operations through the Enterprise Manager on the web page.
After the database is created, the table is created. When creating a table, I encountered another problem. I used the sys user to log on and create a table. As a result, the trigger cannot be created. Oracle prohibits the creation of triggers on sys for security considerations. So I created a user first. It is too difficult to assign permissions to users. There are more than 160 permissions. Fortunately, some permissions are automatically assigned after a role is assigned. Then, all sequences, tables, and triggers are successfully created at the user level.
I always thought that I would not use Oracle, so I didn't listen much during my class, and I didn't go to this kind of thing at ordinary times. As a result, I started the database and checked the information for a long time, depressing, troublesome!