Explain how to use the Developer tool to connect to the oracle database.

Explain how to use the Developer tool to connect to the oracle database.

1. You cannot log on to oracle as a common user. If you do not know why, log on to oracle as a system user.

Sqlplus

Sys/as sysdba

Liu123

2. Change the password of a common user

Alter user liuzq identified liu123

3. Connect to the liuzq user

Conn liuzq/liu123

4. Start the listener

Lsnrctl start

5. Disable the Firewall

Systemctl stop firewalled

6. Use Developer to connect to the oracle database

User name: liuzq

Password: liu123

Host Name: 192.168.91.147

Port 1521

Sid: orcl