Turn Your Vehicle Into a Smart Earning Asset

While you’re not driving your car or bike, it can still be working for you. MOTOSHARE helps you earn passive income by connecting your vehicle with trusted renters in your city.

🚗 You set the rental price
🔐 Secure bookings with verified renters
📍 Track your vehicle with GPS integration
💰 Start earning within 48 hours

Join as a Partner Today

It’s simple, safe, and rewarding. Your vehicle. Your rules. Your earnings.

Oracle Tutorials: Command line reference


# Oracle command to list the database
$ lsnrctl status

# How to know list of Oracle instance in my cluster?
$ srvctl status instance -db <db_name>
$ srvctl status instance -db orcl

# This command will display the current status of the "sales1" database instance on the "node1" node, including whether it is running or not, and any other relevant information about the instance's state.
$ srvctl status instance -d <database_name> -i <instance_name>
$ srvctl status instance -d sales -i sales1 -n node1

# Command to Know all list of oracle rac node
$ olsnodes -n -i

# check the status of nodes
$ srvctl status nodeapps -n <node_name>

# check the status of all nodes
$ srvctl status nodeapps 

# To check what database we have in this cluster.
$ srvctl config database
$ srvctl status database -d bbdc
$ srvctl status database -d bbdc -n node-name1

# Verify that all the nodes in the RAC cluster are up and running
$ crsctl stat res -t

# Check the status of the RAC database
$ srvctl status database -d <database_name>

# Ensure that the RAC database is in ARCHIVELOG mode
$ archive log list

# Ensure that the RAC database has the necessary tablespaces
$ select tablespace_name from dba_tablespaces;

# Verify that the RAC database has the required privileges
$ select * from dba_sys_privs where grantee='<user>';

# This command displays the SCAN name, SCAN IP address, and SCAN port number for the RAC cluster. You can also use the DNS or a local host file to look up the SCAN IP address.
$ srvctl config scan

# Connect a Oracle Cluster and List the users
$ sqlplus BAOBAB/Tcb#1234567@TWOUATDR
SQL> select table_name from users_tabels;Code language: PHP (php)

Subscribe
Notify of
guest
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.

0
Would love your thoughts, please comment.x
()
x