New answers tagged

0

Answer left in a comment by Phil: You can't create Oracle data files on SMB mounts, I'm afraid. Best way of doing it would be to add a new virtual disk to the Oracle VM, with the virtual disk files (vmdk, or whatever) on the other HDD.


2

Our monitoring keeps telling us the password of sys has expired. The "Default“ profile has a standard limit of 180 days. You should not try to change the Profile for internal, Oracle accounts (indeed, there is one, very oddly named, account that you cannot changed in any way, shape or form!). You should not change the behaviour of the DEFAULT profile. ...


0

Try this one: ALTER SESSION SET NLS_CALENDAR = 'Persian'; SELECT TO_DATE(THETIME || THEH, 'YYYYMMDDHH24MI') FROM dual;


0

Solution maybe to change the PASSWORD_LIFE_TIME of DEFAULT profile. Oracle docs: PASSWORD_LIFE_TIME Of DEFAULT Profile Changed From Unlimited To 180 (Doc ID 2437775.1). However it is a wanted behavior all passwords in Default Profile expire after 180 days.


-1

You need more free blocks in your temp tablespace, you should manually extend your temp file(s) size in order to complete your operation.


0

ORA-01652: unable to extend temp segment by XXX This isn't about your 120GB bigfile data tablespace at all. Your TEMP tablespace isn't big enough to handle whatever sorts or temporary result sets are created by the queries that are being run in your database. If it can't autoextend, then it is probably because you have filled up the disk drive and you don't ...


0

ORA-29701: unable to connect to Cluster Synchronization Service You need to make sure the the Grid Infrastructure services are started first. They provide all of the networking and ASM storage for the cluster, and you can't start a database instance without them. On Linux, as root, run crsctl start crs The command crsctl stat res -t should show you the ...


Top 50 recent answers are included