Windows :: System Admin Log In Error
Feb 6, 2013
i want to log-in my local machine database as a system administrator , but it is giving an error:
C:Windowssystem32>sqlplus /@myprodb as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:18:15 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR: ORA-01031: insufficient privileges
Enter user-name:
C:Windowssystem32>sqlplus /@myprodb as sysoper
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:19:28 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR: ORA-01031: insufficient privileges
Enter user-name:
but
C:Windowssystem32>sqlplus sys@myprodb as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:20:45 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
and i have run cmd as administrator
View 20 Replies
ADVERTISEMENT
May 6, 2013
I created a script to make my admin server a windows service. I successfully made it a service but when it starts it then shuts itself down. i ran a debug and found a error. I dont get what to do. I have tried changing the variables in the script and try it over and over again .....here is my script code and here is the error i got from debug output:
script
SETLOCAL
set DOMAIN_NAME=FRClassicDomain
set USERDOMAIN_HOME=C:/Oracle/Middleware/user_projects/domains/FRClassicDomain
set SERVER_NAME=FRweblogic
[Code]....
View 1 Replies
View Related
Aug 13, 2012
I have installed oracle several times in the past. This time I installed 11gr2 first time. I created default database during install and provided an admin password. Only thing I forgot to do was did not unlock the accounts using Password management button.
When I tried to login as SYS the admin password works fine but as SYSTEM admin password does not work. Used to be able to login as SYS, SYTEM with same admin password.
Now in SQLPLUS I unlocked the account but still can not change the password.
View 4 Replies
View Related
Sep 5, 2012
I'm trying to connect to the Apex website using SYSTEM or SYS. What is the workspace for system?
I logged into SQL command line and created this user using this line then grant dba to it
CREATE USER USER_HP_FULL IDENTIFIED BY w ACCOUNT UNLOCK DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PROFILE "DEFAULT";
Now, I know the username and password but I don't know the workspace. I want to log into the oracle application express website.
View 2 Replies
View Related
Jul 5, 2011
Im trying to install Weblogic/Forms on a Windows 7 x86 machine. Its for the developers to use.But when I run the config.bat and is creating the domain and installing Forms builder and the other stuff the installation hangs at: step restaring admin server started.
Log:
Stopping Derby Server...
Starting AdminServer
Starting the domain ...
DEBUG : Loading the 32 bit dll here
DEBUG : Loading DLL : D:/oracle/middleware/as_1/install/config/StartUtil.dll
DEBUG : Loaded DLL : D:/oracle/middleware/as_1/install/config/StartUtil.dll
View 1 Replies
View Related
Jul 7, 2012
DB 10.2.0.4
After running shut abort it is giving below error while trying to connect sqlplus.
ORA-28547: connection to server failed, probable Oracle Net admin error
View 2 Replies
View Related
May 12, 2002
i have installed oracle 8i on my windows xp system. it has not given me any problems during installation. i could log on to oracle and work on it without any problems. but when i restarted my system, my system has failed to start the oracle service, and i could no longer logon to sql * plus.
I've got messages 'oracle not available'. i've even tried to start the service from administrative tools-services, but of no use. then i created a new database and log on to sql* plus. but when i rebooted my system, the problem continued.
View 33 Replies
View Related
Jul 27, 2011
I need information to recommend something to the Client:Existing Application Environment is:
OS: Windows XP Server as well as Client
Database: Oracle 9i Server on XP
Oracle Client : Oracle 9i
They want to move to Windows 7 in ClientWhat all they need to upgrade if required...?Does Oracle 9i Client can be installed on windows 7 clientDoes Oracle 10g Client is required in the above mentioned case.
View 1 Replies
View Related
May 31, 2013
I created an empty database using the DB Configuration Assistant, then imported a dump file provided by a client. I believe what happened is that all of the user passwords (for SYSTEM, SYSDBA, etc.) which I had created in the DB Config Assistant were overwritten during the import process as I can no longer log into the DB.
I have attempted logging into sqlplus using the /as sysdba swith while logged in to the server as a user in the ORA_DBA role, but I still get the ORA-01031: insufficient privileges message.
I am running Oracle 11g R2 on Windows 2008 R2.
View 4 Replies
View Related
Dec 7, 2010
I'm trying to install Oracle10g in win7 Home premium. It is installing but problem is when installation process trying to create database on the system, a message is appearing which telling that ORA-12546:TNS:permission denied.
View 1 Replies
View Related
Jun 14, 2012
install oracle clusterware on Windows Operating system
View 4 Replies
View Related
Jul 31, 2012
Windows 2003, DB 10.2.0.3...I have to read some files from remote folder, so on remote Windows machine I shared folder c:est (grant Everyone first, and Administrator then) and on DB Server I mapped the remote folder with letter T..All these operations were made with administrator privileges.
In Oracle I create a directory object with this command:
CREATE OR REPLACE directory T_DIR AS 'T:';
Then I granted read and write privileges to my user
GRANT READ, WRITE ON DIRECTORY T_DIR TO <user>; (I tried also to set PUBLIC and SYSTEM)
But when I try to open a file with UTL_FILE with this command
file_handler := UTL_FILE.fopen( 'T_DIR', 'Dati.ini', 'r' ) ;
the error is
Exception: ORA-29283: operazione file non valida
ORA-06512: a "SYS.UTL_FILE", line 475
ORA-29283: operazione file non valida
If I change my directory object in 'C: est' (local folder) it works correctly.I tried also restart DB while shared folders were connected but with the same result.I tried, from sqlplus, the command host (dir t:) and it works (folder is accessible)
Is it an Oracle bug? Is it a Windows bug?
View 5 Replies
View Related
Aug 2, 2010
I need to install oracle 10g release2 in 32bit windows server system.
I also need to replicate whole database at more than 10 locations...i m just confused which windows server system should i install the database?
View 2 Replies
View Related
Jun 14, 2011
I would like to develop a form which will be replica of windows explorer.It should be able to read all files or files from a specific folder from an unix platform.
if yes can i have a template. I do not want to start from the scratch since I do not have much time.
View 5 Replies
View Related
Jun 3, 2011
We need to connect to an Oracle database from an ASP web page and I downloaded and installed ODAC112021.zip to a Window 2003 server; can connect OK I sent the zip to co-worker in another state and he installed it on slightly older build of 2003 server and we get the following error
"The setup routines for the Oracle in OraClient11g_home1 ODBC driver could not be loaded due to system error code 14001"
Only saw one post on OTN discussion and msot mention another error (998) [URL]
View 1 Replies
View Related
Jul 22, 2011
when i am running this syntax in rman i got this error so can you suggust me a correct syntax
Quote:
RMAN> run{
2> allocate channel c1 device type disk maxpiecesize 5m;
3> set backup copies = 2;
4> backup datafile 1 format 'E:
ol\%u_%c','E:
ol\%u_%c';
5> }
allocated channel: c1
channel c1: sid=142 devtype=DISK
executing command: SET BACKUP COPIES
Starting backup at 22-JUL-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF
[code]...
View 7 Replies
View Related
Nov 13, 2012
We're using UTL_SMTP to send emails from Oracle, and about 2 weeks ago (2 days prior to daylight savings) we start seeing an intermittent "SMTP transient error: 452 4.3.1 Insufficient system resources".
When there's an issue, emails fail from all 3 of our database environments (on separate servers), which leads me to believe that it isn't Oracle's error. But, our Exchange server isn't showing anything in it's Application Event Log, nor it's Protocol Log (although we just changed settings to log more information).
I'm just trying to rule out Oracle at this point, so we can focus our efforts. I've been looking on Google for the past hour and a half, and I can't find anything which points to anything other than the mail server being the culprit in an error situation like this. But, how to determine if the database should stay on the list of items to look into.
View 5 Replies
View Related
Jan 2, 2011
i have installed oracle 10g on linux system. and i am using xp as a client when i use this
cmd>conn scott/tiger@database at client side i receive ora-12560 error
while my database is up and listener and tnsping also working at server side.
View 3 Replies
View Related
Oct 10, 2012
i have a large OLTP database and we are doing table stats copy amount subpartition to save the load on system. while doing an copy default subpartition stats: I see the following error:
SQL> exec DBMS_STATS.COPY_TABLE_STATS('cusms','STATUS_HIST','P_VDEF_10_2012_S100','P_VDEF13_10_2012_S100',force=>true);
BEGIN DBMS_STATS.COPY_TABLE_STATS('cusms','STATUS_HIST','P_VDEF_10_2012_S100','P_VDEF13_10_2012_S100',force=>true); END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
View 2 Replies
View Related
Apr 1, 2012
We have system.current_item and system.cursor_item.....
both represent the same....
like this we have few other system variables also .....
what is the main difference between current_item and cursor_item?
View 2 Replies
View Related
Aug 21, 2012
couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not
CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)
View 1 Replies
View Related
Apr 25, 2012
I am studying a way to block the access from the root(UNIX) or admin(WIN) users to the database.
Are there some way to block the access by the superusers?
View 3 Replies
View Related
Sep 16, 2013
Having an issue with logging into URL.... Just went through the install for APEX 4.2 for
Oracle 11.2.0.1 on Linux 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux.
Installed Apex with Embedded PL/SQL Gateway.Explicitly followed all the online instructions step-by-step, installation was success and config for EPG had no issues. Changed the ADMIN pw as instructed. Checked that EPG is running on port 8080. Ran this script to grant connect:
DECLARE ACL_PATH VARCHAR2(4000);BEGIN -- Look for the ACL currently assigned to '*' and give APEX_040200 -- the "connect" privilege if APEX_040200 does not have the privilege yet. SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;[code]....
that lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');END;/COMMIT;
When I go to log in it says "Invalid Login Credentials". I tried changing the admin pw several times but keep getting the same message.
View 1 Replies
View Related
Oct 18, 2010
I have installed oracle 11g and configured Apex application on it. I am able to open the Admin window from my machine . URL.... and everything works fine. But when I try to open the link from other machine I get "Server not found" error.
I read the posts it says to enable Http for other servers . I dont find the way to do it .
View 2 Replies
View Related
Jul 10, 2012
im getting an error message:SQL*Loader-503: Error appending extension to file (%%g) OSD-04503: Message 4503 not found; No message file for product=RDBMS, facility=SOSD
when i tried to create a bat file that should read and load all files in the folder specified. here's my
@echo off
for /r c:retinfile %%g in (*) Do (
echo Load Data>loaderhdr.ctl
echo INFILE '%%g'>>loaderhdr.ctl
echo append into table INTR_INS_BRET_HDR WHEN (1:1) = "H" >>loaderhdr.ctl
echo (TRANS_ID "intr_ins_bret_hdr_seq.nextval",PROCESS_DATE "to_date(SYSDATE)", REC_TYPE position(1:1^), VERSION_NO position(2:4^), FILE_NAME position(5:44^), FILE_DATE position(45:52^), FILE_NO position(53:54^), PROCESS_TYPE position(55:55^), MERCHANT_NO position(56:70^), FILE_FORMAT_ID position(71:74^), REC_TYPE2 position(75:76^), BATCH_NO position(77:85^), DATE_SENT position(86:91^), TOT_NO_TRANS position(92:95^), SIGN_TOT_BILL_AMT position(105:105^), TOT_BILL_AMT position(96:104^) "decode(:sign_tot_bill_amt, '+', :TOT_BILL_AMT/100, :TOT_BILL_AMT/100*-1)", ESTABLISH_NO position(106:116^), INS_CODE position(117:121^), INS_TYPE position(122:122^)) >> loaderhdr.ctl
call loaddatahdr.bat
)
[code]...
the program should create a CTL file based on the files inside c:retinfile, but its getting an error.
View 7 Replies
View Related
Aug 23, 2011
When i try to grant role to user , i get following error.
SQL>
SQL> GRANT MAINTAIN_TEO TO CEE_WIRELINE;
GRANT MAINTAIN_TEO TO CEE_WIRELINE
*
ERROR at line 1:
ORA-01932: ADMIN option not granted for role 'MAINTAIN_TEO'
SQL>
View 1 Replies
View Related
Jul 30, 2013
My configuration is GlassFish 4 (the same thing with Glass Fish 3.2) + win7 + Apex Listener 2.2 (the same thing with Apex Listener 2.1) + Apex 4.2.2 I get blank page when trying to connect to APEX. But after loggin into GlassFish admin page (exactly login with username+password; just open admin page is not enough) in another browser tab I get proper Apex page with all images.
View 1 Replies
View Related
Feb 7, 2013
We have 2 apex schemas
APEX_030000
APEX_040200
Before executing the apxchpwd.sql, found the "alter session command" sets schema to APEX_030000. So we changed that to APEX_040200. Then we executed the sql script. It executed fine.
But now when we try to login to apex, and pressing enter after providing the username/pwd, it raises the following exception
Error Error in PLSQL code raised during plug-in processing.
ORA-06508: PL/SQL: could not find program unit being called
View 1 Replies
View Related
Sep 4, 2012
My database is working fine till y.day. But today when I try to connect as sysdba i get the following error- let me know how to resolve the same
C:UsersAdministrator>set ORACLE_SID=sha
C:UsersAdministrator>sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 4 05:11:14 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup mount
ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) The paging file is too small for this operation to complete
View 4 Replies
View Related
May 20, 2013
error regarding oracle connection
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oradb As String = "Data Source=CallTaxi; UserName = SCOTT; Password=TIGER ;"
Dim conn As New OracleConnection(oradb)
conn.Open()
Dim cmd As New OracleCommand
[code]...
Error msg:
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.
View 1 Replies
View Related
