There are different ways to connect oracle. One of them is easy connect .
You may use
sqlplus username/password@server/SID
According to comments. You can connect oracle using easy connect but hr (human resources) account does not exists.
Therefore try to use
sqlplus username/password@10.66.1.61:1521/OPTPROD
You should be able to connect your oracle system.
If you will have access to server's filesystem, or you can ask for this, you can use crontab utility. To verify whether you have access to cron, type in the following
crontab -e
If you will have an OS user,and if you can use the crontab utility to schedule a job, you can try something like this:
*/30 * * * * ~/bin/dump.bsh 1>~/bin/log/dump.log 2>&1
This simple entry make a logical backup every half hour.
The dump.bsh file:
#!/bin/bash
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:$ORACLE_HOME/bin
. $HOME/.bash_profile
now=`date +"%Y-%m-%d_%H-%M"`
expdp user/passwd directory=data_pump_dir dumpfile=lbackup$now.dmp schemas=schema_to_backup
You need to set Oracle env variables (here in the .bash_profile) since cron passes only a minimal set of env variables to your jobs.
Otherwise, go and have a look at this SQL Developer page. In the exports (expdp) section there is also a reference to automatic jobs.
Best Answer
HOWTO configure the banner
In the
sqlnet.ora
file on the server, set the values for:You may have to restart the database for the changes to take affect.
Application Requirements
The application must:
display the banner
The quote is from Oracle Documentation.
Servers cannot force clients to do something.
Will it work with ...?