pioro
commented
10 years ago I have added possibility to use SID or TNS to connect to repository. There is an another question
Enter TNS alias to connect to database - required for 12c plugable DB [leave it empty to use SID]?
and based on that SID or alias is using in connection.
Hi Marcin, Here my scenario: Create a pluggable database 12c called SASH. Connect like sysdba on pluggable db to install repo. Run config.sql script but
SQL> @config.sql "------------------------------------------------------------------------------------"
Creating repository owner and job kill function using SYS user "------------------------------------------------------------------------------------" Enter user name (schema owner) [or enter to accept username sash] ? SASH Enter user password ? SASH Enter SASH user default tablespace [or enter to accept USERS tablespace] ? SASH default tablespace is: users "------------------------------------------------------------------------------------" Existing SASH user will be deleted. If you are not sure hit Control-C , else Return : "------------------------------------------------------------------------------------" New SASH user will be created. Warning: Procedure created with compilation errors.
ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE.
The problem was in config.sql here: connect &SASH_USER/&SASH_PASS
So I changed repo_user.sql here adding: accept SASH_TNS default @SASH prompt "TNS String Connection [or enter to accept @SASH string connection] ? "
Where I set TNS connection string for my pluggable database.
After I changed also config.sql here: connect &SASH_USER/&SASH_PASS&SASH_TNS
Now the connection works fine and installation is performed without problem. Let me know ...when you have time. Ciao Alberto