Today will Oracle12C installed on the machine, with 12 c 64 - bit server first, then install the 11 g 64 clients, are shown, the success of the installation in up SQLPLUS by sys user created user c # # YPJG (it is said that the user needs to begin with c # # in the 12 c), and assigned to the dba permissions and create a table, view, delete table, view permissions, such as using server-side.net service Manager configuration and monitoring using c # # YPJG the username login successful, then use oracle client.net configuration Manager to monitor connected to the local service, using c # # YPJG but how all failed, according to

reference

are trying to use the following user ID connection: c # # YPJG
Test failed,
ORA - 01017: the username/password is invalid; Login denied

There may be mistakes in the input field,

Always don't understand is what reason, the client configuration used in connection with the server is the same, but it is failed to login
The service side tnsname. Ora content is as follows:

 
LISTENER_ORCL=
(ADDRESS=(TCP) PROTOCOL=(HOST=localhost) (1521) PORT=) 

ORACLR_CONNECTION_DATA=https://bbs.csdn.net/topics/
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521)) 
) 
(CONNECT_DATA=
 https://bbs.csdn.net/topics/(SID=CLRExtProc) 
(the PRESENTATION=RO) 
) 
) 

Former=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=localhost) (1521) PORT=) 
(CONNECT_DATA=
 https://bbs.csdn.net/topics/(=DEDICATED SERVER) 
(SERVICE_NAME=former) 
) 
) 

Server listener. Ora content is as follows:

 
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=CLRExtProc) 
(ORACLE_HOM 

CodePudding user response:

Because 12 c has the concept of PCB, so when you connect to the database, make sure you even the last or PDB,

PS: c # # at the beginning of that must be CDB,

CodePudding user response:

Listening is on the server configuration, tnsname is client configuration, system login authentication can only last, PDB must go to monitor mode connection, do not know whether your connection string to write the right place