Oracle常见的QA

1、打开Oracle SQL Developer 2.1工具出现“Unable to create an instance of the Java Virtual Machine ”

解决方法：修改工具路径下的 ide\bin\ide.conf   AddVMOption –Xmx 256M

具体参照：http://www.faisalmb.com/blog/post/2009/06/23/Oracle-SQL-Developer-Unable-to-create-an-instance-of-the-Java-Virtual-Machine.aspx

2、在用户登录时出现错误提示：

ORA-28002:the password will expire within 2 days

28002. 00000 - "the password will expire within %s days"

*Cause: The user's account is about to expired and the password needs to be changed

解决方法：

查看用户的过期日期

Select  *  from dba_users;

 修改用户的过期时间

select limit from dba_profiles where profile = ( select profile  from dba_users where username='**') and RESOURCE_NAME='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT  PASSWORD_LIFE_TIME  UNLIMITED;

修改后查看修改结果 

select limit from dba_profiles where profile=(select profile from dba_users where username='**')and resource_name='PASSWORD_LIFE_TIME';

 

 如果查询结果为：UNLIMITED ，仍有出错提示，出现该问题是因为：

This change only affects accounts who have not entered their grace period (and started getting ORA-28002 on connection). 

Accounts that have entered their grace period will have to change their passwords.

具体参照：http://203.208.39.132/search?q=cache:LDZXxnZVhMgJ:www.itpub.net/thread-201747-1-1.html+ora-28002+the+password+will+expire+within+2+days+oracle&cd=3&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy281IX57xFNimIe1ffNpzSJ8TyEXvg

3.Oracle timeten 数据库连接字符串的写法

通过配置本地数据源DSN连接字符串方便书写，直接指定数据源名称即可，但不便于程序的移植，可换用此方式连接timeten:

<connectionStrings> 
<add name="DSN" connectionString="Driver={TimesTen Client 7.0};TTC_SERVER_DSN=**;TTC_SERVER=**;TCP_PORT=***;UID=***;PWD=***;"/>
</connectionStrings>

 4.Oracle 连接时出现错误提示如下：

ORA-12526: TNS:listener: all appropriate instances are in restricted mode

在使用过程中对数据库进行限制：

ALTER SYSTEM ENABLE RESTRICTED SESSION 

取消限制： 

ALTER SYSTEM DISABLE RESTRICTED SESSION

 5.字符集更改的内部操作

 alter database character set INTERNAL_CONVERT/ INTERNAL_USE ZHS16GBK

  具体可参考：http://www.eygle.com/archives/2004/09/nls_character_set_07.html