Search Results

Search found 14452 results on 579 pages for 'oracle 10g'.

Page 178/579 | < Previous Page | 174 175 176 177 178 179 180 181 182 183 184 185  | Next Page >

• E-Business Suite at Oracle OpenWorld 2008

  For E-Business Suite customers: Get a preview of the must see sessions, demos, customer presentations and other highlights of of OpenWorld 2008, September 21st - 25th in San Francisco. Register at: http://www.oracle.com/openworld/2008/index.html

  Read the article

• PeopleSoft at Oracle OpenWorld 2008

  For PeopleSoft customers: Get a preview of the must see sessions, demos, customer presentations and other highlights of of OpenWorld 2008, September 21st - 25th in San Francisco. Register at: http://www.oracle.com/openworld/2008/index.html

  Read the article

• Oracle Database 12c ?????????????????? (8/1 ????)

  - by OTN-J Master

  Oracle Database 12c???????????????????????????????7?17????????????????????????????????????????????????????????????: ”????”????????????????Oracle Database 12c? ??: ·?????????????? Oracle Database 12c ·???????????????? ·??????????????? ·?????????????????? ·?????????·????????????? ·Oracle Database 12c ??????? ??????????????????????????????????????(??????????????????)?Oracle Database 12c???????????????????????????¦ @IT (ITmedia) ????????????????????5????????!Oracle Database 12c????? ¦ ZDNet Japan ?????????????? ¦?????? ????+IT??????????????????????????????????????????????????????????????????“???????”??????

  Read the article

• ?????????????Fusion Middleware??????????? ?2?

  - by rika.tokumichi

  ??????????OTN????????? ??OTN???????Fusion Middleware???????????????????????????????????????????????? ?OTN????????????????????????????? 2010?1????????????????? ???????????? ??????????????????? ???! ???????????????? ?????????????????????? ?????????????!! ????????????????????????? ???????????????????????????????????????? ??????????????Oracle Direct Seminar(??:????)? Oracle Direct Seminar???Oracle Direct?????IT?????????????????????????????????????·???·???????????????????????????????????????????????????????????????????????????????????? >????3???????? ????????????????????????? ?????????????????????????????^^ ???????????????????????????PDF????????????? ??????????????????????????????! >OTN???? ??????????? ??????????????????????··· ?????????????????????? ???????????/????????????????????????????????????????????????????? >?????????(???/?????) ??Middleware??????????Twitter????????????????????????? oraclemiddle_jp ??????????! ??????????????????????????? ···????????? ???????????????????????OTN??????????????????????????? ?????????????????? >OTN Japan ????&????????????? >???ONT Japan?????????????????????????? ???? ????????????????????????????? ?????????!! (?) >?INFORMATION INDEPTH NEWSLETTERS Fusion Middleware Edition?????? ?????Database?Application????????????1?????????Oracle's Dev2DBA Newsletter??????????????????????????! >?Oracle's Dev2DBA Newsletter?????? ???????????????????! ?????????????????????????????????? ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????!???????????????????????????????! ???????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????????????US????????????????????????????????????????????????????????????????????????????? ?????????????????????Fusion Middleware??????????? ?2??????????? ??????????????????????! Fusion Middleware???????????! ?INFORMATION INDEPTH NEWSLETTERS Fusion Middleware Edition???????! ??1?OTN???????Fusion Middleware???????????????? ???????????????????????????????????????????????? ???????????????????????!! ?????????? Oracle/OTN????????????????????????????????????????????????? ????????????????????????????????????? INFORMATION INDEPTH NEWSLETTERS Fusion Middleware Edition??????????????????????? ??????????????????????Oracle's Dev2DBA Newsletter?????????????^^

  Read the article

• ?????????????? Oracle JDK 7u10 ?????

  - by ksky

  ??: https://blogs.oracle.com/henrik/entry/oracle_jdk_7u10_released_with ????JRE?JDK 7?update 10??????????????????????????????????????????????: x86-64??Windows 8 ?:???UI(Metro)????????? Windows 8?Internet Explorer 10 Mac OS X 10.8 (Mountain Lion) ???????????Java??????webstart????????????????????????????????: Java????????????????????????????????????????????????Java???????????????????????????????????????? Java?????????????????????????????????????????????????????????????????????????????????Java????????????????????????????????????????????? Java???????????????????????(? - ? - ? - ????)??Java??????webstart????????????????????????????????????Java???????????????????????????????????????????????????????? ??????????????????????????????????????????????? ???JRE?JDK????????OTN???????????????????????????????????????????? 

  Read the article

