Help for service mapping Oracle DB instance

shital6 · ‎10-19-2022

Hello All,

I need yours help. I am building the service for SAP applicaiton which is running on Linux machine. Horizantal discovery is succesful for each ci/server. when i have configured the service map for SAP applcaiton the map is showing below error on DB instance . Kindly help me to solve this errors.

2022-10-18 04:05:00: Permission issues with Credentials. Command: export TNS_ADMIN=;export ORACLE_HOME=/oracle/BRP/19;echo "select file_name as NEEBULA from dba_data_files;" |"/oracle/BRP/19/bin/sqlplus" -s Oracle_DB_user/'*****'@n0469l0048p:1521/BRP. Response: ERROR: ORA-01017: invalid username/password; logon denied SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]] where ::= [/][@] ::= [][/][@]

2022-10-18 04:05:00: Permission issues with Credentials. Command: export TNS_ADMIN=;export ORACLE_HOME=/oracle/BRP/19; echo -e set head off feed off pages 0 line 3000\\n"select DB_LINK,HOST from DBA_DB_LINKS;" | /oracle/BRP/19/bin/sqlplus -s Oracle_DB_user/'*****'@BRP. Response: ERROR: ORA-01017: invalid username/password; logon denied SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]] where ::= [/][@] ::= [][/][@] SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]] where ::= [/][@] ::= [][/][@] SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

2022-10-18 04:05:00: Permission issues with Credentials. Command: export TNS_ADMIN=;export ORACLE_HOME=/oracle/BRP/19;echo "select value as NEEBULA from v\$parameter where name='log_archive_dest';" |"/oracle/BRP/19/bin/sqlplus" -s Oracle_DB_user/'*****'@n0469l0048p:1521/BRP. Response: ERROR: ORA-01017: invalid username/password; logon denied SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]] where ::= [/][@] ::= [][/][@]

2022-10-18 04:05:00: Permission issues with Credentials. Command: export TNS_ADMIN=;export ORACLE_HOME=/oracle/BRP/19; echo "select member as NEEBULA from v\$logfile;" |"/oracle/BRP/19/bin/sqlplus" -s Oracle_DB_user/'*****'@n0469l0048p:1521/BRP. Response: ERROR: ORA-01017: invalid username/password; logon denied SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]] where ::= [/][@] ::= [][/][@]

Thank you in advance!

adilrathore · ‎10-19-2022

It seems to be a permissions issue.

TNS_ADMIN value is blank. Please debug the pattern and check why it is not getting retrieved.

Rahul Priyadars · ‎10-19-2022

Hi

2022-10-18 04:05:00: Permission issues with Credentials. Command: export TNS_ADMIN=;export ORACLE_HOME=/oracle/BRP/19;echo "select file_name as NEEBULA from dba_data_files;" |"/oracle/BRP/19/bin/sqlplus" -s Oracle_DB_user/'*****'@n0469l0048p:1521/BRP. Response: ERROR: ORA-01017: invalid username/password; logon denied SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]] where ::= [/][@] ::= [][/][@]

2022-10-18 04:05:00: Permission issues with Credentials. Command: export TNS_ADMIN=;export

As per error -User Permission n Credentials issue . Debug the Pattern and you can see the reason for failure.

Regards

RP

shital6 · ‎10-20-2022

Hello Rahul,

Thank you for giving the clue here . I am not sure the permission issue is with which credentials.

Do we need to check database credentials? or we need to check the permission of Linux server discovery service account?

I have checked the pattern in the debug mode and there also it is showing same error.

I agree the value for command "export TNS_ADMIN=" is coming as null here but my doubt is , is the because of DB credentials/linux server service account permission (oracle db is hosted on this linux machin and horizantal discovery is successful).

Could you please help me on this.

adilrathore · ‎10-20-2022

As per the document applicative/database credentials are only needed for two use cases:
Creating connections to database links
Software Asset Management activated

https://docs.servicenow.com/en-US/bundle/tokyo-it-operations-management/page/product/discovery/conce...

So it would mean that this information is extracted through Linux/SSH credentials.