It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago. We are using both Express edition and Commercial … Read more
It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 9 years ago. what’s the reason for Enterprise Manager is not … Read more
My DB is getting slow on particular weekdays like Saturday and Sunday. What will be the reason? Database is Oracle 11g R1. Operating system is Windows 2003 64 Bit Service pack 2. Answer This could be a million things .. traffic patterns (although usually there is more traffic during the week, but that depends on … Read more
When I run rman target / @mydb nocatalog cmdfile=%commands% msglog=%logfile%, I see connected to target database: OTHERDB (DBID=3786352837, not open). Answer Setting environment variable ORACLE_DB to the target database helps the cause. Set ORACLE_SID=mydb StackOverflow and ServerFault seem to suffer from lack of Oracle expertise. Weak. AttributionSource : Link , Question Author : publicRavi , … Read more
I have tried to download Oracle Client 11g both 32 & 64 packages to Windows 2008 R2 with SQL server 2008 Express. However, I still cannot see Oracle provider in SQL server by using sa log in. Not sure if is it possible to do it for SQL Server express 2008? Any advice to do … Read more
On my dev machine (Mint Linux), I have ODBC set up with credentials so that I only have to specify DRIVER and DBQ in the connection string. Unfortunately, the script will have to run on a Windows machine. How do I set it up in Windows so that I don’t have to pass in an … Read more
I’ve installed an Oracle 11g XE on a Linux ubuntu 14.04, successfully created a user, and imported a database into it. my problem is , if when I want create new connection for connect with DATABASE hr for example Bring me a message : Status : Failure -Test failed: IO Error: The Network Adapter could … Read more
I am restoring Oracle datafile size of 1200GB. Datafile is read from backup piece size of 4000GB(4TB). Note: As I monitored 4TB is processed totaly to read all blocks of my datafile. I had several problems during restore: Situation 1. There was period when after 2 hours restore was failing (Operation column in Netbackup Database … Read more
I am facing the below error while syncing table from Oracle to an Azure SQL data warehouse using SSMA tool (a tool used to migrate data from Oracle to Azure SQL). I am able to connect to the database and convert the schema from Oracle database but, am getting an error while syncing it with … Read more
I am running into a problem where I have created some ASM disks under linux, they show up when I run oracleasm listdisks, but they are invisible when I use dbca and try to Configure Automatic Storage Management. Answer Turned out to be a a missing rpm package. Next time I’ll be a little more … Read more