• ????:?? - Gartner Japan??????????|Oracle Coherence|??????

  - by ???02

  Gartner Japan???????????????:???????DCP??????????????????????????????????? ???????????????????DB??????????????????????????????????????????????????????????????????????????????DB????????????????????????DB??????????????????????????????????????????????????????????????????????????????????????·?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????¦????????????????¦????????????¦????????????¦??????????????????????????????? ?????????????????????????Gartner Japan???????????????:???????DCP??????????????????????????????????????????Gartner Japan??????????????(DCP:???????·????????)? ????????????????????????????????????????????????????IT???????????????????????????????????????????????????????????????????:??????(????) - ???????????????????????????????????????????????????????????????????Oracle Coherence??????????????????????????????????????????????????? 

  Read the article

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

  - by ???02

  ?????·???·??????????????????·???·???????????????????????????????????????????Oracle Coherence???????????????????????????????????????????????????????2???????put/get??????????·??????????????? RDBMS?????????·???????????????????????????????·???·???????????????????????????????????????(???3????????????????????????????????)????Coherence???????3????????????????????????????????????????????????????????????????????????3:???????// ????????100????????????Filter filter = new EqualsFilter("getProductId", 100);// ????????????Set orders = orderCache.entrySet(filter); ????·??????????????·???????????????????????????????????????????????????????????????????????????????????Java??????????Java?????·??????????????????????????????????(???4)???????????????????(???5)??????Coherence???????·??????????????MapEvent????????????????????????????????????????????????????4:???·???????// ????????????????????·???public class ProcessOrderListener implements MapListener {public void entryInserted(MapEvent event) { /* ????? */ }public void entryUpdated(MapEvent event) {}public void entryDeleted(MapEvent event) {}}???5:????????orderCache.addMapListener(new ProcessOrderListener()); ????????????????????????????????(????)????????????????????????????????????????????100??????????0.1???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????·????????????????????????????????????????????????????????????????????Coherence????????????????????????????(???????)???????????·??????????Invocation?????????????(?4)?????????????????????????????????????????????????????????????????????????·?????????????????????????????????????????????????????????·????????????????????????????????????????????????????????????Coherence??????????????????????????????????????????????????????????????????????????????????????????????????????????·???·???????????·?????????????·????????????????123

  Read the article

