Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Oracle 11g AND Linux5

Experts,

         I just installed Oracle 11g on Linux Red Hat and need to run custom scripts. How can I run .sql scripts from Oracle Enterprise Manager?
0
missymadi
Asked:
missymadi
  • 3
  • 3
  • 3
1 Solution
 
schwertnerCommented:
Invoke as 'Oracle' user SQL*Plus

sqlplus /nolog

SQL>
SQL>connect sys/password@conn_string as sysdba
Connected.
SQL> @ /u01/..../script.sql

But you will experience some difficulties.

Look in TNSNAMES.ORA file for  conn_string mentioned above.
Also check if the instance is registered by the listener:

lsnrctl status
lsnrctl services

Check if Oracle is up:

ps -ef | grep pmon
0
 
MikeOM_DBACommented:
To run scripts from OEM, on the database home page look for a "Execute SQL" link at the bottom of the page.
0
 
Edward JoellCommented:
How can the first person be awarded the points when he didn't even read the question.  Thank you MikeOM_DBA I've been trying to figure out how to do this for days.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
MikeOM_DBACommented:
Also if you click on the "Jobs" tab, you can create and schedule sql scripts.

0
 
Edward JoellCommented:
Right.  What I was doing was copying the script for creating tables from a schema on a database on another server to a schema on a local database on my machine.  And I could figure where in EM you could do this but I knew there had to be a place.  Now if I could only figure out how to generate a schema diagram....
0
 
MikeOM_DBACommented:
To generate schema diagram you need a utility like Erwin or even Visio to reverse-engineer the schema and get the data model (and diagram).

0
 
schwertnerCommented:
Oracle has launched a tool that is paid but free for testing:
DATAMODELLER
It does also reverse engineering.
0
 
Edward JoellCommented:
What a shame.  I already successfully reversed engineered what I had to Visio but I was hoping Oracle had something with better imagery.  DataModeller, huh.  I will look into it.
0
 
schwertnerCommented:
Good luck and success!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now