Oracle) Setting up

Setting up

The new version of Oracle takes up a lot of memory and RAM, so I downloaded the XE11 version. OracleXETNSListener and OracleServiceXE have to be constantly running on your computer, so once you download the app, you will find that turning on/off takes more time. Therefore, when you don't use it, you would better set the Startup type "Manual" instead of "Automatic."

Connecting to Client

Open the command prompt and enter 'sqlplus name of the account/password. to show the user's name, enter 'show user'.

You could also enter 'sqlplus,' and the prompt will ask for your user name and password.

To change the account, you could use 'connect account name/password as sysdba'

To be safe from the mistakes you will make with the system account, Oracle offers an account named 'scott' for demonstration purposes. According to legend, this account was named after Bruce Scott, co-author and co-architect of Oracle v1 to v3, and the password was the name of his daughter's cat, Tiger. (What a monument!)

To set your account's password, you can use 'alter user account name identified by password'. To see the list of the table, insert 'select*from tab;' and you will see 4 tables on the list.

To exit, you can either insert 'exit' or 'quit', and you will see this :

*When you forget the password of DBA and USER

It is impossible to know your previous password but you can reset your password. Enter 'sqlplus /"as sysdba"' and check 'show user' first, and enter 'alter user ID identified by yournewpassword;'