Search Results

Search found 45150 results on 1806 pages for 'oracle technology database'.

Page 310/1806 | < Previous Page | 306 307 308 309 310 311 312 313 314 315 316 317  | Next Page >

  • How to Identify and Backup the Latest SQL Server Database in a Series

    I have to support a third party application that periodically creates a new database on the fly. This obviously causes issues with our backup mechanisms. The databases have a particular pattern for naming, so I can identify the set of databases, however, I need to make sure I'm always backing up the newest one. Read this tip to ensure you are backing up your latest database in a series. Is your SQL Database under Version Control?SSMS plug-in SQL Source Control connects SVN, TFS, Git, Hg and all others to SQL Server. Learn more.

    Read the article

  • It’s that Time of Year Again… OPN Survey Time!

    - by Kristin Rose
    Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} Whether you’re still carving pumpkins or getting ready to carve a turkey, be sure to carve out your chance to win one of 5 Apple i-Pads, by taking our Oracle PartnerNetwork Survey! On October 12th, Oracle Alliances and Channels sent out invitations asking you to complete the Oracle PartnerNetwork Survey and provide feedback on Oracle’s Enablement, Partner Business Center, OPN Portal, Communications, Benefits, OPN Competency Center, Solutions Catalog and Marketing.  So, if you’re feeling as festive as we are, and received an invitation to participate, we hope you take this opportunity to provide us feedback so we can continue to drive meaningful programs and interactions with you, our partners! If you didn’t receive an invitation but still want to get the get the holidays started with your very own i-Pad, you’re welcome to send us a note at [email protected] with your candid feedback, or request to be added to the list for future surveys. The drawing for the Apple i-Pads will take place after the survey closes mid November. Thank you in advance for your participation and we look forward to receiving your response. Let the holiday season begin! The OPN Communications Team

    Read the article

  • Lipoaspiration in your SQL Server Database

    Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim. Free trial of SQL Backup™“SQL Backup was able to cut down my backup time significantly AND achieved a 90% compression at the same time!” Joe Cheng. Download a free trial now.

    Read the article

  • Oracle Solaris 11 pkg fix

    - by Larry Wake
    Bob Netherton explains why Solaris 11 pkg fix is his new friend. "So far so good. Then comes an oops... This is where you generally say a few things to yourself, and then promise to quit deleting configuration files and directories when you don't know what you are doing. Then you recall that the new Solaris 11 packaging system has some ability to correct common mistakes (like the one I just made)." [Read More]

    Read the article

  • Game Database Connectivity Java

    - by The Kraken
    I'm developing a simple multi-player puzzle game in Java. Both players should be able to view the same game board on his own computer. Then, when one player makes an action in the game (ex. drags an object onto a coordinate space), the game's view should update automatically on the other computer's game screen. I'd like all this to happen over the internet, not requiring both computers to be on the same LAN connection. If I need to use SQL/PHP to accomplish this, I'm unsure how to design the database to accomplish something as simple as the following: Player A drags element onscreen Game sends coordinates of element to database/server Player B's computer detects a change to an item in the database Player B's computer grabs the coordinates of Player A's item Player B's machine draws onscreen elements at the received coordinates Could somebody point me in the right direction?

    Read the article

  • 11g ???:Active Data Guard

    - by JaneZhang(???)
    ?Oracle 11g??,????(physical Standby)???redo???,???????,???mount??11g??,???redo???,????????read-only??,????Active Data Guard ???Active Data Guard,?????????????????,??????????????   Active Data Guard???????????,??,????????????,????????,????redo??,????????????,??????????? Oracle Active Data Guard ?Oracle Database Enterprise Edition?????,??????????????   ????Active Data Guard, ??????? read-only ????,???? ALTER DATABASE RECOVER MANAGED STANDBY DATABASE????????????:??????COMPATIBLE ????????11.0.0?  ???????Active Data Guard,???V$DATABASE????"READ ONLY WITH APPLY':      SQL> SELECT open_mode FROM V$DATABASE;      OPEN_MODE      --------------------      READ ONLY WITH APPLY   ????????????,???????real-time apply:   SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE; ?????????read-only????????:    • Issue SELECT statements, including queries that require multiple sorts that leverage TEMP segments    • Use ALTER SESSION and ALTER SYSTEM statements    • Use SET ROLE    • Call stored procedures    • Use database links (dblinks) to write to remote databases    • Use stored procedures to call remote procedures via dblinks    • Use SET TRANSACTION READ ONLY for transaction level read consistency    • Issue complex queries (such as grouping SET queries and WITH CLAUSE queries) ??????????read-only????????:    • Any DMLs (excluding simple SELECT statements) or DDLs    • Query accessing local sequences    • DMLs to local temporary tables    ?????Active Data Guard ??: • ????????????????? • ???Oracle Real Application Clusters (Oracle RAC) ,?????? • RAC???RAC??    Oracle Data Guard ?????,,????????:    * ?????????????????:     http://docs.oracle.com/cd/B28359_01/server.111/b28294/create_ps.htm   * ???Oracle Real Application Clusters (Oracle RAC) ,??????:     http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimarysingleinstance-131970.pdf   * RAC ???RAC ??:     http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimaryracphysicalsta-131940.pdf  ??Active Data Guard???????,?????:    http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr1-activedataguard-1-128199.pdf     ??Oracle Maximum Availability Architecture Best Practices?????,???:   http://www.oracle.com/goto/maa

    Read the article

  • ID?????????

    - by ???02
    ID????????????????????????ID????????????????????????Oracle Identity Manager????????????????????????????????Oracle Identity Analytics ??????????????????????ID???????????????Oracle Identity Manager -- ???????????ID?????????Oracle Identity Manager (?? OIM )??ID?????????????????????????????????ID???????????????????????????????????????????????????????????????????????????OIM ?????????????????????????????????????????????????????? OIM ??????????OIM ????????????????????????/??/???????/??????????????????????????????????????????????????????????????????????OIM ???????????????????????????????????????????????????????????????????(1)ID?????????:??~??~??~???????????????????????????????????(2)ID????????:??????ID???????????????·??????????????????(3)??ID????:????????????????????????ID·??????????????????????????????????????(4)???????????????????:???????????1???????????????????????????????????(5)ID??????????????:???????????????ID???·????????????????????(6)ID???????????????:ID?????????·????????????????????????????????????????Oracle Identity Analytics -- ????????·?????????????????Oracle Identity Analytics? (?? OIA )????????????(??)???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????OIA????????????????????????????????????????????????????(1)??????????????????????????????????????(2)?????????????????? : ??(hierarchical)???(relationship)???????????????(3)ID?????????(OIM?)????????????????????? ??????????? ?????? Oracle Direct

    Read the article

  • Errata of Expert Oracle Exadata Chinese Edition-???? Oracle Exadata ???

    - by Bandari Huang
    P10 ????CPU???Westmere??,?????AES??????,????????????????????? Because these CPUs are in the Westmere family, they have built in AES encryption support, which essentially provides a hardware assist to encryption and decryption. P39 ????????????,???????????????????????? particularly with the higher levels of compression, the decision was made to do the decompression on the storage servers.  

    Read the article

  • ??3???????·???·???????????:?????|Oracle Coherence|??????

    - by ???02
    ?????·???·????????????????????2????????????????????????????·???·??????????????????????????????????·???·??????????????????????·??????????????????????????????????????????????????????????4????????????(3)???????????????·??????????????(4)????????????????????????????(5)??????????????????????????(6)??????·?????????????(3)???????????????·?????????????????????????????????????????????????????????????????????????????????????????·???·?????????????????????????????????????????????????????·??????????????????????????????????????????????????????????·???·????????·????????????????????????????????????????(??????8)??????????????????????????????????????·???????????????????????????????????????????????????(4)????????????????????????????????????????????????????????????????? ????????·???·??????????·???????????????????????·???·???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????(?????????????????????????)??????????????????????????????????????????(5)???????????????????????????????·????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????·??????????????????????????????·?????????????????????????????????????????????·???·?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????(?9)?????(6)??????·???????????????????????1?????????????????·??????????????????????????????·?????????????????????????????????????·???????????1?????·?????????????????????????????????????????Coherence?????????????????????·?????????????????????????·???????????????????????????????????????·???????"???????·???"????????·???·?????????????(?10)???????????????????????????·???????????????????????????????????????????·??????????????????·???·???????????????????????????????????????????????????????????????????????????????????????????????????????·???·????????????·???????????????????????????????????????????????????????????·????????????????????????·???·?????1?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????12

    Read the article

  • ??3???????·???·???????????:?????|Oracle Coherence|??????

    - by ???02
    ???????? ???????? Fusion Middleware???????? ??????????? ???????? Fusion Middleware??SC?? ???????????????? ???????? Fusion Middleware??SC?? ????????????????·???·?????????????????????????·???·???????????????????????????????????????????????????????????????????????????????????????·???·?????????????3???????????????·??????????·???????????????????????????????????????·?????????????·???·???????????????????????5?????????·???·??????????????????????·???????????????????????·???·???????????????????????????????????????????????·??????????????????????????????????????????????????????????????????????????????????(1)??????·???????????????(2)???HTTP?????????????2???????????????????????????·???·??????????????????????????????????????????????????(1)??????·??????????????·????????????????????·?????????????????????????????????????????????????????????????????·??????????????????????????????????????·???·????(JVM????)????·????????????????????????·??????(GC)????????????·????????????????????????????????·??????????????????????????????????????????????????????????????????????????????????????????????????????????OutOfMemoryError????????????????·???·????????????????????????????????????·???(??·?????????·???)????????????????????????????????????????????????(?6)??????????????????????????·??????????????????????????????????????·???·??????????·???????????????????????????????????·?????????????????????????????????????????(2)???HTTP???????????HTTP???????????????????????????????????????????????????????????????????????1??????????????????????????????????????????????????????·????????????·??????/???????????·????????????????????????????????????·???????GC?????????GC???????????????????????????????????·?????????·??????????????????????????????????????????????????(????????????·???????????????????????)?????????????????????????????·???·??????HTTP?????????????????????(?7)??7???????????????????·???????????????????????????????GC???????????????????????????·???????????????????????????????·?????????????????????????·??????????????????·???·???????????????3??3 ???????????????????????·???·???????HTTP???????????????????????12??

    Read the article

  • ??2???????·???·???????????????|Oracle Coherence|??????

    - by ???02
    ?????????????????????·?????????????????????????·??????????????????????????????·???????????????·???·??????????????????????????????????????????????????????·??????????????????????·????????????????????·?????????????????????????·?????????(???????????·??????)?????????·??????????????????????????????????????????????????????????/????????????????????????????????????????????????·?????????????(?2?1)??????????????????????????????·??????????????????????????????????????????·????????????????????????????????????????1???????????????????????????????????????????????????????????????????????????????????????????2???????????????????????????·????????????·????????????????????????????·????????????????????·?????????????·????????????·??????????·?????????????????????????????????????????????????????????????????????????????????????????????????3 ?????????????·??????????????·?????????????????????·????????????????????????????????????????????????????????????????????????????????????????·?????????????????????·?????????????????????????????·?????1?????????·???????????(???????????????????????????????????????????????????????????????????)?????????????????/??????????????????????2?????????·????????(???????????1???)????????·?????????????1????????????????????????????????????????????????????4??????????????????1,000?/??????????????????????????·????????????????????????·???????????????????????????1?????1,000????????????????????????????·????????????????????????1?????1???????1???????·????????????????????????????/??????????????2,000?/??????????????500?/??????????????????·???·???????????????????2??????????????2??????????1 ???????·????????????????????·????????????·??????????????????????????2???????????????????????????????? 2 ?????2?????????????????????????(??????Person)????????????????????????????????????·?????????????????123??

    Read the article

  • ??2???????·???·???????????????|Oracle Coherence|??????

    - by ???02
    ???????? ???????? Fusion Middleware???????? ??????????? ???????? Fusion Middleware??SC?? ???????????????? ???????? Fusion Middleware??SC?? ????????????????·???·??????????????????????????????????·???·??????????????????????????????????????????????????????????????????????????????????2??????????????????????·???????????????·????????????????????????????????·????????????????·??????????????????????????????????????????????????????????????????????????(????????·??????)?????????????????????????(?1)?1???????·?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????·?????????????????????????????????????????????????????CPU??(?????????????????·??????)??????1????????????????????????????????????????????????????1,000?/???????????????????????????1??????1,000?????????????????·?????????????????????????????????????????·?????????????????(???????????????????)???????????????????????????????·????????????????????1???????????????????????????????????????????123??

    Read the article

  • ??1???????????????!???????????????|Oracle Coherence|??????

    - by ???02
    ???????? ???????? Fusion Middleware???????? ??????????? ???????? Fusion Middleware??SC?? ???????????????? ???????? Fusion Middleware??SC?? ???????????????????????????·??????????????????/????????????????????????????????"??????·????(??????·????)"??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????!??????????????????????????????????????????????????????????????????????????????????????????????????????"??"???????????????????????????????????????????????????????????????????????????????????????????????????----????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????(?????????????????????????????)?????????????????????????????????????????????????????????????????????????????????????????????·???????????????????????????????????????????????1??????????????????????????????????????????????????????????????????????/????????????????????????·??????????????????????????????????????????????????????·???????????????????????????????????????????????????????????????????????????????????·???????????????????????????????????????????????????????????????????????????????????????·????????????????·??????????????????????????????????????????????????????????????????????????????·?????????????????????????I/O??????????????????????----???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????(ROI:Return On Investment)????????????????????????????????????????????????????????????4???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????4????????????1)??????????????(???·??????????????????)2)??????????????(????????·??????/???????)3)????????????????????(???????????????????????????????)4)????????????????????????(???????)?????(1)?(2)???????????????????????????????????????????????????????????????????????????????RDBMS??????????????????(3)?(4)???????????????????????????????????????????????RDBMS??????????????????????????????????????????????RDBMS???????????????????????ROI????????????(3)?(4)??????????????????????(1)?(2)??????????????????????(??????????????·?????)????????????????????????????"?????"????????????????????????????????????????????????????????????????????????????????????????????RDBMS(?????)????????????????????????????·??????????????????????????(3)?(4)????????????????????????????????/??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????IT??????Vol.22??????????????????????·??????????IT???????????????????????12??

    Read the article

  • ??1???????????????????????????????|Oracle Coherence|??????

    - by ???02
     ???????????????????????????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ????????????????????????????????SEO???????????????????????????????????????????????????????????????EC??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????????/??????????????????????????????????????????????????????????(???)???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????????????????????(????)?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????IT??????????????????????????????????????????????? ??????????????EC???????????????????????????????????????????????????????????????????????????????????????EC??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????…?Coherence????????????!?????EC??????????!????????????????????????????????????????????????????????????????????????????????????? ????????????????? ????????????????????????!????????????????????·????????????????????????????????????????????????

    Read the article

  • ??????(????·?????)

    - by ???02
    ??????(????·?????)??????????????????????????????????????????????????????????????????????????????????·??????????????????????????????????????Web?????·???????????????????????????????????????????????????????????????????·????????????????????????????????????????????????Web???????????Oracle Access Manager????????????????????????·??????????Oracle Enterprise Single-Sign On Suite????????????????????????????????????-??????????-?????????????Oracle Access Manager -- Web??????????·???????????????Oracle Access Manager??Web??????????????·????????????????????????????????????????????· ?????·????????????????????????????????????????????????????????????? ??????(1)??????:????·?????????????????????(2)???????????:??Web?????????????????????????????????????(3)????????:??????????????????(4)??????:????·???????????????????????Oracle Enterprise Single Sign-On Suite -- ???????????????·????????Oracle Enterprise Single Sign-On Suite??Web??????????????????????????????(?????????????????????????????)? ?????·????????????????????????·????????????????????????????????????????? ???????????????????????????? ??????(1)???????????????(2)??????????????????????????????????????????????????????????????????(3)??????????Windows???LDAP??????????????(4)Windows???????????????????????????????????(5)ID??????????????????????ID???·?????????????????????? ?????? Oracle Direct

    Read the article

  • Intel Rapid Storage Technology (pre-OS) driver installation

    - by Nero theZero
    My desktop machine is built on Gigabyte GA-Z87-UD3H and Gigabyte provides the latest driver for Intel Rapid Storage Technology (IRST), which I installed after installing the OS. Same goes for my Lenovo Thinkpad-T420. And for both machine, checking the controller device under the IDE ATA/ATAPI Controllers section in Device Manager I see the driver has been updated to the latest version. I set the SATA controller to AHCI from BIOS On the desktop machine I have one WD 2TB BLACK & one WD 3TB Green I don’t use RAID, & no chance of using in near future, but according to Intel IRST improves performance in single disk scenario too. Now I have the following questions – What is the actual purpose of IRST (pre-OS install) driver that doesn’t get served with a post-OS driver that I installed? There must be some difference, otherwise there wouldn’t be a pre-OS version of the driver. Right? In the pre-OS procedure (loading the drivers at OS-installation time) after successfully completing the OS installation, do I need that post-OS driver? Because after installing from that one I got a quick launch icon that runs the IRST configuration application. Where do get that after installing the pre-OS driver? As it is “pre-OS”, when I load it at OS-installation time, does it updates anything at BIOS level or anywhere other than HDD? That’s because I’m going to dual boot Windows 7 with Windows 8.1, and after installing Windows 7 when I install Windows 8.1 & load the IRST driver for that, is there any chance of any “overwriting” or OS-incompatibility? In short, is there anything specific to follow while installing the second OS?

    Read the article

  • Drobo FS vs Lime Technology unRAID vs FreeNAS

    - by elluca
    I already decided to by a drobo fs until I just found these two tests: http://www.digitalversus.com/data-robotics-drobo-fs-p889_9543_487.html http://www.digitalversus.com/lime-technology-unraid-p889_8992_473.html The two cons agains drobo for me: loudness price What disadvantages has the unraid stuff against the drobo fs? Has it also got that ease of use like swapping drives on the go, simply extend capacity by plugging in new drives, notify me of drive errors, disk failure protection, dynamic space of "partitions", better/worse effective capacity, etc. Which is more secure? Am I able to simply replace a bad drive with a new one on unraid? What happens if my pc fails? Lets say the cpu overheats. Since I have a complete pc which is going to be replaced, I only have to pay the software to use unraid. I am going to use my nas for: music library (how well does it integrate with iTunes? ) picture library movie library development (i need to be able to be to use time machine) I am going to use this nas with a MacBook pro. My current disks: 2x 500Gb 1x 1.5Tb 1x 2Tb On a drobo fs I would have 2.26 Tb of space. What would it be on unraid? Is FreeNAS also an alternative?

    Read the article

  • Writing a docx file to a BLOB using Java 1.4 inside Oracle 10g

    - by Jon Renaut
    I'm trying to generate a blank docx file using Java, add some text, then write it to a BLOB that I can return to our document processing engine (a custom mess of PL/SQL and Java). I have to use the 1.4 JVM inside Oracle 10g, so no Java 1.5 stuff. I don't have a problem writing the docx to a file on my local machine, but when I try to write to BLOB, I'm getting garbage. Am I doing something dumb? Any help is appreciated. Note in the code below, all the get[name]Xml() methods return an org.w3c.dom.Document. public void save(String fileName) throws Exception { ZipOutputStream zos = new ZipOutputStream(new FileOutputStream(fileName)); addEntry(zos, getDocumentXml(), "word/document.xml"); addEntry(zos, getContentTypesXml(), "[Content_Types].xml"); addEntry(zos, getRelsXml(), "_rels/.rels"); zos.flush(); zos.close(); } public java.sql.BLOB save() throws Exception { java.sql.Connection conn = DbUtilities.openConnection(); BLOB outBlob = BLOB.createTemporary(conn, true, BLOB.DURATION_SESSION); outBlob.open(BLOB.MODE_READWRITE); ZipOutputStream zos = new ZipOutputStream(outBlob.setBinaryStream(0L)); addEntry(zos, getDocumentXml(), "word/document.xml"); addEntry(zos, getContentTypesXml(), "[Content_Types].xml"); addEntry(zos, getRelsXml(), "_rels/.rels"); zos.flush(); zos.close(); return outBlob; } private void addEntry(ZipOutputStream zos, Document doc, String fileName) throws Exception { Transformer t = TransformerFactory.newInstance().newTransformer(); ByteArrayOutputStream baos = new ByteArrayOutputStream(); t.transform(new DOMSource(doc), new StreamResult(baos)); ZipEntry ze = new ZipEntry(fileName); byte[] data = baos.toByteArray(); ze.setSize(data.length); zos.putNextEntry(ze); zos.write(data); zos.flush(); zos.closeEntry(); }

    Read the article

  • Issue configuring Oracle database for SSL

    - by Santhosha
    Hello, I want to setup Oracle for SSL communication. I am not using SSL authentication for database user. As first requirement, generated self signed certificate using OpenSSL and added certificate to wallet. The wallet location is specified in server configuration. Created listener and it is starting however it does not provide any service. The default listener (non SSL) is working fine. When I execute LSNRCTL.EXE status SSLLISTENER it gives below output. STATUS of the LISTENER Alias SSLLISTENER Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production Start Date 14-NOV-2009 01:47:08 Uptime 16 days 22 hr. 14 min. 3 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File C:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora Listener Log File c:\app\administrator\diag\tnslsnr\\ssllistener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=)(PORT =2484))) The listener supports no services The command completed successfully Here is exact content of various files after configuration. 1) File Name: tnsnames.ora ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 2) File Name: sqlnet.ora SSL_VERSION = 0 NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) sqlnet.authentication_services= (NONE) tcp.validnode_checking = no tcp.invited_nodes=(PS0803.oraebs.com,PS2948,PS5098) SSL_CLIENT_AUTHENTICATION = FALSE WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = C:\app\Administrator\admin\orcl\Server_Wallet) ) ) 3) File Name: listener.ora S SL_CLIENT_AUTHENTICATION = FALSE WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = C:\app\Administrator\admin\orcl\Server_Wallet) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT 1521)) ) ) SSLLISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = )(PORT = 2484)) ) Thanks Santhosh

    Read the article

  • Getting a ResultSet/RefCursor over a database link

    - by JonathanJ
    From the answers to http://stackoverflow.com/questions/1122175/calling-a-stored-proc-over-a-dblink it seems that it is not possible to call a stored procedure and get the ResultSet/RefCursor back if you are making the SP call across a remote DB link. We are also using Oracle 10g. We can successfully get single value results across the link, and can successfully call the SP and get the results locally but we get the same 'ORA-24338: statement handle not executed' error when reading the ResultSet from the remote DB. My question - is there any workaround to using the stored procedure? Is a shared view a better solution? Piped rows? Sample Stored Procedure: CREATE OR REPLACE PACKAGE BODY example_SP IS PROCEDURE get_terminals(p_CD_community IN community.CD_community%TYPE, p_cursor OUT SYS_REFCURSOR) IS BEGIN OPEN p_cursor FOR SELECT cd_terminal FROM terminal t, community c WHERE c.cd_community = p_CD_community AND t.id_community = c.id_community; END; END example_SP; / Sample Java code that works locally but not remotely: Connection conn = DBConnectionManagerFactory.getDBConnectionManager().getConnection(); CallableStatement cstmt = null; ResultSet rs = null; String community = "EXAMPLE"; try { cstmt = conn.prepareCall("{call example_SP.get_terminals@remote_address(?,?)}"); cstmt.setString(1, community); cstmt.registerOutParameter(2, OracleTypes.CURSOR); cstmt.execute(); rs = (ResultSet)cstmt.getObject(2); while (rs.next()) { LogUtil.getLog().logInfo("Terminal code=" + rs.getString( "cd_terminal" )); } }

    Read the article

< Previous Page | 306 307 308 309 310 311 312 313 314 315 316 317  | Next Page >