Amir's questions -server

Amir

Asked: 2017-09-08 21:41:43 +0800 CST

mount a windows folder in solaris 11.3

1

I want to check a folder which is placed in a windows server by my Oracle RDBMS12C. therefore based on my research first I need to mount the windows folder in solaris 11.3. we are using spark server.

I try to use below structure but I am not sure what is wrong with my format would you mind help me:

Format:

mount -F smbfs //[workgroup;][user[:password]@]server/share mount-point

my command:

mount -F smbfs //MyWorkGroup;MyUSERNAME:[email protected]/Share10 /myshare

I used below reference: Oracle Reference

I am receiving below error:

My password contains @ so it break into 2 part.

mount: Mount point cannot be determined
-bash: USERNAME:PASSWORD PART1: command not found
[2] 28436
-bash: PASSWORD [email protected]/Share10: No such file or directory
[2]   Exit 127                USERNAME:PASSWORD PART1

Also I want to check with you, many example used /mnt as destination, but I created a folder and called it "myshare" and I want to mount it to that folder, is this approach correct?

based on AndrewHenle comment I edited my script to:

mount -F smbfs '//MyWorkGroup;MyUSERNAME:[email protected]/Share10' /pshare

Now I am receiving this error:

/usr/lib/fs/smbfs/mount: can't resolve name "MyWorkGroup;MyUSERNAME:[email protected]", node name or service name not known

Amir

Asked: 2013-04-10 21:43:35 +0800 CST

Setup apache and SVN

0

Well I have an issue when I want to run SVN, I already explorer all the related question but I couldn't get what is wrong in my case. So that's why I decided to post my question in here, kindly help me to double check all the steps.

I am using Apache version 2.0 and my SVN version is 1.4.

I am receiving :"Forbidden You don't have permission to access /svn/ on this server." when I enter

 http://localhost/svn/

in my computer.

Forbidden You don't have permission to access /svn/ on this server.

Apache/2.0.64 (Win32) SVN/1.4.0 DAV/2 Server at localhost Port 80

I already setup my apache and SVN server based on here but I dont know what is wrong with my setup that I am receiving permission deny error message. I am wondering help me and double check my work to identify the root cause of problem.

my httpd.conf:

<Location /svn/>
    DAV svn
    SVNParentPath c:/svnroot/ 
    SVNListParentPath on
    AuthzSVNAccessFile bin/apachesvnauth 

    AuthType Basic 
    AuthName "Subversion repository" 
    AuthUserFile bin/apachesvnpasswd 

    Require valid-user                                 </Location>

my authentication file.

[/]
* = r 

[test1:/] 
user1 = rw 
user2 

[test2:/] 
user1 = r 
user2 = rw

If you need any more information keep me posted so I can share with you. I am using windows xp. one more thing I already assign all the read and write privilege for SVN and repository folder to my own user as well.

my apache log is as below:

> [Wed Apr 10 15:49:34 2013] [notice] Server built: Oct 18 2010 01:36:23
> [Wed Apr 10 15:49:34 2013] [notice] Parent: Created child process 1656
> [Wed Apr 10 15:49:35 2013] [notice] Child 1656: Child process is
> running [Wed Apr 10 15:49:35 2013] [notice] Child 1656: Acquired the
> start mutex. [Wed Apr 10 15:49:35 2013] [notice] Child 1656: Starting
> 250 worker threads. [Wed Apr 10 15:49:48 2013] [error] [client
> 10.8.8.139] Access denied: 'user1' GET svn:/

Amir

Asked: 2011-05-15 01:30:10 +0800 CST

How to connect an Oracle server between two countries and maintain high speeds for read & write

1

Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, and we are looking for a way with have high speeds for both branches but our company doesn't want spend lots of money for new servers.

What is your suggestion? Right now we create one environment in the India branch & we connect from Malaysia. Most of the time session will expire during applying the fixes.

How we can increase the speed & what is your suggestion for sharing one environment between two countries.

I suggested they hire a server between two county so speed will become higher but they didn't accept it because most of them are expensive....

Amir

Asked: 2011-04-07 15:36:33 +0800 CST

problem in run oracle server please help

-1

I used Oracle 11g, from few days ago I face below error:

SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: pentacms
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:

I try to solve the error, but it raised an other error, I try to open log file but I receive below error(last line) "ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [46], [32689], [32690], [], [], [], [], [], [], [] " please advice me, It's an emergency case.

FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
--------------- --------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP          PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER                                                BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCK FINAL_BLOCKING_INSTANCE
----------------- ---------------- ----------- -----------------------
FINAL_BLOCKING_SESSION       SEQ#     EVENT#
---------------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT                                                                   P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT                                                                   P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT                                                                   P3
---------------------------------------------------------------- ----------
P3RAW            WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS                                                        WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE               WAIT_TIME_MICRO TIME_REMAINING_MICRO
--------------- ------------------- --------------- --------------------
TIME_SINCE_LAST_WAIT_MICRO
--------------------------
SERVICE_NAME                                                     SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T SQL_TRACE_ SESSION_EDITION_ID CREATOR_ADDR     CREATOR_SERIAL#
----- ---------- ------------------ ---------------- ---------------
ECID
----------------------------------------------------------------
SYS$USERS                                                        DISABLED FALSE

SADDR                   SID    SERIAL#     AUDSID PADDR                 USER#
---------------- ---------- ---------- ---------- ---------------- ----------
USERNAME                          COMMAND    OWNERID TADDR
------------------------------ ---------- ---------- ----------------
LOCKWAIT         STATUS   SERVER       SCHEMA# SCHEMANAME
---------------- -------- --------- ---------- ------------------------------
OSUSER                         PROCESS
------------------------------ ------------------------
MACHINE                                                                PORT
---------------------------------------------------------------- ----------
TERMINAL
----------------
PROGRAM                                                          TYPE
---------------------------------------------------------------- ----------
SQL_ADDRESS      SQL_HASH_VALUE SQL_ID        SQL_CHILD_NUMBER SQL_EXEC_
---------------- -------------- ------------- ---------------- ---------
SQL_EXEC_ID PREV_SQL_ADDR    PREV_HASH_VALUE PREV_SQL_ID   PREV_CHILD_NUMBER
----------- ---------------- --------------- ------------- -----------------
PREV_EXEC PREV_EXEC_ID PLSQL_ENTRY_OBJECT_ID PLSQL_ENTRY_SUBPROGRAM_ID
--------- ------------ --------------------- -------------------------
PLSQL_OBJECT_ID PLSQL_SUBPROGRAM_ID
--------------- -------------------
MODULE                                           MODULE_HASH
------------------------------------------------ -----------
ACTION                           ACTION_HASH
-------------------------------- -----------
CLIENT_INFO
----------------------------------------------------------------
FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
--------------- --------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP          PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER                                                BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCK FINAL_BLOCKING_INSTANCE
----------------- ---------------- ----------- -----------------------
FINAL_BLOCKING_SESSION       SEQ#     EVENT#
---------------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT                                                                   P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT                                                                   P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT                                                                   P3
---------------------------------------------------------------- ----------
P3RAW            WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS                                                        WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE               WAIT_TIME_MICRO TIME_REMAINING_MICRO
--------------- ------------------- --------------- --------------------
TIME_SINCE_LAST_WAIT_MICRO
--------------------------
SERVICE_NAME                                                     SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T SQL_TRACE_ SESSION_EDITION_ID CREATOR_ADDR     CREATOR_SERIAL#
----- ---------- ------------------ ---------------- ---------------
ECID
----------------------------------------------------------------
FALSE FIRST EXEC                  0 000007FF5D4D8D70               2

SADDR                   SID    SERIAL#     AUDSID PADDR                 USER#
---------------- ---------- ---------- ---------- ---------------- ----------
USERNAME                          COMMAND    OWNERID TADDR
------------------------------ ---------- ---------- ----------------
LOCKWAIT         STATUS   SERVER       SCHEMA# SCHEMANAME
---------------- -------- --------- ---------- ------------------------------
OSUSER                         PROCESS
------------------------------ ------------------------
MACHINE                                                                PORT
---------------------------------------------------------------- ----------
TERMINAL
----------------
PROGRAM                                                          TYPE
---------------------------------------------------------------- ----------
SQL_ADDRESS      SQL_HASH_VALUE SQL_ID        SQL_CHILD_NUMBER SQL_EXEC_
---------------- -------------- ------------- ---------------- ---------
SQL_EXEC_ID PREV_SQL_ADDR    PREV_HASH_VALUE PREV_SQL_ID   PREV_CHILD_NUMBER
----------- ---------------- --------------- ------------- -----------------
PREV_EXEC PREV_EXEC_ID PLSQL_ENTRY_OBJECT_ID PLSQL_ENTRY_SUBPROGRAM_ID
--------- ------------ --------------------- -------------------------
PLSQL_OBJECT_ID PLSQL_SUBPROGRAM_ID
--------------- -------------------
MODULE                                           MODULE_HASH
------------------------------------------------ -----------
ACTION                           ACTION_HASH
-------------------------------- -----------
CLIENT_INFO
----------------------------------------------------------------
FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
--------------- --------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP          PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER                                                BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCK FINAL_BLOCKING_INSTANCE
----------------- ---------------- ----------- -----------------------
FINAL_BLOCKING_SESSION       SEQ#     EVENT#
---------------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT                                                                   P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT                                                                   P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT                                                                   P3
---------------------------------------------------------------- ----------
P3RAW            WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS                                                        WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE               WAIT_TIME_MICRO TIME_REMAINING_MICRO
--------------- ------------------- --------------- --------------------
TIME_SINCE_LAST_WAIT_MICRO
--------------------------
SERVICE_NAME                                                     SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T SQL_TRACE_ SESSION_EDITION_ID CREATOR_ADDR     CREATOR_SERIAL#
----- ---------- ------------------ ---------------- ---------------
ECID
----------------------------------------------------------------


