Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

svrmgrl password

Status
Not open for further replies.

230173

MIS
Jun 22, 2001
208
SG
I have a script that connects to svrmgrl and does some select statements.
Now the problem is that svrmgrl asks for a password.
This only happens in the script because if i connect to svrmgrl at the command prompt he does'nt ask me for a password.
I trie to connect with the user oracle witch is in the dba group in both cases!!!!
How do i fix this so he won't ask for a password or can i include a password in the script?
This is a piece of the script:

SVRMGR=/path to the svrmgrl
$SVRMGR<<EOF >test.log 2>&1
connect internal
select.....
EOF

So why does he ask for a password in this case and if i trie to start svrmgrl manualy he does'nt!!


 
What Oracle version are you using?

Just did this on 8.1.7

svrmgrl << EOF
connect / as sysdba
select * from v\$database
exit
EOF

Works OK running from the oracle user environment

Alex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top