Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Decimal value loading

652244Mar 24 2010 — edited Mar 24 2010
Hi Experts,

We are using Hyperion FDM 9.3.1 to load data to HFM. When we load decimal values , the output data file generated by FDM looks fine. But after loading the data to HFM, the decimal point does not appear. For example, when we load a value 698.7 , the value gets loaded as 6987 in HFM. Is there any setting in FDM that has to be set. This is happening only for certain locations.

Thanks
Kannan.

Comments

Hello,

Kindly provide below output:

ps -ef | grep tns

srvctl config listener -l LISTENER_FOR_CIGI

You should always run "lsnrctl status <LISTENER_NAME>" command in right ORACLE HOME with owner of listener process.

Regards,

Adi

Alain

-bash-4.2$ srvctl config listener -l LISTENER_FOR_CIGI

Nom : LISTENER_FOR_CIGI

Type : Database Listener

Réseau : 1 ; propriétaire : grid

Répertoire de base : <CRS home>

Adresses : TCP:1522

Le processus d'écoute est activé.

Le processus d'écoute est activé individuellement sur les noeuds :

Le processus d'écoute est désactivé individuellement sur les noeuds :

eronitascott

/*+ starting a RAC node instance & listener:

root> export ORACLE_SID=orcl1

root> srvctl start nodeapps -n linux1

root> srvctl start asm -n linux1

root> srvctl start instance -d orcldb -i orclnode

root> srvctl start mylistwener

root> emctl start dbconsole

Or do it all in one command:

root>  svrctl start database -d orcldb

/*+ shutdown a RAC node instance & listener:

root> export ORACLE_SID=orcl1

root> emctl stop dbconsole

root> srvctl stop instance -d orcldb -i orclnode immediate

root> srvctl stop asm -n linux1

root> srvctl stop nodeapps -n linux1

root> srvctl stop mylistener –I 2

Or do it all in one command:

root>  svrctl stop database -d orcldb

Alain

Did you read the question? The problem is not to start the listener nor to view the status in srvctl. In srvctl it just works!

The question is "how to see it using lsnrctl status, and so to view all databases registered to it"!

PTimmermans

If you run lsnrctl status as user oracle, maybe you should do a symlink in the $ORACLE_HOME/network/admin directory pointing to the listener.ora file in the GRID_HOME directory ?

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 21 2010
Added on Mar 24 2010
2 comments
1,666 views