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?
missymadiAsked:
Who is Participating?
 
schwertnerConnect With a Mentor Commented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
All Courses

From novice to tech pro — start learning today.