Hot answers tagged

3

As andba77 suggested, it sounds like a problem with remote password file. First you need to determine if you have a password file. It should be on the database server at $ORACLE_HOME/dbs/orapw. Second is the setting of the init parm 'remote_login_passwordfile'. If it is set to 'none', no remote logins as sysdba will be allowed. You can read more about ...


3

You won't find 'remote_login_passwordfile' file under $ORACLE_HOME/dbs. It is not a file, it is an initialization parameter. That's why I posted a link to the documentation. What's under $ORCLE_HOME/dbs is the passwordfile itself, not the initialization parm that specifies how the password file is used. Now that I see the screen shots, I see you have no ...


3

Try: GROUP BY cast(StartTime as DATE) ORDER BY cast(StartTime as DATE); Grouping by the raw, unconverted value means you are guaranteed to have a row for every unique StartTime. (And it probably makes sense to sort that way, otherwise your rows could come back in an arbitrary and unintuitive order.)


2

Issue was resolved.. Actually improper build of sql server caused for issue. Check the registry key level for mssql server for what the default data, backup path existing in the host.. Go for same path in the explorer and check whether the database files existing in the same folder.. if not then msagent certificate will be not created in that path. Eg. ...


2

To make this happen, you need to give the computer domain account on which you have SQL Server installed rights to write to the share [Folder] on [ComputerName]. Say you have a computer SRV-SQLSERVER, and SQL services you run with NT Service*, but in some situation you can't create a domain account for them. But you need to store backups on other domain ...


1

on Windows system you have to use oradim.exe to admnister the Oracle instance behavior. This is the documentation: Using ORADIM to Administer an Oracle Database Instance You have to check: if the Windows service exists (if not create it with oradim); how it is configured (using oradim)


1

Follow the below steps to get it done: Open the registry with regedit. Always back up the registry before making changes. Navigate to the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\oracle_home_name. There will be a key called: ORA_SID_AUTOSTART. SID is your database SID. This key should be set to TRUE. If not the server starts but does not start the ...


1

To expand on Aaron's comment of: A LUN on a SAN is usually made up of a number of drives. Your data will be striped across all of them in some configuration, e.g. RAID 5 or RAID 10. You'll have to ask your SAN administrator for more details; we can't possibly tell you about your physical implementation. Each SAN implements this differently. For ...


1

I've eventually figured it out, after gaining a few grey hairs. I had to give the new user the FILE privilege because my dll was using LOAD DATA INFILE which requires it to work. Here is the info on the FILE privilege.


1

Physical Database Limits Logical Database Limits The maximum number of users (schemas): 2^31 = 2147483648 The official answer to your other questions: unlimited. The practical answer is: as many as your hardware/operating system/design can handle.



Only top voted, non community-wiki answers of a minimum length are eligible