Oracle 11GR2 Database Usage

Source: Internet
Author: User

1 very strange, not very understanding of the principle

One, Oracle 12c create user is "ora-65096:invalid common user or role name" error-Calvinr

Http://www.tuicool.com/articles/V3UJZfA

Second, Error "Ora-28040:no matching authentication protocol" when Using sqlnet. Allowed_logon_version (Doc

http://blog.csdn.net/wuweilong/article/details/15647075

Workaround:

1. sqlnet.ora file on the server machine:
From
Sqlnet. allowed_logon_version=10

To:
Sqlnet. Allowed_logon_version=8

2. When using the Oracle thin connection, the user name should be written as "C # #user"

Third, the program start error: Ora-12505;pl/sql but can login solution

Http://www.2cto.com/database/201203/124950.html

Iii. under the CDB container:

You need to add "c##" or "c##" before using user

For example: Conn C # #test/test;

Iv. about how instances are created (very good)

Http://database.51cto.com/art/201004/195492.htm

Oracle 11GR2 Database Usage

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.