Results 1 to 5 of 5

Thread: oracle and unix

  1. #1
    Join Date
    Jul 2005
    Posts
    276

    Unanswered: oracle and unix

    Hi All,
    I'm running a KSH which internally calls oracle to run a procedure. But when I run the KSH it says 'You must be logged in as Oracle user to run this'
    How can I run the KSH logged into Oracle?

    2K$ script.ksh database schemas table_name table_partition_200910
    You must be logged in as oracle user


    Can someone please advise.

    Thanks,
    Nandini

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool DO what it says!

    Can someone please advise.
    Yes, login to the server as the Oracle account and run the script.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    log into/onto OS as OS user oracle
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jul 2005
    Posts
    276
    I'm logged into Oracle in UNIX now. How can I run the KSH here?

    2K$ sqlplus database@schemaname

    SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 6 10:43:53 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Enter password:

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, OLAP and Data Mining options

    SQL>

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Nope...not the database, the OS

    No, you need to login to the Unix server (or sudo or su) to/as the Oracle account (the OS account that owns the Oracle software), then execute the script.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •