Operating System - HP-UX
1748146 Members
3707 Online
108758 Solutions
New Discussion юеВ

EMC "symioctl thaw" error msg splitting Oracle DB BCVs..

 
Stuart Abramson_2
Honored Contributor

EMC "symioctl thaw" error msg splitting Oracle DB BCVs..

I'm using "symioctl" to "clone" an Oracle SID BCV instance.

The command sequence is:

symioctl archive log -noprompt
symioctl -type oracle begin backup -noprompt
symioctl -type oracle freeze -noprompt
symmir -f ${BCVFILE_DB} -sid ${SID} -instant split -noprompt
symioctl -type oracle thaw -noprompt <== I get the error here
symioctl -type oracle end backup -noprompt
symioctl archive log -noprompt
symmir -f ${BCVFILE_AL} -sid ${SID} -instant split -noprompt

Notice that I've done 3 "symioctl" commands already!

The EMC "debug" output is below.

Apparently I have enough permissions to "freeze" the Oracle Database, but not enough to "thaw" the database. Is there something special that you have to do to set up the Oracle ID?

Stuart

============================================================


# symioctl -type oracle thaw -noprompt

emcMapPopen env: LC_ALL=C
emcMapPopen env: ORACLE_HOME=/u1001/app/oracle/product/9.2.0
emcMapPopen env: ORACLE_SID=HOTB
emcMapPopen env: TZ=EST5EDT
emcMapPopen emcMapPopen: FILE * = 7B0413A0
SymDbListControl Oracle OCI: Matched command 33, Thaw

SymDbListControl Oracle OCI: Oracle return code=0

SymDbListControl Oracle OCI: Attaching to service

SymDbListControl Oracle OCI: Starting Session

SymDbListControl Oracle OCI: Connecting to Oracle as system

SymDbListControl Oracle OCI: gid has been set to 103

SymDbListControl Oracle OCI: Oracle return code=0

SymDbListControl Oracle OCI: Attaching to service

SymDbListControl Oracle OCI: Starting Session

SymDbListControl Oracle OCI: Connecting to Oracle as system

SymDbListControl Oracle OCI: Oracle return code=1031

SymDbListControl Oracle OCI: ORA-01031: insufficient privileges <== ERROR from Oracle

SymDbListControl Oracle OCI: OracleLogoff

SymDbListControl dbCheckRdbStatus failed, RDBMS program returned failure 571 (internal 9)
emcMapPclose emcMapPclose FILE * = 7B0413A0; RC = 0
SymDbListControl Function Completed; status = 571 (A Login error occurred within the RDBMS program)

A Login error occurred within the RDBMS program <== ERROR from EMC symioctl


Stuart Abramson | Off: 412/825-1434 | Cell: 412/417-1567 | email: sabramson@wabtec.com

3 REPLIES 3
Ashwani Kashyap
Honored Contributor

Re: EMC "symioctl thaw" error msg splitting Oracle DB BCVs..

I am not an oracle person , however I noticed that the script is using system to login to oracle instead of SYSDBA in 9i . Does it make a difference .

How ever I found this note on the EMC site . Hope this helps :

As Oracle 8i (SYSDBA) account grants access to all tables/views/etc but Oracle 9i does not.

What happens is that the SYSDBA must grant (to it's own account) the privileges of/to the entire data dictionary or - at least - at least 12 items in order to perform Timefinder-based Oracle hot backups.

dba_data_files
dba_free_space
dba_indexes
dba_tables
dba_tablespaces
sys.all_objects
sys.dba_data_files
sys.dba_extents
sys.dba_free_space
sys.dba_indexes
sys.dba_nested_tables
sys.dba_objects
sys.dba_segments
sys.dba_tab_partitions
sys.dba_tables
sys.dba_tablespaces
sys.dba_users
sys.v_$controlfile
sys.v_$datafile
sys.v_$instance
sys.v_$log
sys.v_$logfile
sys.v_$parameter
sys.v_$system_parameter
sys.v_$version
Ashwani Kashyap
Honored Contributor

Re: EMC "symioctl thaw" error msg splitting Oracle DB BCVs..

I don't know hpw much of a help will this be , but I found this regarding oracle backups with timefinder but I am putting it as an attachment .
Stuart Abramson_2
Honored Contributor

Re: EMC "symioctl thaw" error msg splitting Oracle DB BCVs..

Ashwani:

These sound like very good leads. (Better than I got from our DBA.) I'll check them out with her and post points later.

..Thanks,

....Stuart