oracle11g The default password expiration limit when creating a user is 180 days (that is, 6 months) and the user cannot log on if the user password has not been modified for more than 180 days.Oracle Corporation has introduced this default feature
Online a lot of peers should have encountered this problem, Baidu a search-based treatment method, is to increase the number of processes.But my side of the situation is not the same, because my Oracle 11g is just installed in the morning, with this
ERROR:ORA-01756: string in quotation marks does not end correctlySelect DISTINCT A.jno from RT as A where not EXISTS (select PNO from St as B WHERE not EXISTS (select Jno,pno from RT as C WHERE C.jno=a.jno and B.pno=c.pno)) GROUP by A.jno*An error
Oracle Error Log: ORA-00257, oracleora-00257
The following error is reported when the program is started this afternoon:
Caused by: java. SQL. SQLException: ORA-00257: archive program error. Only internal connections are allowed before release.
It
The ORACLE tutorial is: Analysis and Solution 2 of common ORACLE error codes.
--------------------------------------------------------------------------------
P align = "JUSTIFY"> ORA-01578: Oracle data block upted (file # num, block # num)
Cause:
Oracle error -- ORA-03113: file end solution for communication channel
Origin
Today as usual, login PL/SQL, indeed login failed, there is an error "ORA-01034" and "ORA-27101"
Then I log on to Oracle through the command prompt, to view what is going
ORA-00001: violation of unique constraints (.) ORA-00017: Request session to set trace event ORA-00018: exceeds Max sessions ORA-00019: exceeds Max session licenses ORA-00020: exceeds Max processes () ORA-00021: Session is attached to some other
After the connection to the database is successful, check the listener status: lsnrctlstatusstatusREADY status, which must be switched from non-archive to archive mode. The operation is as follows: 1. Disable
After the connection to the database is
The Oracle client is installed on the Server1, and Plsql is installed, but after logging in, the database and connect as are not displayed.Manually enter the correct user name and database after the error is as followsSo just cancel the login and go
Error 2304 when importing DMP file into local database using IMP statement
IMP-00017: The following statement failed due to ORACLE error 2304:
CREATE TYPE "T_varray" TIMESTAMP ' 2015-03-09:12:18:54 '
OID ' 0da828a87913400f93b12ebdc75afcf5 '
is
Origin
Today as usual, landing pl/sql, the failure to login, there is an error "ORA-01034" and "ORA-27101" as shown:
Then you go to Oracle at the command prompt to see what's going on, and then the problem goes further, the error "ORA-03113: The
ORA-00235 controlfile Fixed table inconsistent due to concurrent updateORA-00235 Control file fixed table inconsistent due to concurrent update cause Concurrent update activity in a control file caused a query on a control file fixed table to read
ORA-00235 controlfile Fixed table inconsistent due to concurrent update
ORA-00235 Control file fixed table inconsistent due to concurrent update
Cause Concurrent update activity in a control file caused a query on a control file fixed table to
Background: The Oracle database is installed on this computer and is connected using Plsql.After the Oracle 11g database is installed today. Connect to the database with Plsql the dead and alive are not connected. Also, the Database drop-down box
Believe that this error is not unfamiliar to everyone, only to install the use of Oracle is expected to have encountered this problem, the general is now used in PL/SQL connection to the Oracle database when the time occurs.The cause of this error
The database shuts down unexpectedly during the import of data. After restarting the machine, Pl/sql-developer cannot log in to the database, error ora-01033:oracle Initializationor shutdown in progress. The steps to resolve are as follows:
Run
http://blog.csdn.net/neso520/article/details/6037411————————————————————————————————————————————————————————————————————————Ora-06413:connection not open2 different versions of a program were installed on a machine two days ago. The program connects
My Oracle database was installed last November and then configured, and then it was normal, no problem, but then I didn't use my local Oracle, and PL/SQL was always a colleague's machine, Then today suddenly want to do some tests on their own
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.