Server Administration :: White Paper Or Asset On Oracle
Nov 20, 2011share documents and details to create asset on any topic on Oracle 10g. Also I need to write white paper on Oracle 10g .
View 1 Replies
ADVERTISEMENT
SQL & PL/SQL :: Remove White Space From Oracle Database
Jun 29, 2011I want to remove white space from oracle database, and i don't want to use trim() or replace(). can i use jdbc driver? if yes, then how?
View 9 Replies View RelatedForms :: Invalid Asset - Press F9 To See List Of Values?
Dec 6, 2010invalid asset . . . press f9 to see list of values
The above message appears on the item when I call lov.
PL/SQL :: How To Insert White Space Into Table
Jul 20, 2012I need insert white space into table which a VARCHAR2 column. I would like to validate the below expression against the data in the column S.*
I guess this pattern validates for non-whitespace characters. explain what this pattern does?
Remove White Space While Loading Data?
Aug 11, 2010i loaded the data from csv file. and i used FIELDS TERMINATED BY x'09' values.but the end of the value having white space within it..
ZIP_CODE
"33004[] like box
"33004[]"
"33004[]"
"33004[]"
"33004[]"
how can i remove the white space when i load the data.
JDeveloper, Java & XML :: Removing White Spaces From Arraylist
Mar 30, 2012I'm trying to remove whitespaces from user input of an ArrayList.
.trim() method for String, but what's the method for ArrayList?
Reports & Discoverer :: How To Set Paper Margin In 6i
Nov 5, 2010How to set papaer margin in reports 6i for example i use continue paper sheets on my printer i set paper margin 4 x 4 paper width 4 & papaer length 4 i want that after running report paper only eject as paper size 4 x 4 not whole paper.
View 1 Replies View RelatedForms :: Report Call Paper Or Web Layout
Jan 14, 2010Can we apply both below methods to call paper layout or web layout
1. WEB.SHOW_DOCUMENT()
2. RUN_REPORT_OBJECT()
Or else web layout reports call only from one of them?
Reports & Discoverer :: Page And Paper Size In 6i
Jan 15, 2003I have a dot matrix printer (Epson LQ-2180, which is a tractor feed printer). While printing a report which contains cheque information. Now while displaying the report it display in correct size but while I print the report by default it takes printer page size and print in that paper size. I want to print the report in cheque size with continuous sheet with more than 900 cheque which defined in report property.
I want that the printer should print exact page length and width what i defined in report.
Reports & Discoverer :: Logo Not Showing In 10g - Paper Layout?
Apr 6, 2013I have Report in RB 10g , it is showing the logo in PRINT View but when I am running the report in the paper layout it does not showing the logo over there
View 1 Replies View RelatedPL/SQL :: Joining Order Table With Asset Or CX_ACTION Table?
Apr 18, 2013joining the Order table with the Asset table or the Order table with CX_ACTION table to Can i get reference on this .
select x.x_msisdn,
x.x_product_name,
x.x_action,
x.x_status_outcome,
a.recovered_dt,
x.x_amount,
[code].....
Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server
Apr 8, 2010My manager is asking to create a SQL scrip, which will provide following information.
Our database is 9.2.0.7.0 on Windows 2000 Server
-How many records Insert / Update or Delete daily in my Oracle database?
- Check Archive log / Redo Log switching information?
-Check database growth ?
Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?
Jan 11, 2011i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."
Server Administration :: Restoring The Oracle Services In Windows 2008 Server
Jun 27, 2012I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).
All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.
Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client
Feb 13, 2013I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
Server Administration :: While Creating Index ORA-00603 / ORACLE Server Session Terminated By Fatal Error
Jul 26, 2010While creating the index we are getting the error "ORA-00603: ORACLE server session terminated by fatal error".
We have the space in tablespaces and also in the file systesm.
Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server
Apr 19, 2011I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.
View 3 Replies View RelatedServer Administration :: How To Connect Oracle Client To Remote Server DB
Jun 29, 2013I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.
On the server machine I configured oracle server in the following way:
Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:
Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521
All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.
With SQL Plus as by the official documentation I have entered the following command:
CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.
With SQL Developer I have entered the same parameter.
But with both SQLPlus and SQL Developer the connection fails.
Server Administration :: Connect 500+ Client To Remote Oracle Server?
Aug 10, 2010we have oracle server. we have to connect 500+ client machine to oracle server.
is it i need to install client version to all 500+ or any other shortcut way?
Server Administration :: Find Or Set New Oracle Instance Name On Backup Server
Sep 22, 2010We performed image copy of production Oracle server (OS and instances) to a backup server. After a few weeks, we try to restore a latest Oracle database backup from production server to backup server. As we know, Oracle instance must be unique on the network.
Even we log on to backup server and bring up the instance, I think that still point to production instance since all init file, TNSNAMES.ora and listener file are still same. If we restore the database, we will end up bring down the production instance and restore on top of productions. How to change instance name on backup server including TNSNAMES, sqlnet, listener files in order for us to restore Oracle database from production to backup server?
Server Administration :: Oracle 10g - Database Server Startup / Shutdown
Jun 29, 2011I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.
View 5 Replies View RelatedServer Administration :: Oracle Database Server - Logon Denied
Jul 19, 2011I am connected as System. It was the only user I set-up a password when installed the database on personal computer.
SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
[code]...
SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied
Server Administration :: Oracle DB Server Migration Checklist
Apr 11, 2012We will be having a meeting with our client regarding their Database Server Migration (They are planning to buy a new server). Their current database is Oracle 10gR2, they will not upgrade to 11g, they just plan to migrate to a new more powerful machine.
I was planning to ask the following questions.
1. Specifications of the current server and the new one.
2. Operation system (I think they will use same OS, just an updated one)
3. Can the business afford full downtime on current servers?
4. Size of the DB, because it can take hours to move large files.
And is there documentation regarding Server Migration (Change of machine only, not database upgrade or anything,
Server Administration :: Oracle 10G Client Works With 11G Server?
Jul 17, 2013Does a 10g oracle client works with an Oracle 11g server?
View 1 Replies View RelatedServer Administration :: How To Install Oracle 8i And 9i Databases On Same Server
Feb 20, 2011How to install oracle 8i and 9i databases on same server for example i want that both type of databases run on same server.
View 7 Replies View RelatedServer Administration :: Oracle 10g Server Went In Hanging Condition?
May 18, 2012Sometimes our db server goes in hanging condition. It does not save any transaction & user waits for long. When I restart, it starts working fine.What should I do, I mean regarding diagnosis & performance tuning.
View 1 Replies View RelatedServer Administration :: Updating Jdk 6 On Oracle Application Server 10.1.3 On EBS 12.0.4?
Mar 2, 2011In Process of upgrading Oracle EBS 12.0.4 to 12.1.1 I updated the $IAS_ORACLE_HOME/appsutil/jdk to jdk 6u24. After replacing the original jdk with jdk 6u24 when I attempted to start the apps adoacorectl.sh failed with below error.
Quote:ld.so.1: /d4/app/oracle/apps/12.0.0/vdd700/web/10.1.3/appsutil/jdk/bin/java: fatal: libjli.so: open failed: No such file or d
irectory
I followed below steps to update the jdk
1. extracted the jdk-6u24-solaris-sparcv9.tar.Z to $IAS_ORACLE_HOME/appsutil/jdk
2. Copied lib from old jdk to $IAS_ORACLE_HOME/appsutil/jdk
3. Copied lib from oldjdk/jre to $IAS_ORACLE_HOME/appsutil/jdk/jre
4. The java was not infact in jdk/bin rather it was /bin/sparcv9 so I copied them to /jdk/bin. The same way copied the executables from /jdk/jre/bin/sparcv9 to /jdk/jre/bin .
Server Administration :: From Where To Download Oracle 9i Database Server
Aug 17, 2010I have some requirement wherein I need to install Oracle 9i database server (9.2.0.7). I am not getting it on Oracle website. where can I get the download.
View 1 Replies View RelatedServer Administration :: Oracle 10g - First Put Server Into Actual Use - Not Working?
Aug 12, 2010We are using oracle 10g in linux machine which runs as server. And there are around 25 clients which run at the same time parallel to each other. I am new to oracle 10g and also for client-server version of database. I faced some problems when i first put the server into actual use.
-> Users have been created and tablespace is USERS and temporary space is TEMP. RESOURCE privilege is given.
-> Some times login fails for some clients.
-> Some times all the client login will be successful.
-> Query execution will be sometimes fast, but some times it takes too much time.
-> Some times the connection will be lost and again I have bring UP the server.
to maintain the oracle server.
-> Should I have to make any configuration settings in the server.
-> Should I change any values in the server.
-> Is there any way to properly maintain the server.
Reports & Discoverer :: Avoid Object / Record Moving On Report Paper Layout?
Oct 11, 2010I created a report ...whcih i complied and run on paper layout form.. it shown me on correct dta..but i change change layout size and postion on that viewer..
is it avoidable....if yes, then how ?? I wantto lock these object while previewing...