Ad Widget

Collapse

Errors in database creation

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • andy_dufresne
    Junior Member
    • May 2013
    • 2

    #1

    Errors in database creation

    I am trying to install zabbix on a linux machine (with Oracle Enterprise Linux distribution 5.6). I get errors while executing the sql files to install an oracle schema. Here are the steps I followed

    1. Created a oracle schema with below sql

    Code:
    create user zabbix identified by password;
    grant all privileges to zabbix;
    2. Executed the below command through sqlplus

    Code:
    CREATE OR REPLACE DIRECTORY image_dir AS '/home/oracle/old_images'
    3. After I executed the below steps I got many errors

    Code:
    sqlplus> set def off
    sqlplus> @database/oracle/schema.sql
    sqlplus> @database/oracle/images.sql
    Attached - DatabaseErrors.txt. I wasn't able to capture the complete list of errors since I executed it from command putty but the text file should give an idea.

    I am worried that the installation didn't go fine. How should I proceed?
    Attached Files
  • Heilig
    Senior Member
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Mar 2013
    • 366

    #2
    Please, check database character set.

    Comment

    Working...