- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- EMC "symioctl thaw" error msg splitting Oracle DB ...
Operating System - HP-UX
1748146
Members
3707
Online
108758
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 05:19 AM
тАО12-02-2003 05:19 AM
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 05:54 AM
тАО12-02-2003 05:54 AM
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 06:06 AM
тАО12-02-2003 06:06 AM
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 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 06:15 AM
тАО12-02-2003 06:15 AM
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
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
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP