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?
