Connect to the Oracle server in the SAP background in Ubuntu

Next to the previous log: ubuntu10.10 installing the Oracle client

 

When I first installed sap, sapsr3 or sys failed to connect to the service. Sapsr3 indicates that the select any dictionary permission is missing, and SYS prompts that the user password verification is invalid (in fact, it is correct). It may also be because of permission issues and cannot be connected.

Because both users are used by the system, they still do not directly add permissions to them. It is appropriate to add a new user.

 

Connect to the AIX Server

Telnet 192.168.1.12

 

Switch to Oracle Management User

Su-oradev

 

Sqlplus connects to the database. The default password of sys is system.

Sqlplus sys/system as sysdba

 

Add a user hs_aws_sa and authorize

Create user hs_aws_sa identified by password;

Grant connect, resource to hs_aws_sa;

Grant create session, DBA to hs_aws_sa;

 

 

Next, use this user to connect.