How can we see the database version in os level
Answer Posted / kittu
]$ $ORACLE_HOME/OPatch/optach lsinventory -all
the above statement will display total oracle software locations
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
what is the role of dip user in our database?
what do you understand by flashback feature of oracle?
how can you communicate with operating system files from oracle?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what is asm?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?