Database

Last week, got this issue reported by a DBA that he wasn’t able to su to oracle user from root on a Oracle Base Database VM in OCI. The login of opc user worked fine and he could do sudo su to root but he couldn’t su to oracle. When he did it just came back to root shell. [root@xxx ~]# su - oracle Last login: Fri Jan 12 10:20:38 UTC 2023 [root@xxx ~]# There was nothing relevant in /var/log/messages or /var/log/secure. I tried it for some other user and it worked fine. Then I suspected something with the profile of oracle user and voila ! The .bashrc looked like this ...

A customer who is using an Exadata X8M-2 with multiple VMs had Smokescreen deployed in their company recently and they reported an issue that one of the Smokescreen decoy servers in their DC was seeing traffic from one of the Exadata VMs on a certain port. That was rather confusing as that port was the database listener port on that VM and why would a VM with Oracle RAC deployed try to access any random IP on the listener port. Also it was happening only for this VM. Nothing for so many other VMs. ...

So there is a new toy in the market for database geeks : Oracle has released database 12c. Every social platform is abuzz with the 12c activity. So thought that I should also complete the ritual In this post Aman has already summed up many important links. Maria Colgan has posted some useful links here. And here is a link to a slidedeck about Upgrading and Migrating to 12c. Happy 12c’ing !

author: Sidhu category: oracle-general guid: http://amardeepsidhu.com/blog/?p=79 tag: database title: A database - one tablespace & one datafile url: /blog/a-database-one-tablespace-one-datafile/ Today I was checking OTN forums and came across a thread. OP’s concern was: One of the db i am supporting has about 3.3 Terabytes capacity and the application is using only 1 huge tablespace with one big file. the system is linux 4 , 32 bit. oracle version is 10.2.0.4 Is there a limit of space for a tablespace when you consider insert/delete/query performance? ...

Today I was upgrading 10gR1 to 10gR2 (10.2.0.1) on Linux x86. The upgrade went almost fine (except that I had to install one package and change few kernel parameters) but while running DBUA to upgrade databases, it gave an error: [sourcecode language=‘css’]Could not get database version from the Oracle Server component. The CEP file rdbmsup.sql does not provide the version directive and Start of root element expected. Upgrade Configuration file ‘C:\Oracle10g2\cfgtoollogs\dbua\test\upgrade5\upgrade.xml’ is not a valid XML file.[/sourcecode] ...