SADDR                   SID    SERIAL#     AUDSID PADDR                 USER#
---------------- ---------- ---------- ---------- ---------------- ----------
USERNAME                          COMMAND    OWNERID TADDR
------------------------------ ---------- ---------- ----------------
LOCKWAIT         STATUS   SERVER       SCHEMA# SCHEMANAME
---------------- -------- --------- ---------- ------------------------------
OSUSER                         PROCESS
------------------------------ ------------------------
MACHINE                                                                PORT
---------------------------------------------------------------- ----------
TERMINAL
----------------
PROGRAM                                                          TYPE
---------------------------------------------------------------- ----------
SQL_ADDRESS      SQL_HASH_VALUE SQL_ID        SQL_CHILD_NUMBER SQL_EXEC_
---------------- -------------- ------------- ---------------- ---------
SQL_EXEC_ID PREV_SQL_ADDR    PREV_HASH_VALUE PREV_SQL_ID   PREV_CHILD_NUMBER
----------- ---------------- --------------- ------------- -----------------
PREV_EXEC PREV_EXEC_ID PLSQL_ENTRY_OBJECT_ID PLSQL_ENTRY_SUBPROGRAM_ID
--------- ------------ --------------------- -------------------------
PLSQL_OBJECT_ID PLSQL_SUBPROGRAM_ID
--------------- -------------------
MODULE                                           MODULE_HASH
------------------------------------------------ -----------
ACTION                           ACTION_HASH
-------------------------------- -----------
CLIENT_INFO
----------------------------------------------------------------
FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
--------------- --------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP          PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER                                                BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCK FINAL_BLOCKING_INSTANCE
----------------- ---------------- ----------- -----------------------
FINAL_BLOCKING_SESSION       SEQ#     EVENT#
---------------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT                                                                   P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT                                                                   P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT                                                                   P3
---------------------------------------------------------------- ----------
P3RAW            WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS                                                        WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE               WAIT_TIME_MICRO TIME_REMAINING_MICRO
--------------- ------------------- --------------- --------------------
TIME_SINCE_LAST_WAIT_MICRO
--------------------------
SERVICE_NAME                                                     SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T SQL_TRACE_ SESSION_EDITION_ID CREATOR_ADDR     CREATOR_SERIAL#
----- ---------- ------------------ ---------------- ---------------
ECID
----------------------------------------------------------------


16 rows selected.

SQL> desc dba_user;
ERROR:
ORA-04043: object dba_user does not exist


SQL> desc dba_users;
ERROR:
ORA-04043: object dba_users does not exist


SQL> desc v$user;
ERROR:
ORA-04043: object v$user does not exist


SQL> desc v$users
ERROR:
ORA-04043: object v$users does not exist


SQL> seleect * from dba_users;
SP2-0734: unknown command beginning "seleect * ..." - rest of line ignored.
SQL> select * from dba_users;
select * from dba_users
              *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[46], [32689], [32690], [], [], [], [], [], [], []


SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted


SQL> alter database mount;

Amir

Asked: 2011-03-08 20:38:27 +0800 CST

how modify username in oracle

2

I create a username in oracle that has spelling mistake, I want to modify it now but I am not successful. would you please help me how I can modify my username in all_users table? I use oracle 9.

mount a windows folder in solaris 11.3

Setup apache and SVN

How to connect an Oracle server between two countries and maintain high speeds for read & write

problem in run oracle server please help

how modify username in oracle

Can you pass user/pass for HTTP Basic Authentication in URL parameters?

Ping a Specific Port

Check if port is open or closed on a Linux server?

How to automate SSH login with password?

How do I tell Git for Windows where to find my private RSA key?

What's the default superuser username/password for postgres after a new install?

What port does SFTP use?

Command line to list users in a Windows Active Directory group?

What is a Pem file and how does it differ from other OpenSSL Generated Key File Formats?

How to determine if a bash variable is empty?