如何通过Python获取Oracle进程PID？os.system返回0问题求助

Hey there! The issue you're facing is that os.system() doesn't return the output of the command you run—it only returns the exit status code (0 means the command executed successfully, non-zero values indicate errors). That's why you're seeing 0 printed instead of the actual PID.

Let's walk through the correct ways to capture the PID using Python's subprocess module, which is designed explicitly for handling command execution and output capture.

Method 1: Using subprocess.check_output() #

This method is straightforward for commands you expect to succeed. It raises an error if the command fails (e.g., no matching process found), so we wrap it in a try/except block for robustness.

import subprocess
import shlex

def get_oracle_pmon_pid(oracle_sid):
    # Escape the SID to avoid shell injection risks (critical if input is user-provided)
    quoted_sid = shlex.quote(oracle_sid)
    try:
        # Run the command and capture output as a string
        output = subprocess.check_output(
            f"ps -ef | grep pmon | grep {quoted_sid} | grep -v grep | awk '{{print $2}}'",
            shell=True,
            text=True
        )
        # Clean up extra whitespace/newlines from the output
        pid = output.strip()
        return pid if pid else None
    except subprocess.CalledProcessError:
        # Command failed (e.g., no matching process found)
        return None

# Usage example
oracle_sid = "orcl"
oracle_pid = get_oracle_pmon_pid(oracle_sid)
if oracle_pid:
    print(f"Oracle PMON PID for SID {oracle_sid}: {oracle_pid}")
else:
    print(f"No PMON process found for SID {oracle_sid}.")

Key Details: #

• shell=True: Required because we're using shell pipes (|) in the command.
• text=True: Returns output directly as a string (no need to decode bytes manually).
• shlex.quote(): Protects against shell injection attacks if the SID comes from untrusted input.

Method 2: Using subprocess.run() #

If you prefer handling success/failure without exceptions, subprocess.run() gives you more control. It returns a CompletedProcess object with details like exit code, stdout, and stderr.

import subprocess
import shlex

oracle_sid = "orcl"
quoted_sid = shlex.quote(oracle_sid)

result = subprocess.run(
    f"ps -ef | grep pmon | grep {quoted_sid} | grep -v grep | awk '{{print $2}}'",
    shell=True,
    capture_output=True,
    text=True
)

if result.returncode == 0:
    oracle_pid = result.stdout.strip()
    if oracle_pid:
        print(f"Oracle PMON PID: {oracle_pid}")
    else:
        print("No matching PMON process found.")
else:
    print(f"Command failed with error: {result.stderr.strip()}")

Why os.system() Doesn't Work for Your Use Case #

To recap: os.system() returns the exit status of the command, not its output. When you run:

oracle_pid = os.system("echo ps -ef | grep pmon | grep %s | grep -v grep | awk '{print $2}' " %(oracle_sid))

You're storing the success code (0) in oracle_pid, not the PID string the command outputs to the terminal.

内容的提问来源于stack exchange，提问作者Tanveer