Skip to main content

Hi all,

 

during installation of FSM i greeting mentioned below


Starting install of FSM 6 database...
Parameters passed...
    Oracle Instance........FSM
    System/DBA User........SYSTEM
    System/DBA Password....*********
    Database User..........fsm
    Database Password......*********
    Table Tablespace.......USERS
    Index Tablespace.......USERS
    Datapump...............DATA_PUMP_DIR
Clearing old metadata...

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jul 19 23:07:47 2022

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus


You cannot call a method on a null-valued expression.
At C:\Users\Administrator\Desktop\FSM6u14\DatabaseData\Oracle\NewInstall\FSM_Install.ps1:48 char:39
+     WriteToHostAndLog "Exception Type: $($_.Exception.GetType().FullName)"
+                                          ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) ~], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

Exception Type:
Exception Message:

CleanUp : The term 'CleanUp' is not recognized as the name of a cmdlet, function, script file, or operable program.
Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At C:\Users\Administrator\Desktop\FSM6u14\DatabaseData\Oracle\NewInstall\FSM_Install.ps1:52 char:5
+     CleanUp
+     ~~~~~~~
    + CategoryInfo          : ObjectNotFound: (CleanUp:String) n], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

Press Enter to exit.:

 

regards

Hi,

I believe there is an issue with the tnsnames.ora on your host. Verify that the Oracle DB connection string is correctly in the tnsnames.ora and specifiy the correct Service Name in the FSM Installer.

Check also, if you can login to the DB by using sqlplus command.

 

Best regards
Roman

@WSHAH,

 

As mentioned by @roklde, you have the below options to check in your environment

  • Check the tnsnames.ora file.

Oracle client will be installed in locations like below(check environment variables related to this to understand the example oracle client installed path)

 

C:\app\client\MERIWW\product\19.0.0\client_1\NETWORK\ADMIN\tnsnames.ora

C:\app\oracle\product\19.0.0\client_1\NETWORK\ADMIN\tnsnames.ora

 

Open tnsnames.ora file and check SERVICE_NAME there.

  • Check the connection to the oracle db using command line

CMD command - sqlplus -L username/password@serviceID

  • If you can connect to the database using above command, check oracle_home and tns_admin are set correctly in environmental variables

Thanks,

Hasara

Hi All,

I have currently installed oracle 12c Instance, so there is no Service_name in TNS

Regards

@WSHAH, found the below post.

 

https://databaseinternalmechanism.com/2018/12/20/ora-12504-tns-12504-tnslistener-was-not-given-the-service_name-in-connect_data/

 

Thanks,

Hasara

Reply


Terms & ConditionsCookie settings