05-20-2010
Hi,
You can use "ps -ef" command to list the processes on the server. You can grep it for oracle as follows :
# ps -ef |grep -i pmon
if you see an output with user oracle it means oracle is running on the system. you can change "pmon" with mysqld for mysql.
Niyazi
7 More Discussions You Might Find Interesting
1. Programming
Hello,
I would really appreciate some help with a problem my current client is having. He has an old legacy app that does his company's financial accounting and ERP for manufacturing, etc. The app was written by a company called "Just in time" in Austin, TX, and they are no longer in business.
... (2 Replies)
Discussion started by: w0lf
2 Replies
2. UNIX for Dummies Questions & Answers
what is the difference in running oracle database on solaris and linux operating system (3 Replies)
Discussion started by: ganga
3 Replies
3. Solaris
hi experts,
i have some problem with my oracle database 8.1.7 running on sun solaris 8, after 2 days or more i cannot login into database and needed to restart the database, below shown the error :
ERROR:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4200... (5 Replies)
Discussion started by: bucci
5 Replies
4. AIX
Hello,
How can I know if ORACLE Database is running slow due to Memory or due to processing power ?
I have only Oracle Database running on a P4 with 4GB RAM.
Could anyone suggest any tools which can help me determine exactly if it is memory issue or processor issue. (43 Replies)
Discussion started by: filosophizer
43 Replies
5. Solaris
Today I finally tuned my Solaris 11 express so now works better :D
I want to install some relational database on that machine and learn for
my future carrier.
I downloaded Oracle database 10g for Solaris x86 and tried to install it but my system didn't passed system requirements, installer... (0 Replies)
Discussion started by: solaris_user
0 Replies
6. Shell Programming and Scripting
Hi Guys,
Need you help in one point!
I am working on one shell script which takes following steps :
1. Taking one query result from oracle database
2. Exporting that result to Xls file
3. Mailing that file to my own mail ID
Now, I want to give a threshold limit to one of the column... (0 Replies)
Discussion started by: Agupte
0 Replies
7. Solaris
Hi guys
I installed Oracle database enterprise edition 11R2 on Solaris 10. More precise
$ cat /etc/release
Oracle Solaris 10 9/10 s10x_u9wos_14a X86
Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved.
Assembled 11... (1 Reply)
Discussion started by: solaris_user
1 Replies
LEARN ABOUT SUNOS
capture-schema
capture-schema(1m) Application Server Utility capture-schema(1m)
NAME
capture-schema - stores the database metadata (schema) in a file for use in mapping and execution
SYNOPSIS
capture-schema-dburl url-username name- password password-driver a_jdbc_driver [-schemaname name] [-table tablename]* [-out filename]
Stores the database metadata (schema) in a file. You can also use the Sun Java System Studio IDE to capture the database schema. Run cap-
ture-schema as the same database user that owns the tables, so that the -username and -schemaname options are given the same username.
Additionally, you can grant the database user running the capture-schema command the ANALYZE ANY TABLE privilege.
OPTIONS
-dburl JDBC URL expected by the driver for accessing a database.
-username user name for authenticating access to a database.
-password password for accessing the selected database.
-driver JDBC driver classname in your CLASSPATH.
-schemaname name of the user schema being captured. If not specified, the default will capture metadata for all tables from all
the schemas accessible to this user. Specifying this parameter is highly recommended. If more than one schema is
accessible to this user, more than one table with the same name may be captured which will cause problems.
-table name of the table; multiple table names can be specified.
-out output target; defaults to stdout. This parameter corresponds to the schema sub-element of the sun-cmp-mapping ele-
ment in the sun-cmp-mapping_1_1.dtd file.
EXAMPLES
Example 1: Using capture-schema
capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
-schemaname cantiflas -username CANTIFLAS -password enigma -driver
oracle.jdbc.driver.OracleDriver
asadmin(1M)
Sun Java System Application Server March 2004 capture-schema(1m)