Oracle 9i to 10g conversion
Hi, Currently, I am using Oracle 9i (version 9.0.1.1) database now as per my business requirement, I need to upgrade it to Oracle 10g database. Operating System : Windows 2003 Server, 64 Bit I am looking for some help on this, what are the problems being faced at migration time, and finally how to migrate [...]
View Answer
| June 4, 2008 11:47 AM
Oracle 10g, Oracle 9i, Oracle developers
Hi, Currently, I am using Oracle 9i (version 9.0.1.1) database now as per my business requirement, I need to upgrade it to Oracle 10g database. Operating System : Windows 2003 Server, 64 Bit I am looking for some help on this, what are the problems being faced at migration time, and finally how to migrate [...]
View Answer
| June 4, 2008 11:47 AM
Oracle 10g, Oracle 9i, Oracle developers
Oracle 10g Clone Database
Well, basically you have to reproduce in the new server the same layout you have in the original one. I mean paths for datafiles, redo log files, dump files, parameter and password files and so on. This is not mandatory, but it greatly simplifies the operations. So, the first thing you need to do is [...]
View Answer
| June 4, 2008 9:18 AM
Clone database, Hot Backup, Oracle, Oracle 10g
Well, basically you have to reproduce in the new server the same layout you have in the original one. I mean paths for datafiles, redo log files, dump files, parameter and password files and so on. This is not mandatory, but it greatly simplifies the operations. So, the first thing you need to do is [...]
View Answer
| June 4, 2008 9:18 AM
Clone database, Hot Backup, Oracle, Oracle 10g
Data Modeling Tools for relational database & dimensional data mart
You don’t need any specific tool to do a data mart compared to an OLTP database. Toad will work just fine. Many people including myself prefer to use Visio to do this. This gives you a second option.
View Answer
| May 31, 2008 9:41 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler
You don’t need any specific tool to do a data mart compared to an OLTP database. Toad will work just fine. Many people including myself prefer to use Visio to do this. This gives you a second option.
View Answer
| May 31, 2008 9:41 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler
Moving Oracle from one windows domain to another
do the following. backup ur alert.log file and then clear it. then run, sqlplus /nolog conn system/<system pwd> as sysdba shutdown abbort startup and then send me ur newly populated alert.log file. also check wether ur problem got fixed or not.
View Answer
| May 30, 2008 5:20 AM
Domain management, ORA-01034, ORA-27101, Oracle 9, Oracle administration, Oracle error messages, Windows Server 2003
do the following. backup ur alert.log file and then clear it. then run, sqlplus /nolog conn system/<system pwd> as sysdba shutdown abbort startup and then send me ur newly populated alert.log file. also check wether ur problem got fixed or not.
View Answer
| May 30, 2008 5:20 AM
Domain management, ORA-01034, ORA-27101, Oracle 9, Oracle administration, Oracle error messages, Windows Server 2003
how to install oracle 7 in XP
Hello, as you can read in <a href=”http://www.oracle.com/technology/tech/windows/faq.html”>this article</a> you cannot install it in WindowsXP, hereafter an excerpt of the article: <i> Note: For AMD64/EM64T platform information, refer to this certification matrix. Windows 2000 support indicates support for Professional, Server, Advanced Server, Datacenter editions. Windows XP support indicates support for Professional Edition (32-bit) and XP [...]
View Answer
| May 28, 2008 4:53 PM
Oracle 7, Windows XP
Hello, as you can read in <a href=”http://www.oracle.com/technology/tech/windows/faq.html”>this article</a> you cannot install it in WindowsXP, hereafter an excerpt of the article: <i> Note: For AMD64/EM64T platform information, refer to this certification matrix. Windows 2000 support indicates support for Professional, Server, Advanced Server, Datacenter editions. Windows XP support indicates support for Professional Edition (32-bit) and XP [...]
View Answer
| May 28, 2008 4:53 PM
Oracle 7, Windows XP
Oracle Enterprise edition licensing
You will want to check with Oracle to be sure, but the last I heard they change .75 CPUs per core. For for a single chip dual core machine they change the equivalent of 1.5 CPU licenses.
View Answer
| May 27, 2008 9:19 PM
Oracle Enterprise Edition, Oracle licensing
You will want to check with Oracle to be sure, but the last I heard they change .75 CPUs per core. For for a single chip dual core machine they change the equivalent of 1.5 CPU licenses.
View Answer
| May 27, 2008 9:19 PM
Oracle Enterprise Edition, Oracle licensing
Using Oracle 10g Stored proc in SSRS 2005
It sounds to me like maybe the input parameters are not being passed in correctly. You might want to output the values of the variables you are passing in to make sure that they are being processed correctly.
View Answer
| May 27, 2008 1:39 AM
Oracle 10g, Oracle stored procedures, SQL Server Reporting Services, SSRS 2005, Stored Procedures
It sounds to me like maybe the input parameters are not being passed in correctly. You might want to output the values of the variables you are passing in to make sure that they are being processed correctly.
View Answer
| May 27, 2008 1:39 AM
Oracle 10g, Oracle stored procedures, SQL Server Reporting Services, SSRS 2005, Stored Procedures
string functions in oracle
You can use the SUBSTR and INSTR functions to do this. <pre>SELECT SUBSTR(NameColumn, 1, INSTR(NameColumn, ‘ ‘, 1, 1)) FROM Table;</pre> (This is untested.)
View Answer
| May 26, 2008 7:36 PM
Oracle
You can use the SUBSTR and INSTR functions to do this. <pre>SELECT SUBSTR(NameColumn, 1, INSTR(NameColumn, ‘ ‘, 1, 1)) FROM Table;</pre> (This is untested.)
View Answer
| May 26, 2008 7:36 PM
Oracle
Need help reducing application downtime during updates
This will work but keeping the data synced between the two schemas will be difficult. It’s much easier to keep everything in a single schema. What’s the cause of the month end update statement taking so long? Are the tables indexed correctly? Are there indexes which can be removed? Are the disks queueing to much? [...]
View Answer
| May 23, 2008 5:42 PM
Database, Oracle
This will work but keeping the data synced between the two schemas will be difficult. It’s much easier to keep everything in a single schema. What’s the cause of the month end update statement taking so long? Are the tables indexed correctly? Are there indexes which can be removed? Are the disks queueing to much? [...]
View Answer
| May 23, 2008 5:42 PM
Database, Oracle
Oracle performance under NT versus Linux environments
It could be any number of things. Disk speed, CPU power, etc will probably be the biggest variables.
View Answer
| May 23, 2008 4:59 PM
Linux, Oracle, Oracle performance, Windows NT
It could be any number of things. Disk speed, CPU power, etc will probably be the biggest variables.
View Answer
| May 23, 2008 4:59 PM
Linux, Oracle, Oracle performance, Windows NT
Pl/sql code for queries
Use a for loop with an implicit cursor create or replace delete_procedure is begin For cost_rec in (first select statment) loop if cost_rec.active_date = cost_rec.bdate+5 then first delete statement; end if; end loop; For cost_rec in (second select) loop if (2nd delete criteria) then 2nd delete statement; end if; end loop; commit; end delete_procedure;
View Answer
| May 22, 2008 7:45 PM
Oracle developers, PL/SQL
Use a for loop with an implicit cursor create or replace delete_procedure is begin For cost_rec in (first select statment) loop if cost_rec.active_date = cost_rec.bdate+5 then first delete statement; end if; end loop; For cost_rec in (second select) loop if (2nd delete criteria) then 2nd delete statement; end if; end loop; commit; end delete_procedure;
View Answer
| May 22, 2008 7:45 PM
Oracle developers, PL/SQL
Two Applications sharing the same database
With about 99% of the applications out there, yes you can do this. You simply install the application on the second server and when configuring it set the database connection to be the remote database server name and username and password. Check with Oracle and make sure that the E-business suit supports being installed on [...]
View Answer
| May 22, 2008 4:05 PM
Database administration, Database security, Oracle, Oracle 9, Oracle E-Business Suite, Oracle security, Shared databases, Solaris, Solaris 10
With about 99% of the applications out there, yes you can do this. You simply install the application on the second server and when configuring it set the database connection to be the remote database server name and username and password. Check with Oracle and make sure that the E-business suit supports being installed on [...]
View Answer
| May 22, 2008 4:05 PM
Database administration, Database security, Oracle, Oracle 9, Oracle E-Business Suite, Oracle security, Shared databases, Solaris, Solaris 10
Oracle -fetched column value truncated error
Your before and after datatype and data width are both the same. What’s the initial and working datatype and data width?
View Answer
| May 22, 2008 4:02 PM
ASP.NET, C#, ORA-01406, Oracle, Oracle 9i, Oracle error messages
Your before and after datatype and data width are both the same. What’s the initial and working datatype and data width?
View Answer
| May 22, 2008 4:02 PM
ASP.NET, C#, ORA-01406, Oracle, Oracle 9i, Oracle error messages
Not able to set preferred credentials on OEM console
for setting preferred credentials, first on windows go to settings>control panel> administrative tools> local security policy>local policy> local right assignment and then select logon as batch job, and add ur windows user in that right group. then schedule ur job in EM control by providing the same windows user name as the prefered OS authentic [...]
View Answer
| May 21, 2008 3:59 AM
DBCA, Oracle 10g, Oracle 10g R2, Preferred credentials, Windows Server 2003
for setting preferred credentials, first on windows go to settings>control panel> administrative tools> local security policy>local policy> local right assignment and then select logon as batch job, and add ur windows user in that right group. then schedule ur job in EM control by providing the same windows user name as the prefered OS authentic [...]
View Answer
| May 21, 2008 3:59 AM
DBCA, Oracle 10g, Oracle 10g R2, Preferred credentials, Windows Server 2003
copy files
INSERT INTO FILENAME1 (SELECT * FROM FILENAME2) Thanx Reshma
View Answer
| May 19, 2008 12:14 PM
SQLPlus
INSERT INTO FILENAME1 (SELECT * FROM FILENAME2) Thanx Reshma
View Answer
| May 19, 2008 12:14 PM
SQLPlus
Database Move
I found the quickest way to refresh a database is to copy all files (datafiles, control files, redo log files) via the operating system (UNIX in my case) and then startup the copied database via Oracle. If you need more details, I can provide you with necessary script files. Sitansu S. Mittra Could you please [...]
View Answer
| May 19, 2008 9:48 AM
Oracle 8i
I found the quickest way to refresh a database is to copy all files (datafiles, control files, redo log files) via the operating system (UNIX in my case) and then startup the copied database via Oracle. If you need more details, I can provide you with necessary script files. Sitansu S. Mittra Could you please [...]
View Answer
| May 19, 2008 9:48 AM
Oracle 8i
Oracle 10g on Windows 2003 virtual server
Running any database in a Virtual machine (either VMware or Microsoft) will not perform well under load. Virtual Machines use virtual disks for storage which adds an additional layer of processing which has to happen before the data can be written. In addition your memory and CPU are not all your own, so this can [...]
View Answer
| May 17, 2008 12:31 AM
Database, Microsoft Virtual Server, Oracle 10g, SQL Server
Running any database in a Virtual machine (either VMware or Microsoft) will not perform well under load. Virtual Machines use virtual disks for storage which adds an additional layer of processing which has to happen before the data can be written. In addition your memory and CPU are not all your own, so this can [...]
View Answer
| May 17, 2008 12:31 AM
Database, Microsoft Virtual Server, Oracle 10g, SQL Server
SQLServer equivalent to dba_role_privs, dba_user_privs, dba_object_privs ???
The version of SQL Server that you are running will tell you which objects you need to look at. There were lots of changes between SQL 2000 and SQL 2005. In SQL 2000 you can use this SELECT statement <pre>select user_name(p.grantor) as GRANTOR ,user_name(p.uid) as GRANTEE ,db_name() as TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_NAME [...]
View Answer
| May 15, 2008 8:07 PM
Oracle, SQL Server
The version of SQL Server that you are running will tell you which objects you need to look at. There were lots of changes between SQL 2000 and SQL 2005. In SQL 2000 you can use this SELECT statement <pre>select user_name(p.grantor) as GRANTOR ,user_name(p.uid) as GRANTEE ,db_name() as TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_NAME [...]
View Answer
| May 15, 2008 8:07 PM
Oracle, SQL Server
Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!
Update 5/14 Looks like the race is heating up. <a href=”http://itknowledgeexchange.techtarget.com/profile/Labnuke99″>Labnuke99</a> has taken the lead over <a href=”http://itknowledgeexchange.techtarget.com/profile/Gilly400″>Gilly400</a> but there is a battle starting for 3rd place between <a href=”http://itknowledgeexchange.techtarget.com/profile/Vlvpk”>Vlvpk</a> <a href=”http://itknowledgeexchange.techtarget.com/profile/Ysrd”>Ysrd</a> <a href=”http://itknowledgeexchange.techtarget.com/profile/Bvining”>Bvining</a> Still allot of time left so it is anyones contest to win. UPDATE 5/9 The contest is heating up between Labnuke99 [...]
View Answer
| May 14, 2008 3:04 PM
AS/400, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP
Update 5/14 Looks like the race is heating up. <a href=”http://itknowledgeexchange.techtarget.com/profile/Labnuke99″>Labnuke99</a> has taken the lead over <a href=”http://itknowledgeexchange.techtarget.com/profile/Gilly400″>Gilly400</a> but there is a battle starting for 3rd place between <a href=”http://itknowledgeexchange.techtarget.com/profile/Vlvpk”>Vlvpk</a> <a href=”http://itknowledgeexchange.techtarget.com/profile/Ysrd”>Ysrd</a> <a href=”http://itknowledgeexchange.techtarget.com/profile/Bvining”>Bvining</a> Still allot of time left so it is anyones contest to win. UPDATE 5/9 The contest is heating up between Labnuke99 [...]
View Answer
| May 14, 2008 3:04 PM
AS/400, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP
Validation Error – Oracle database on Windows Server 2003
You need to connect to the database using an internal database user id. If you don’t have a Management Server setup, try launching OEM, Standalone, and try connecting as SYSTEM or SYS or another internal userid.
View Answer
| May 14, 2008 3:03 PM
Administrative privileges, Oracle, Windows Server 2003
You need to connect to the database using an internal database user id. If you don’t have a Management Server setup, try launching OEM, Standalone, and try connecting as SYSTEM or SYS or another internal userid.
View Answer
| May 14, 2008 3:03 PM
Administrative privileges, Oracle, Windows Server 2003
