Solve problems in Oracle database management - ProgrammerTech


Solve problems in Oracle database management

  • Share this:
Solve problems in Oracle database management

Problems encountered by the user in the sql environment

Fixing some Types of Databases Errors that the user may encounter while starting to study databases, such as installing and uninstalling the program, connecting and forgetting the password, we will talk about them in detail.


The problem of entering the database

When entering the SQL * Pluse database, it asks us for the user name scott, sys, system and the password that you specified when installing the tiger program. Then write the user name and password, in the SQL language you can write in uppercase or lowercase.


Forgot password problem

If you forgot the password, connect to SQL through the CMD command line through the command SQLPLUS / AS SYSDBA asks for a name, then the SYS AS SYSDBA user asks for a password, any password must be made and it will connect with you to the database, and if the user is not activated, activate it using the command.


SYS AS SYSDBA user connects to the database as a database administrator

Login from SQL*PLUS

Login databases from SQL*PLUS


The problem of the emergence of the Arabic language

  1. Press the Windows button with the letter R.
  2. Search on regedit.
  3. Select HKEY_LOCAL_MACHINE and then SOFTWAR you will find a file named (ORACL).
  4. The content inside it has been changed to (AMERICAN_AMERICA.AR8MSWIN1256).
databases programmer tech


Commands you need in database management

  • SQL>EDIT This command is used to modify another SQL editor *Pluse and when this command is executed the screen appears. The idea has the last command written so it can be modified again.
  • SQL > RUN This is used to execute the command, write it in the editor in an LTS text file for the purpose of retrieval and review.
  • SQL > SPOOL Filename This command is used when we want to save everything that can be done inside the editor in an LTS text file so that we can retrieve it.
  • SQL > SPOOL OUT If we want to get a copy of the LTS file we saved using the previous command.
  • SQL> SAVE filename This command is used to save commands in a file to retrieve them again and execute them. Here, the file must be saved with the extension sql so that we can run it again if we want to save a file with the extension test.sql we write the command SQL>SAVE test.sql.
  • SQL>GET filename This command is used to retrieve the commands saved by the command, to use another command to retrieve commands from the file test.sql from the SQL>GET test.sql command.
  • SQL>START filename This command is used to execute commands in a sql file to execute SQL>START test.sql.
  • SQL > @filename is used like the previous command
  • SQL>LIST This command is used to display the last command that can be typed. Specific lines can be checked if you want specific lines from 1 to 6.

SQL * PLUSE: It is a code editor in which SQL codes are written. To download the program from this link, click here.

Wazeer Almuliky

Wazeer Almuliky

شاب يمني من صنعاء بكلريوس تقنية معلومات مهندس قطع إلكترونية و مبرمج تطبيقات اندرويد, خبرة في قواعد البيانات و الجافا, أهتم في الاكترونيات و لغات البرمجة منها فلاتر والجافا وسي شارب