2012-04-27 12:57 PM - edited 2015-12-18 01:19 AM
I created a repository in one of my 11gR2 Oracle databases. Now I'm trying to create a profile for another 11gR2 database with this command:
smo profile create -profile devdb_bkup -repository -dbname prod -host host_name -port 1521 -login -username netapp -database -dbname devdb -host db_host_name -login -username uname -password pwd -port 1521 -rman -controlfile -osaccount os_uname -osgroup ora_dba
I get following error stack during this operation:
[ERROR] SMO-09013: Execution of query on the repository netapp@prod
/[host_name]:1521 failed. ORA-00942: table or view does not exist
[ERROR] SMO-09025: Repository version information not found within repository.
[ INFO] SMO-20022: Deleted credentials and repository mapping for profile "devdb_bkup" in user credentials for "os_uname".
Operation failed. Error: Repository version information not found within repository.
I have this information stack from my earlier repository creation:
[ INFO] SMO-09202: Creating new schema as netapp on jdbc:oracle:thin:@//host_name:1521/prod.
[ INFO] SMO-09205: Schema generation complete.
[ INFO] SMO-09209: Performing repository version INSERT.
[ INFO] SMO-09210: Repository created with version: 102
[ INFO] SMO-13048: Repository Create Operation Status: SUCCESS
[ INFO] SMO-13049: Elapsed Time: 0:00:09.157
2012-05-03 01:23 AM
I believe the user you have configured to use does not have enough permission to login to the database and create appropriate tables. Can you execute the following?
SQL> grant connect, resource to <smo_repo_user>*;
SQL> grant create table to <smo_repo_user>*;
<smo_repo_user> is the username that you are using in your configuration
2012-05-03 06:13 AM
Thanks for your help. I have actually logged in to SQL plus and checked
to see if the user has privileges to create/drop tables and it does. As I
mentioned, the error I'm getting is actually invalid username and password
error for the SYSDBA account. I also made sure that the password is typed
correctly. So looks like there is something missing.
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to
any order or other contract unless pursuant to explicit written agreement
or government initiative expressly permitting the use of e-mail for such