Subscribe
Accepted Solution

SMO: Unable to make new profile

[ Edited ]

Hi!

 

Lately we're having SnapManager for Oracle installed by an engineer. I was following the guide he wrote to create a profile in SMO by using a wizard. Somehow this fails without an error, so I went to the Linux console at the oracle-server where I entered the following command line:

 

oracle@oraserver$  smo create -profile [profilename] -profile-password [profile_pass] -repository  -port 1521 -dbname [repository_db] -host [repo-oraserver] -login  -username [smo_admin] -database  -port 1521 -login  -username [smo_user] -password [smo_pass -dbname [databasename] -host [oraserver] -sid [sidname] -osaccount oracle -osgroup dba -comment "Profile for [databasename] database" -retain  -daily  -count 0 -duration 7 -monthly  -count 0 -duration 12 -weekly  -count 0 -duration 4 -hourly  -count 4 -duration 0 -snapname-pattern smo_{profile}_{db-sid}_{scope}_{mode}_{smid} -verbose
[ INFO] SMO-20020: Set password for profile "[profilename]" in user credentials for "oracle".
[ INFO] SMO-13036: Starting operation Profile Create on host [oraserver]
[ INFO] SMO-13046: Operation GUID [GUID] starting on Profile [profilename]
[ INFO] SMO-13505: SnapDrive environment verification passed.
[ INFO] SMO-13506: SQLPlus verification for database SID "[sidname]" passed.  Environment: [ORACLE_HOME=/home/oracle/product/11.2.0/dbhome_1]
[ERROR] SMO-05075: Profile create failed: SMO-13504: Verify operation failed. Errors: [SMO-12105: Cannot login to database. Oracle error is: ORACLE-10005: Cannot connect to database instance [databasename] using JDBC connect string jdbc:oracle:thin:smo_user/XXXXXXXX@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = [oraserver])(PORT = 1521)))(CONNECT_DATA = (SID = [sidname]))).  Error: ORA-01017: Ongeldige gebruikersnaam/wachtwoord; inloggen is geweigerd.
.]
[ INFO] SMO-20022: Deleted credentials and repository mapping for profile "[profilename]" in user credentials for "oracle".
Operation Id [GUID] failed. Error: Verify operation failed. Errors: [SMO-12105: Cannot login to database. Oracle error is: ORACLE-10005: Cannot connect to database instance [databasename] using JDBC connect string jdbc:oracle:thin:smo_user/XXXXXXXX@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = [oraserver])(PORT = 1521)))(CONNECT_DATA = (SID = [sidname]))).  Error: ORA-01017: Ongeldige gebruikersnaam/wachtwoord; inloggen is geweigerd.
.]

oracle@oraserver$  smo diag jdbc -sid [sidname] -host [oraserver] -port 1521 -username [smo_user] -password [smo_pass]
    SMO-15301: Trying to connect to...
    SID: PSNAP02
    Host: [oraserver]
    Port: 1521
    Username: [smo_user]
    Password: [smo_pass]
    As Sysdba: No
    SMO-15302: JDBC URL: jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = [oraserver])(PORT = 1521)))(CONNECT_DATA = (SID = [sidname])))
    SMO-15303: Attempting connection ...
    SMO-15307: JDBC Connected: Yes
oracle@oraserver$  smo diag jdbc -sid [sidname] -host [oraserver] -port 1521 -username [smo_user] -password [wrong_smo_pass]
    SMO-15301: Trying to connect to...
    SID: PSNAP02
    Host: [oraserver]
    Port: 1521
    Username: [smo_user]
    Password: [smo_pass]
    As Sysdba: No
    SMO-15302: JDBC URL: jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = [oraserver])(PORT = 1521)))(CONNECT_DATA = (SID = [sidname])))
    SMO-15303: Attempting connection ...
    SMO-15305: Error occurred while attempting connection: ORA-01017: Ongeldige gebruikersnaam/wachtwoord; inloggen is geweigerd.

    SMO-15307: JDBC Connected: No
oracle@oraserver$  smo version
SnapManager for Oracle version: 3.3.1
oracle@oraserver$ java -version
java version "1.7.0_85"
OpenJDK Runtime Environment (rhel-2.6.1.3.0.1.el6_7-x86_64 u85-b01)
OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)
oracle@oraserver$ sqlplus -V

SQL*Plus: Release 11.2.0.4.0 Production

oracle@oraserver$

 

I have no single clue what goes wrong. The only thing I know is that I can connect to the databases by using sqlplus and with smo diag

 

By the way:  "Ongeldige gebruikersnaam/wachtwoord; inloggen is geweigerd." means something like: "Username/password invalid; Access denied." (it's Dutch ;-))

 

Does anybody know what goes wrong and how to solve this?

Re: SMO: Unable to make new profile

try smo diag jdbc -sid [sidname] -host [oraserver] -port 1521 -username [smo_user] -password [smo_pass] -sysdba if this diag-command fails, grant the sysdba-privilege to the smo_user sqlplus / as sysdba SQL> grant sysdba to smo_user;

Re: SMO: Unable to make new profile

[ Edited ]

Thank you very much. 'smo diag ...' failed at first but then 'grant sysdba to smo_user' did the trick. Smiley Very Happy