• ?11.2RAC??????????????

  - by JaneZhang(???)

         ?????,???????????????,???dbca???????,???????????dbca,?????????11.2???????,???????,??dbca??????????????????,????????????????     ????11.2???????RACDB2???,?????RACDB1? ?????rac1,????rac2?     ?11.2?,?????grid?????GI,??oracle????????,????????oracle?????? 1. ??????????????????,?????,???????????:audit_file_dest, background_dump_dest, user_dump_dest ?core_dump_dest????audit_file_dest=/u01/app/oracle/admin/RACDB/adump,?????????,?????????:ORA-09925: Unable to create audit trail fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 99252. ????????????????????????????:SQL> alter system set instance_number=2 scope=spfile sid='RACDB2';SQL> alter system set thread=2 scope=spfile sid='RACDB2';SQL> alter system set undo_tablespace='UNDOTBS2' scope=spfile sid='RACDB2';SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.0.2.122)(PORT=1521))))' sid='RACDB2'; <=====192.0.2.122???2?VIP 3. ???????DB?$ORACLE_HOME/dbs/init<sid>.ora ?????DB?$ORACLE_HOME/dbs/init<sid>.ora,??????????????init<sid>.ora ????,????spfile???:=======================SPFILE='+DATA/racdb/spfileracdb.ora'??:[oracle@rac1 ~]$ scp $ORACLE_HOME/dbs/initRACDB1.ora rac2:$ORACLE_HOME/dbs/initRACDB2.ora <===????????24.  ??????/etc/oratab,????????????:RACDB2:/u01/app/oracle/product/11.2.0/dbhome_1:N       5.  ???????????: DB?$ORACLE_HOME/dbs/ora<sid>.pwd ????DB?$ORACLE_HOME/dbs/ora<sid>.pwd,??????????????:[oracle@rac1 dbs]$ scp $ORACLE_HOME/dbs/orapwRACDB1 rac2:$ORACLE_HOME/dbs/orapwRACDB2 <==?????26.  ?????????????,????????UNDO TABLESPACE?(??????dbca?????,???????undo tablespace????,?????????)??:SQL>CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE '/dev/….' SIZE 4096M ;???????:SQL>CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE '+DATA' SIZE 4096M ;7.  ?????????????,????????redo thread?redo log:??:SQL> alter database add logfile thread 2      group 3 ('/dev/...', '/dev/...') size 1024M,     group 4 ('/dev/...','dev/...') size 1024M;???????:SQL> alter database add logfile thread 2     group 3 ('+DATA','+RECO') size 1024M,     group 4 ('+DATA','+RECO') size 1024M;SQL> alter database enable thread 2; <==????thread8.  ??????????,?????????????:[oracle@rac2 admin]$su - oracle[oracle@rac2 admin]$export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1[oracle@rac2 admin]$export ORACLE_SID=RACDB2[oracle@rac2 admin]$ sqlplus / as sysdbaSQL> startup <==??????,???????2????????????9. ?????OCR???GI??,?????????????:$srvctl add instance -d <database name> -i <new instance name> -n <new node name>Example of srvctl add instance command:============================[oracle@rac2 ~]$ srvctl add instance -d racdb -i RACDB2 -n rac2  <==????????,????ps -ef|grep smon???[oracle@rac2 dbs]$ ps -ef|grep smonroot      3453     1  1 Jun12 ?        04:03:05 /u01/app/11.2.0/grid/bin/osysmond.bingrid      3727     1  0 Jun12 ?        00:00:19 asm_smon_+ASM2oracle    5343  4543  0 14:06 pts/1    00:00:00 grep smonoracle   28736     1  0 Jun25 ?        00:00:03 ora_smon_RACDB2 <========??????10. ???????:$su - grid[grid@rac2 ~]$ crsctl stat res -t...ora.racdb.db      1        ONLINE  ONLINE       rac1                     Open                      2        OFFLINE OFFLINE             rac2????,??????offline,????????????sqlplus??????sqlplus??????,???srvctl??:[grid@rac2 ~]$ su  - oraclePassword: [oracle@rac2 ~]$ sqlplus / as sysdbaSQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> exit[oracle@rac2 ~]$ srvctl start instance -d racdb -i RACDB2[oracle@rac2 ~]$ su - gridPassword: [grid@rac2 ~]$ crsctl stat res -tora.racdb.db      1        ONLINE  ONLINE       rac1                     Open                      2        ONLINE  ONLINE       rac2                     Open                11. ?????????:[oracle@rac2 ~]$ crsctl stat res ora.racdb.db -pNAME=ora.racdb.dbTYPE=ora.database.typeACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--ACTION_FAILURE_TEMPLATE=ACTION_SCRIPT=ACTIVE_PLACEMENT=1AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%AUTO_START=restoreCARDINALITY=2CHECK_INTERVAL=1CHECK_TIMEOUT=30CLUSTER_DATABASE=trueDATABASE_TYPE=RACDB_UNIQUE_NAME=RACDBDEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)DEGREE=1DESCRIPTION=Oracle Database resourceENABLED=1FAILOVER_DELAY=0FAILURE_INTERVAL=60FAILURE_THRESHOLD=1GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/RACDB/adumpGEN_START_OPTIONS=GEN_START_OPTIONS@SERVERNAME(rac1)=openGEN_START_OPTIONS@SERVERNAME(rac2)=openGEN_USR_ORA_INST_NAME=GEN_USR_ORA_INST_NAME@SERVERNAME(rac1)=RACDB1HOSTING_MEMBERS=INSTANCE_FAILOVER=0LOAD=1LOGGING_LEVEL=1MANAGEMENT_POLICY=AUTOMATICNLS_LANG=NOT_RESTARTING_TEMPLATE=OFFLINE_CHECK_INTERVAL=0ONLINE_RELOCATION_TIMEOUT=0ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1ORACLE_HOME_OLD=PLACEMENT=restrictedPROFILE_CHANGE_TEMPLATE=RESTART_ATTEMPTS=2ROLE=PRIMARYSCRIPT_TIMEOUT=60SERVER_POOLS=ora.RACDBSPFILE=+DATA/RACDB/spfileRACDB.oraSTART_DEPENDENCIES=hard(ora.DATA.dg,ora.RECO.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.DATA.dg,ora.RECO.dg)START_TIMEOUT=600STATE_CHANGE_TEMPLATE=STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.RECO.dg)STOP_TIMEOUT=600TYPE_VERSION=3.2UPTIME_THRESHOLD=1hUSR_ORA_DB_NAME=RACDBUSR_ORA_DOMAIN=USR_ORA_ENV=USR_ORA_FLAGS=USR_ORA_INST_NAME=USR_ORA_INST_NAME@SERVERNAME(rac1)=RACDB1USR_ORA_INST_NAME@SERVERNAME(rac2)=RACDB2USR_ORA_OPEN_MODE=openUSR_ORA_OPI=falseUSR_ORA_STOP_MODE=immediateVERSION=11.2.0.3.0???11.2,?OCR???database??,??????,???????????database???????database???????,??????,???????????????ASM????????????  ?:dbca ???????????:????????oracle????dbca:su - oracledbca?? RAC database?? Instance Management?? add an instance???active rac database??????? ??undo?redo??

  Read the article

