nandamuribidda Posted February 26, 2011 Report Posted February 26, 2011 hello baa's okka project succesfull ga complete chesaanu ippudu inkoka daniloki veltunna dtw lo now i have a question what is connection string (database perspective) i need it in configuring oracle business intelligence it is asking for the connection string of the DB installed and it is of a format hostname:portname:instance something but i couldn't fix it up can someone help me with it
graham Posted February 26, 2011 Report Posted February 26, 2011 connection string ante nee code DB ni access cheyataniki kavalasina address lantidi annamata... data base server name, instance name, user name, password, port number ivanni ichi construct chestaru oka specified syntax lo. chitti ichina link chudu + net lo chaala examples untayi vethuku.
nandamuribidda Posted February 26, 2011 Author Report Posted February 26, 2011 ardham kavatledu i know it is a set of db name, instance name,username and passwd port number and all but i couldn't prepare
graham Posted February 26, 2011 Report Posted February 26, 2011 [quote author=nandamuribidda link=topic=160416.msg1918306#msg1918306 date=1298749440]ardham kavatledu i know it is a set of db name, instance name,username and passwd port number and all but i couldn't prepare[/quote]idi chudu [url=http://www.connectionstrings.com/oracle]http://www.connectionstrings.com/oracle[/url]
nandamuribidda Posted February 26, 2011 Author Report Posted February 26, 2011 i have used oracle xpress edition of 10g and tell me anyother way to find out m server and instance name port is 8080i tried lsnr status in dos which didn't gave me the one which i am looking at
graham Posted February 26, 2011 Report Posted February 26, 2011 [quote author=nandamuribidda link=topic=160416.msg1918308#msg1918308 date=1298749519]i have used oracle xpress edition of 10g and tell me anyother way to find out m server and instance name port is 8080i tried lsnr status in dos which didn't gave me the one which i am looking at[/quote]Server Name teleeda? machine name = server name ba if u r using Oracle in the same machine. i dont get ur q. see this: [url=http://oracle.ittoolbox.com/documents/view-serverdatabase-name-in-oracle-9i-13850]http://oracle.ittoolbox.com/documents/view-serverdatabase-name-in-oracle-9i-13850[/url]
Minister Posted February 27, 2011 Report Posted February 27, 2011 [quote author=nandamuribidda link=topic=160416.msg1918250#msg1918250 date=1298748198]hello baa's okka project succesfull ga complete chesaanu ippudu inkoka daniloki veltunna dtw lo now i have a question what is connection string (database perspective) i need it in configuring oracle business intelligence it is asking for the connection string of the DB installed and it is of a format hostname:portname:instance something but i couldn't fix it up can someone help me with it[/quote]hostname:portname:instancehostname: ante you can use an alias of the server or the ip address of the server (on which Oracle DB is installed).Portname: database ki oka service vuntundi adi ee port use cheyyalo Database engine ni install chese time lo specify chestaru .... AIX operating system ayithe kanaka /etc/services file lo oka entry vuntundi ....Instance: Database Engine ni install chesina tarvatha manam instances create chestam... nuvvu connect avvali anukunna instance edaithe adi... usually, on unix based servers it will be a username (naku Windows environmane pina idea ledu)In general to connect to any database, you will need database name also... so, you have to identify correct syntax for the connection string.Along with the above mentioned ones, you may need more details for authentication ...Good Luck
Recommended Posts