In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-02-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
After upgrading from oracle10g to oracle11g, you need to understand the new features of oracle11g, which may have an impact on application and performance and need to be adjusted.
1. Oracle11g password expiration policy
By default, oracle11g sets PASSWORD_LIFE_TIME=180 to expire in the default profile, and the password will be changed automatically when it expires, which will affect the application.
SQL > alter profile default limit password_life_time unlimited
2. Oracle11g is sensitive to the case of username and password
The default username and password in Oracle11g are case-sensitive, but oracle10g does not have this problem.
SQL > alter system set sec_case_sensitive_logon=false scope=spfile
3. Oracle11g empty table will not create segment immediately, default is true. In oracle11.2.0.1, this will cause some problems, the biggest problem is that when exp exports, empty tables will not export data. An EXP-00001 error occurs when importing a database later than 11.2.0.2 using the oracle11.2.0.1 exp client.
SQL > alter system set deferred_segment_creation = false scope=spfile
After testing using 11.2.0.4 exp export empty table, now import can be imported. If you use expdp, impdp import and export, there is no problem.
The solution to the problem that the table is already empty is as follows: find the table empty and allocate space immediately:
SQL > select 'alter table' | | table_name | | 'allocate extent;' from user_tables where num_rows=0
'ALTERTABLE' | | TABLE_NAME | | 'ALLOCATEEXTENT;'
Alter table C allocate extent
Alter table B allocate extent
Alter table An allocate extent
Alter table ABC allocate extent
Alter table TEST_LOCK allocate extent
4. Oracle11g enables the audit feature by default. Enabling the audit feature will have an impact on performance, so you can consider disabling it.
SQL > alter system set audit_trail=none scope=spfile
This parameter defaults to DB, which means that the audit data is stored in the AUD$ table in the system tablespace. The new takeover of the production warehouse caused a failure of full SYSTEM table space. The warning log is as follows.
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
Thu Dec 10 08:47:13 2015
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
Thu Dec 10 08:47:13 2015
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
Finally, get rid of it directly:
Truncate table sys.aud$
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
Create a table CREATE TABLE cmd & # 40; id INT PRIMARY KEY auto_increment, USER CHAR (32 tables 41)
© 2024 shulou.com SLNews company. All rights reserved.