• Oracle SQL Developer - How to export table with BLOB column?

  - by Taylor Leese

  I need to export a table using Oracle SQL Developer that includes a BLOB column. Is this possible? CSV and XML won't work because it has the BLOB column.

  Read the article

• ORACLE PL/Scope

  - by Yaakov Davis

  I didn't find much data about the internals of PL/Scope. I'd like to use it to analyze identifiers in PL/SQL scripts. Does it work only on Oracle 11g instances? Can I reference its dlls to use it on a machine with only ORACLE 9/10 installed? In a related manner, do I have to execute the script in order to its identifiers to be analyzed?

  Read the article

• How to prevent "parameter PLSQL_DEBUG is deprecated" compiler warning in Oracle SQL Developer

  - by Janek Bogucki

  When I execute a package body DDL statement SQL Developer warns, Warning: PLW-06015: parameter PLSQL_DEBUG is deprecated; use PLSQL_OPTIMIZE_LEVEL=1 How can SQL Developer be configured to not use PLSQL_DEBUG? PLSQL_DEBUG is set to false in an sql*plus session using the same connection details, > show parameters plsql NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ plsql_ccflags string plsql_code_type string INTERPRETED plsql_debug boolean FALSE plsql_native_library_dir string plsql_native_library_subdir_count integer 0 plsql_optimize_level integer 2 plsql_v2_compatibility boolean FALSE plsql_warnings string ENABLE:ALL Oracle SQL Developer v 2.1.1.64 Oracle 11g SE: 11.1.0.6.0

  Read the article

• Oracle SQL - Column with unix timestamp, need dd-mm-yyyy timestamp

  - by ArneRie

  Hi, is there any way in Oracle, to get only the dd-mm-yyyy part from an unix timestamp in oracle? Like: select to_char(my_timestamp, 'ddmmyyyy') as my_new_timestamp from table

  Read the article

• Getting results in a result set from dynamic SQL in Oracle

  - by msorens

  This question is similar to a couple others I have found on StackOverflow, but the differences are signficant enough to me to warrant a new question, so here it is: I want to obtain a result set from dynamic SQL in Oracle and then display it as a result set in a SqlDeveloper-like tool, just as if I had executed the dynamic SQL statement directly. This is straightforward in SQL Server, so to be concrete, here is an example from SQL Server that returns a result set in SQL Server Management Studio or Query Explorer: EXEC sp_executesql N'select * from countries' Or more properly: DECLARE @stmt nvarchar(100) SET @stmt = N'select * from countries' EXEC sp_executesql @stmt The question "How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?" addresses the first half of the problem--executing dynamic SQL into a cursor. The question "How to make Oracle procedure return result sets" provides a similar answer. Web search has revealed many variations of the same theme, all addressing just the first half of my question. I found this post explaining how to do it in SqlDeveloper, but that uses a bit of functionality of SqlDeveloper. I am actually using a custom query tool so I need the solution to be self-contained in the SQL code. This custom query tool similarly does not have the capability to show output of print (dbms_output.put_line) statements; it only displays result sets. Here is yet one more possible avenue using 'execute immediate...bulk collect', but this example again renders the results with a loop of dbms_output.put_line statements. This link attempts to address the topic but the question never quite got answered there either. Assuming this is possible, I will add one more condition: I would like to do this without having to define a function or procedure (due to limited DB permissions). That is, I would like to execute a self-contained PL/SQL block containing dynamic SQL and return a result set in SqlDeveloper or a similar tool. So to summarize: I want to execute an arbitrary SQL statement (hence dynamic SQL). The platform is Oracle. The solution must be a PL/SQL block with no procedures or functions. The output must be generated as a canonical result set; no print statements. The output must render as a result set in SqlDeveloper without using any SqlDeveloper special functionality. Any suggestions?

  Read the article

