Contacts     ->      ICQ:    699 512 265,         E-Mail: CerebroSQL@gmail.com

  • YouTube Social  Icon

FIRST RUN

Program "CerebroSQL" supplied fully assembled, no installation required. To start and start working, you only need to unzip the downloaded archive.

When you first start the program requests a new password for your own database. The password must be at least 6 characters.

After starting the program for the first time
  • Choice and sets the style for the program.

    • The list of styles, see "Styles" program

    • Settings see "Settings - style"

  • 2. Configure TNS (environment variables)

    • Go to the tab "TNS"

    • To install check the "Edit configuration"

    • From the drop-down list to select the desired Oracle_home (or <local> to work through a local library program). Set the NLS_LANG parameter (language and encoding)

    • Save the change by clicking "Save" button

The directory structure of the program
  • .\Config - directory to store configuration information, databases,

    • .\Backup - directory to store backups of the database program

    • .\Export - directory to upload the information from a database program (data packets)

    • .\Import - directory for upload to the database of the program information from the data packets

    • .\Script - the directory to store scripts, markup, databases,

  • .\Database - a directory to store the SPFile and ControlFile for the database to work with the program (files are stored in subdirectories with names database)

    • .\<Db Unique name> - directories with the database name

  • .\DLL directory to store libraries to connect to different DBMS/database

    • .\Oracle - directory to store libraries to work with Oracle database

    • .\PostgreSQL - directory for storing libraries to work with PostgreSQL

    • .\MySQL - the directory to store libraries to work with MySQL

    • .\SQLite - directory to store the libraries to work with databases and SQLite

  • .\Logs - a directory to store the logs of operation of the program

  • .\Manual - directory for storing documents (directly by the program is not used)

  • .\Scripts - a directory to store the scripts (not directly used)

  • .\tmp - a directory to store temporary files, the data stored from the program

    • .\awr - a directory to store the program generated the AWR report in html format

    • .\export - directory to upload the information from the grids query editor

    • .\lists - is the directory to store the texts of leaves of the query editor

    • .\plan - a directory to store query plans

    • .\query - the directory to store the text of queries

The structure of the database program
  • Base CeraDB.db

  • Base ASH.db