I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
rman/rman. My catalog db is called rman. How would you run
this shell script from the o/s such that it would run as a
background process?
Answer / jitendra
hi,
u can use the crontab utility.
crontab -e
6:35 backup_rman.sh 1 2 3 4 5 6
| Is This Answer Correct ? | 1 Yes | 1 No |
Why would you use sql agent? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
From the database level, how can you tell under which time zone a database is operating?
Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
What are the different ways of moving data or databases between servers and databases in SQL Server?
Give two examples of how you might determine the structure of the table DEPT.
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is transparent data encryption? : sql server DBA
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)