• PDO/Oracle vs OCI

  - by jarcoal

  The company I work for currently uses some basic functions to abstract the OCI libraries as a means for DB connectivity. We're considering switching to PHP's PDO object, but from some quick searches, it looks like the Oracle driver is a bit less mature than the other PDO drivers. I would appreciate some pro/cons for PDO/Oracle from anyone who has used it in a production environment. Thanks!

  Read the article

• Rails offen lost connection to oracle database

  - by qichunren

  I sometimes got this error from my log/production.log file: #<ActiveRecord::StatementInvalid: OCIError: ORA-03114: not connected to ORACLE: select decode(table_name,upper(table_name),lower(table_name),table_name) name from all_tables where owner = sys_context('userenv','session_user')>, How to solve this? How to rescue this and reconnect to oracle database?

  Read the article

• any similar software like oracle AIM ?

  - by austin powers

  hi, we want to implement a project documentation process for gathering our information and also decide an approach for further use. we know only oracle AIM which is suitable and well-craftted for this matter but the problem is the price of it. I want to know is there any similar application like oracle AIM available for doing project documentation process? regards.

  Read the article

• Oracle .dmp file

  - by Grasper

  I have an oracle .dmp file, and no access to an oracle install.. Is there any way I can read the data or open it in another program to see what data is in this file?

  Read the article

• When deinstalling Oracle falls PHP

  - by Adomas

  Hi, I have a web on php5, iis6, and Oracle on windows server 2003. I had Oracle 10.2.0.1.0 and deinstalled it. After that I installed earlier version (10.1.0) for cloning DB purposes, php doesn't work. As I understand it failes because of oci8.dll, but can't find the real problem. Please, help.

  Read the article

• Oracle ALTER DATABASE OPEN

  - by Tom

  Hi everyone, Im having some trouble with an oracle database. Every time i try to connect, i get this message. ORA-01033: ORACLE initialization or shutdown in progress I searched the web, and found that the solution is to execute an alter database open command, but what I dont understand is where should i execute if, since I cant connect to the database. Am I missing something? Thanks in advance

  Read the article

• copy values starting with alphabets only from one oracle table to another

  - by coder247

  I like to compare two tables in oracle and copy the values from table_a to table_b with the following conditions. Which doesn't exist in table_b but in table_a. And only the values starting with an alphabet or not starting with a number. And only the records modified today. I'm not an oracle expert so please be gentle. :) Thanks....

  Read the article

• Oracle Database introduction and literature

  - by Marco Nätlitz

  Hi folks, got an new assignment covering Oracle databases. My problem now is that I am completely new to the Oracle system and never worked with it before. I need to develop a concept covering the installation and configuration of the server. Afterwards I need to migrate the old server to the new while ensuring date consistence. I just wanted to ask if you guys have some useful links for introduction and of course good literature / books on this topic? Thanks and cheers from Cologne Marco

  Read the article

• How can I change the SID of an Oracle XE instance.

  - by Osama ALASSIRY

  I needed to change the SID of an Oracle XE database (not the Service Name) to match a production database. When I tried searching online, most of the pages were describing changing or adding a service name through tnsnames.ora; that's not what I needed to do.

  Read the article

• Sequential (comb) GUIDs for Oracle

  - by Eyvind

  We are in the process of switching from the C# Guid.NewGuid() random-ish guid generator to the sequential guid algorithm suggested in this post. While this seems to work well for MS SQL Server, I am unsure about the implications for Oracle databases, in which we store guids in a raw(16) field. Does anyone have any insight as to whether this algorithm would be good for creating sequential guids for Oracle as well as for MS SQL Server, or if a different variant should be used. Thanks!

  Read the article

• When deinstalling Oracle fals PHP

  - by Adomas

  Hi, I have a web on php5, iis6, and Oracle on windows server 2003. I had Oracle 10.2.0.1.0 and deinstalled it. After that I installed earlier version (10.1.0) for cloning DB purposes, php doesn't work. As I understand it failes because of oci8.dll, but can't find the real problem. Please, help.

  Read the article

• Is there an equivalent to sp_getapplock, sp_releaseapplock in oracle

  - by Noam

  I need the ability to use custom locks at a session level (outside the scope of a transaction) in oracle. In MSSQL I am using sp_getapplock, sp_releaseapplock. How can I achieve the same functionality in Oracle?

  Read the article

< Previous Page | 174 175 176 177 178 179 180 181 182 183 184 185  | Next Page >