Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

Unable to expand the oracle instance icon in the selection list window.

Updated: 22 May 2010 | 7 comments
Simon 1976's picture
0 0 Votes
Login to vote

BE11d on w2k, oracle 9.2.0.4 on redhat as3.
I have already set the oracle database to auto archive log mode.
I have install and config the remote agent by AgentConfig utility.

But when I explorer the resources on the media server, I can not see any resources under the oracle instance icon, a pop-up window request another credentials.

I started the beremote in debug mode with the command beremote --log-console,got the following error:

RMAN_AttachToDLE: called
RMAN_AttachToDLE: User name ()
RMAN_AttachToDLE: pwd is set
RMAN_AttachToDLE - db = test
RMAN_AttachToDLE: home_dir = /home/oracle/product/9.2.0
Current Oracle user name ()
putenv (ORACLE_SID=test)
putenv (ORACLE_HOME=/home/oracle/product/9.2.0)
OCIServerAttach() Linux 1
OCIServerAttach() Linux 2
OCIServerAttach() failed
OCIServerAttach() failed with database credentials.
OCI_ERROR: ORA-12546: TNS: permission denied
Failed to logon to database, other error: Error code (0x3102)
Returning E_RMAN_LOGON_OTHER error (0xe000fe29)
DSEnumerator failed with -536805847: 0

Oracle instance configuration in Ralus:

Entry 1
ObjectName: test
DatabaseLogin: system
MediaServerName: 1.1.1.251
JobTemplate: Default

Here is a screen copy of selection list window on media server:
http://files.myopera.com/simon.zang/blog/ra.jpgMes... was edited by:
Simon Zang

Comments

Steve Broomell's picture
30
Nov
2006
0 Votes 0
Login to vote

Did you add the Oracle server information to the Backup Exec media server under Tools | Options | Oracle | Modified list?

Simon 1976's picture
30
Nov
2006
0 Votes 0
Login to vote

Sure, I have add the account configured in the oracle agent to the media server's modified list, and the error occured when Remote Agent connect to oracle database, as the following error message said:

OCIServerAttach() failed with database credentials.
OCI_ERROR: ORA-12546: TNS: permission denied
Failed to logon to database, other error: Error code (0x3102)
Returning E_RMAN_LOGON_OTHER error (0xe000fe29)

It's strange that the oracle database credential (system) I set was not use to connect to the database, as the following message said:

RMAN_AttachToDLE: called
RMAN_AttachToDLE: User name ()

Confidence in a connected world.

Simon 1976's picture
01
Dec
2006
0 Votes 0
Login to vote

It was very strange, If I add the "sys" account to the modified list, then I can expand the icon, I can see all tablespace and control file.

But when I run a backup job, the job failed with insufficient error.

Confidence in a connected world.

Deepali Badave's picture
04
Dec
2006
0 Votes 0
Login to vote

Hello,

What is the error mesasge in the job log and in the event logs?

Regards,

Simon 1976's picture
04
Dec
2006
0 Votes 0
Login to vote

No error message in the job log, I am even unable to create the backup job, so no job log was created.

and no error message in the windows event log, for the error happened on the linux server.

Confidence in a connected world.

shweta rege's picture
05
Dec
2006
0 Votes 0
Login to vote

Hello,



-- Did you configure the Oracle configuration utility on the oracle server?


-- Under what account are the backup exec services running?




Thank You,

Shweta

Simon 1976's picture
08
Dec
2006
0 Votes 0
Login to vote

-- Did you configure the Oracle configuration utility on the oracle server?

Sure.

-- Under what account are the backup exec services running?

Which service do you mean?
Ralus: root
BE services on windows: administrator.

Confidence in a connected world.